Specific Software install Report
I am trying to create a report that lists a specific software title and where it is installed, ultimately displaying the software name, version and device it is installed on, using the Wizard as I am not at all familiar with SQL. Any help would be appreciated.
Answers (2)
What is the version of the SMA?
What is the exact name of the Software?
Does the Software item you want to report show up under installed programs or discovered software?
There are existing built-in reports that can be duplicated and modified. This is a modification of the SQL from the existing report with the title of
"Software Title & Version - Computer List".
I added to the where clause to look for devices that have Adobe Photoshop 2023 installed.
select CONCAT(DISPLAY_NAME, " (", DISPLAY_VERSION ,")") as Software_Title,
MACHINE.NAME as Computer_Name,
SYSTEM_DESCRIPTION,
IP
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
and SOFTWARE.DISPLAY_NAME = 'Adobe Photoshop 2023'
Hi KevinG,
Our SMA is Version: 12.1.169.
The software is Read&Write. It shows up under Software inventory, it does not show in Software Catalog.
I used your SQL modification replacing Adobe Photoshop 2023 with Read&Write and it worked perfectly, exactly what I was looking for. Thanks so much for your help!