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
Answers (1)
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
