Helpful Software reports

Here are a couple of helpful reports when looking for more software information.

Softwares by workstation

select WORKSTATIONNAME,SOFTWARENAME,PRODUCTVERSION,COMPANYNAME,SOFTWARETYPE from SystemInfo sys LEFT JOIN SoftwareInfo soft ON sys.WORKSTATIONID=soft.WORKSTATIONID LEFT JOIN SoftwareList softl ON soft.SOFTWAREID = softl.SOFTWAREID LEFT JOIN SoftwareType st ON st.SOFTWARETYPEID=softl.SOFTWARETYPEID order by 1

Change this to the following to find all software titles on a specific workstation in a report format. Replace NAMEHERE with the workstation name.

Softwares by workstation

select WORKSTATIONNAME,SOFTWARENAME,PRODUCTVERSION,COMPANYNAME,SOFTWARETYPE from SystemInfo sys LEFT JOIN SoftwareInfo soft ON sys.WORKSTATIONID=soft.WORKSTATIONID LEFT JOIN SoftwareList softl ON soft.SOFTWAREID = softl.SOFTWAREID LEFT JOIN SoftwareType st ON st.SOFTWARETYPEID=softl.SOFTWARETYPEID WHERE WORKSTATIONNAME ='NAMEHERE' order by 1