/build/static/layout/Breadcrumb_cap_w.png

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.


0 Comments   [ + ] Show comments

Answers (2)

Posted by: KevinG 1 month ago
Red Belt
0

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'


Posted by: totim 1 month ago
Orange Belt
0

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!



 
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