Hi All,

I need a report that will display the following info:

 

Thank You in advance.

 

 

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

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.

Answered 03/07/2013 by: chucksteel
Red Belt

Please log in to comment
0

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";

Answered 03/07/2013 by: nshah
Red Belt

  • 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.
Please log in to comment
0

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'
Answered 03/08/2013 by: dugullett
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity