/build/static/layout/Breadcrumb_cap_w.png

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 3 years ago

Answers (0)

Be the first to answer this question

Don't be a Stranger!

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

Sign up! or login

View more:

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