KACE 1000 Create Report Service Windows Name and Status (Running or Stopped)
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
Answers (2)
Please log in to answer
Posted by:
chucksteel
7 years ago
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.
Posted by:
mdickson@markandy.com
1 year ago
Hello, we're using KACE SMA v13.
I would like to use this report but to report only on devices that are servers. Using the OS Name Windows Server *
I realize this is an old post but I'm struggling to understand how to do this.
