Report needed on Services running
Hi All,
I need a report that will display the following info:
Thank You in advance.
Answers (3)
Do you want a report for just this one service that displays this specific information? Normally you would use reporting to display information for many computers or services, not just one particular item.
If that is all you want
SELECT N.CREATED, N.MODIFIED, N.NAME, N.DISPLAY_NAME, N.STARTUP_TYPE, N.STATUS, N.DESCRIPTION, N.LOGON_AS_USER, N.CAN_INTERACT_WITH_DESKTOP, N.COMMAND_EXE, N.COMMAND_ARGS, N.FILE_NAME, N.FILE_DESCRIPTION, N.FILE_VERSION, N.PRODUCT_NAME, N.PRODUCT_VERSION, N.COMPANY_NAME FROM NTSERVICE N
WHERE N.NAME = "McAfeeFramework";
Comments:
-
Thx but I want to know on which pc's these mcafee services are running on and on which pc's these mcafee services is not running on. - Mariusja 11 years ago
This will work. Not sure of what all info you need. This will get what machines have it. I'm not sure if you need the specific file version. If not you can remove what's in bold.
SELECT M.NAME, IP, USER_LOGGED FROM NTSERVICE N LEFT JOIN MACHINE_NTSERVICE_JT MN ON MN.NTSERVICE_ID = N.ID LEFT JOIN MACHINE M ON M.ID=MN.MACHINE_ID WHERE N.NAME ='McAfeeFramework' AND N.FILE_VERSION = '4.6.3122'
This will get what machines do not have it.
SELECT M.NAME, IP, USER_LOGGED FROM NTSERVICE N LEFT JOIN MACHINE_NTSERVICE_JT MN ON MN.NTSERVICE_ID = N.ID LEFT JOIN MACHINE M ON M.ID=MN.MACHINE_ID WHERE N.NAME !='McAfeeFramework' AND N.FILE_VERSION = '4.6.3122'
