/build/static/layout/Breadcrumb_cap_w.png
10/11/2019 109 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