/build/static/layout/Breadcrumb_cap_w.png

Kace report to list versions of one software on all machines that have a different software installed.

I'm trying to pull a report that will display the version of Microsoft Office installed on machines that have a different program installed, let's say Adobe.  So I have a report that pulls all the machines and versions of Office across the org, and I have a report that pulls all the machines and versions of Adobe, but I'm struggling to combine them.  I was trying to nest them at the From , but haven't been able to get the query to compile.  Below is one of the SQL queries for just Microsoft Office as they are identical except for the like %xxx% .

select MACHINE.NAME as Computer_Name,
SOFTWARE.DISPLAY_NAME,
SOFTWARE. DISPLAY_VERSION,
MACHINE.IP,
MACHINE.MAC
from SOFTWARE
join MACHINE_SOFTWARE_JT on SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
join MACHINE on MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
where SOFTWARE.DISPLAY_NAME like '%Microsoft Office%' and not IS_PATCH
order by Computer_Name, SOFTWARE.DISPLAY_NAME


0 Comments   [ + ] Show comments

Answers (1)

Posted by: Mashby1 2 years ago
Purple Belt
0

If you just want them all listed you need an OR in your where clause and to add the adobe line whatever it is, like:


select MACHINE.NAME as Computer_Name,

SOFTWARE.DISPLAY_NAME,

SOFTWARE. DISPLAY_VERSION,

MACHINE.IP,

MACHINE.MAC

from SOFTWARE

join MACHINE_SOFTWARE_JT on SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID

join MACHINE on MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID

where SOFTWARE.DISPLAY_NAME like '%Microsoft Office%' and not IS_PATCH

or SOFTWARE.DISPLAY_NAME like '%Adobe%' 

order by Computer_Name, SOFTWARE.DISPLAY_NAME



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