Custom Report Needed
I’m need to create a report that will list all the machine that have a certain service either running or stopped. The columns needed would be as follows.
Machine Name
Service/Display Name
Startup Type
Status
File Name
Thank You,
Eliud
Machine Name
Service/Display Name
Startup Type
Status
File Name
Thank You,
Eliud
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
GillySpy
12 years ago
select
M.NAME "Machine Name",
NT.NAME "Service/Display Name",
STARTUP_TYPE "Startup Type",
STATUS "Status",
FILE_NAME "File Name"
FROM MACHINE M JOIN MACHINE_NTSERVICE_JT MN ON M.ID=MACHINE_ID
JOIN NTSERVICE NT ON NTSERVICE_ID=NT.ID
WHERE STATUS IN ('SERVICE_RUNNING', 'SERVICE_STOPPED')
and NT.NAME='servicenamehere' /* although you might actually want DISPLAY_NAME */
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.