Custom report to list specific software installed on compute
Hello, I have part of the answer to this, but I need to be able to list the user assigned to the computer as well. Currently I have the below query and I modify it to list all computers with a specific application installed. Can anyone help me add the userid to the output?
select si.workstationname, sl.softwarename from systeminfo si, softwareinfo sif, softwarelist sl
where si.workstationid = sif.workstationid
and sif.softwareid = sl.softwareid
and sl.softwarename like '%AutoTurn%'
order by si.workstationname
select si.workstationname, sl.softwarename from systeminfo si, softwareinfo sif, softwarelist sl
where si.workstationid = sif.workstationid
and sif.softwareid = sl.softwareid
and sl.softwarename like '%AutoTurn%'
order by si.workstationname