Can you get a report to only display one Software Title for a device?
I'm trying to create a report that pulls all machines that have software installed from a specific publisher. We have three different software titles that could be installed from this publisher. I can get the report to pull correctly, and it is showing all the devices I expect when compared to the software inventory list inside Kace. However, I can't get the report to just show which of the three titles is installed. If I display the 'Software Titles' I get every bit of software installed, and the same is true for 'Software Version'. I'd like to just display the device name, the name of the software installed (of the three from the publisher) and the version installed. Is this possible? Can I just pull a report against the 'Devices Detected' list at the bottom of the software detail page? I could make 3 different reports, one for each software, but I'd like to see if this is possible before going that route.
Maybe you can use this SQL and edit it to meet your needs.
select MACHINE.NAME as Computer_Name,
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 '%MicroMain%' and not IS_PATCH
order by Computer_Name, SOFTWARE.DISPLAY_NAME
There is also the built-in report with the title of "Software Title & Version - Computer List" that may be of interest to you.
You can duplicate it and modify the copy to meet your needs.
You may want to provide the following additional information.
The SQL you are currently using?