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
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%'