/build/static/layout/Breadcrumb_cap_w.png

inventory query report in sofware change

I'm looking for a query report for data data detect software installed date on the machine, as shown below

ABAAAAAElFTkSuQmCC


0 Comments   [ + ] Show comments

Answers (1)

Posted by: KevinG 2 years ago
Red Belt
0

if the software table has an install_date, you can use this example and modify it to detect your particular SW item.  Modify the WHERE clause.

SELECT SOFTWARE.DISPLAY_NAME,  SOFTWARE.INSTALL_DATE, SOFTWARE.CREATED,  SOFTWARE.FILE_NAME, MACHINE.NAME AS 'Device Name' FROM SOFTWARE
LEFT JOIN MACHINE_SOFTWARE_JT ON MACHINE_SOFTWARE_JT.SOFTWARE_ID =   SOFTWARE.ID
LEFT JOIN MACHINE ON MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
WHERE SOFTWARE.DISPLAY_NAME LIKE '7-Zip%'

 
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