/build/static/layout/Breadcrumb_cap_w.png

'Patches reported installed in Software Inventory' report K1000

Hi all,

Need some help please.

I am trying to create a report that shows ' Patches reported installed in Software Inventory' as shown in the inventory for each device if you manualy look, but for an estate of 5000 devices. I undertand the csv will be huge.

I can do this individually with the following:

SELECT SOFTWARE.DISPLAY_NAME, SOFTWARE.PUBLISHER FROM ORG1.SOFTWARE

JOIN MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID

JOIN MACHINE on MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID

WHERE IS_PATCH = 1

and MACHINE.NAME = "*********"

But it would take an age for 5000 devices. Is there a way I can run the above across all devices, or does anybody know a way?

Thanks





0 Comments   [ + ] Show comments

Answers (1)

Posted by: getElementById 6 years ago
Third Degree Blue Belt
0
Basically you'll want to remove the "and machine.name=" from your WHERE statement and it will give you all machines (because you're not specifying a particular machine). I would add "MACHINE.NAME" to your select so you know which machine each record is for. 

SELECT MACHINE.NAME, SOFTWARE.DISPLAY_NAME, SOFTWARE.PUBLISHER 
FROM ORG1.SOFTWARE
  JOIN MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
  JOIN MACHINE on MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
WHERE IS_PATCH = 1

 
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