I would like to create a SQL query to report on lists of all discovered software on computers
Hi
I have this report that I am using which reports on Installed Software installed on computers:
***
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
***
The report returns a list with
<Computer Name>, <Software Name>, <Software Version>
But this report is looking at Installed Software only. I would like to be able to have a similar report where it would list Discovered Software instead of just Installed Software.
Does anyone know how to do it? What table would we use to look at Discovered Software?
1 Comment
[ + ] Show comment
-
I believe you'll want to have it report from Software Catalog rather than just Software. You should be able to target Discovered Software from there. - Gauntlet87 4 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
