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
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
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 */
Answered 08/17/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
Exactly what I needed, Thank You.

Eliud
Answered 08/22/2011 by: erobledo
Yellow Belt

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