Edit report for date on installation and deinstallation of Software
Hello Community!
I would like to ask you to help me with a report.
I need to find out, when a Installation and also the Deinstallation was done.
Here is the report to find out, which software was installed:
SELECT workstation.WORKSTATIONNAME "ResourceName",
workstation.MODEL "Model",workstation.LOGGEDUSER "Last Logged In User",sl.softwarename
"Software" FROM SystemInfo workstation
LEFT JOIN OsInfo osInfo ON workstation.WORKSTATIONID=osInfo.WORKSTATIONID
LEFT JOIN SystemInfoDomain sysInfod ON workstation.WORKSTATIONID=sysInfod.WORKSTATIONID
LEFT JOIN DomainInfo dominf ON sysInfod.DOMAINID=dominf.DOMAINID
LEFT JOIN networkinfo ni on workstation.WORKSTATIONID=ni.workstationid
LEFT JOIN resources rs on workstation.WORKSTATIONID=rs.resourceid
LEFT JOIN softwareinfo si on workstation.WORKSTATIONID=si.workstationid
LEFT JOIN softwarelist sl on si.softwareid=sl.softwareid
WHERE sl.softwarename LIKE '«CD%'
Is that possible? How do i need to change the report? Looking forward for your response.
Thank you!
New to ADSelfService Plus?