/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Can I create a report that just lists the computer name and the services running on the computer?

10/11/2019 244 views

Hi


Currently I am using a report that gives me the computer name, and the software name running on the machine.  The output of the report is like this:


computer1, software1

computer1, software2

...

computer2,softwarea

computer2,softwareb


This is the SQL query for the report

select MACHINE.NAME as Computer_Name, DISPLAY_NAME as Software_Name, DISPLAY_VERSION as Software_Version
from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE)
where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
and not IS_PATCH
order by Computer_Name


Is it possible to create a similar report listing out all the services running on a computer?  Where the report would be:
computer1, service1
computer1, service2
etc

like that?

0 Comments   [ + ] Show comments

Comments


All Answers

1

use the report wizard

choose topic "device" and subtopic of "services" on page 1

choose "system name" under Device Identity info and "service name" under service information on page 2

choose any filters on page 5 such a OS name contains "windows"


Answered 10/11/2019 by: SMal.tmcc
Red Belt

1

Nevermind, I figured out the SQL query

select MACHINE.NAME as Computer_Name, NTSERVICE.NAME as Service_Name

FROM NTSERVICE

left join NTSERVICE_LABEL_JT on NTSERVICE.ID = NTSERVICE_LABEL_JT.NTSERVICE_ID

left join MACHINE_NTSERVICE_JT on MACHINE_NTSERVICE_JT.NTSERVICE_ID = NTSERVICE.ID

join MACHINE on MACHINE_NTSERVICE_JT.MACHINE_ID = MACHINE.ID

WHERE ((( exists  (select 1 from MACHINE,MACHINE_NTSERVICE_JT where NTSERVICE.ID = MACHINE_NTSERVICE_JT.NTSERVICE_ID and MACHINE.ID=MACHINE_NTSERVICE_JT.MACHINE_ID)) ))

order by Computer_Name


I'm remotely connecting to the appliance to retrieve my report so I needed the SQL query.




Answered 10/11/2019 by: tuyen
Orange Senior Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ