ITNinja

Simply set the service name and the software display name.

SQL Code:

SELECT MACHINE.NAME AS Machine, NTSERVICE.DISPLAY_NAME AS 'Service Name', NTSERVICE.FILE_NAME AS 'Process Name', NTSERVICE.STARTUP_TYPE AS 'Startup Type',NTSERVICE.STATUS AS Status FROM MACHINE
JOIN MACHINE_SOFTWARE_JT ON (MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID)
JOIN SOFTWARE ON (SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID)
JOIN MACHINE_NTSERVICE_JT ON (MACHINE.ID = MACHINE_NTSERVICE_JT.MACHINE_ID)
JOIN NTSERVICE ON (NTSERVICE.ID = MACHINE_NTSERVICE_JT.NTSERVICE_ID)
WHERE (NTSERVICE.FILE_NAME like "ServiceName.exe" AND NTSERVICE.STATUS not like "SERVICE_RUNNING" AND SOFTWARE.DISPLAY_NAME like "Software Display Name")
ORDER BY MACHINE.NAME