Can I create a report that just lists the computer name and the services running on the computer?
Currently I am using a report that gives me the computer name, and the software name running on the machine. The output of the report is like this:
This is the SQL query for the report
select MACHINE.NAME as Computer_Name, DISPLAY_NAME as Software_Name, DISPLAY_VERSION as Software_Version
from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE)
where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
and not IS_PATCH
order by Computer_Name