Hello,

I need some help how to get Report Service Windows Name and Status,

report format like this,

DEVICE_NAME | SERVICE_NAME | SERVICE_STATUS


best regards,

thx

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0
Here you go:
SELECT M.NAME, S.DISPLAY_NAME, S.STATUS
FROM MACHINE M
JOIN MACHINE_NTSERVICE_JT JT on JT.MACHINE_ID = M.ID
JOIN NTSERVICE S on S.ID = JT.NTSERVICE_ID
ORDER BY M.NAME, S.DISPLAY_NAME
Keep in mind that the data will be based on the last time the inventory ran on each machine and some services might only run when there is a user logged into the computer.
Answered 04/19/2017 by: chucksteel
Red Belt

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