'Patches reported installed in Software Inventory' report K1000
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?