/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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