Happy Holidays All,
I have a custom query that provides a report of Assets that have a specific piece of software installed.  In this case it is "MPLTransact".  It works but I want to add Site, IP, User, & Assigned User to the Report but can't figure out how to get it to work could someone assist?
Here's what I have so far...

======

SELECT SystemInfo.WORKSTATIONNAME "Workstation",
max(state.DISPLAYSTATE) "Asset State",
max(osInfo.OSNAME),
(SoftwareList.SOFTWARENAME) "Software_Name",
MAX(swmfg.NAME) "Manufacturer",
MAX(SoftwareInfo.FILEVERSION) "Version" FROM SoftwareInfo
LEFT JOIN SoftwareList ON SoftwareInfo.SOFTWAREID=SoftwareList.SOFTWAREID
LEFT JOIN SoftwareType ON SoftwareList.SOFTWARETYPEID=SoftwareType.SOFTWARETYPEID
LEFT JOIN Systeminfo ON SoftwareInfo.WORKSTATIONID=SystemInfo.WORKSTATIONID
LEFT JOIN SoftwareManufacturer swmfg ON SoftwareList.SWMANUFACTURERID=swmfg.SWMANUFACTURERID
LEFT JOIN OsInfo osInfo ON Systeminfo.WORKSTATIONID=osInfo.WORKSTATIONID
LEFT JOIN Resources resource ON systeminfo.WORKSTATIONID=resource.RESOURCEID
LEFT JOIN ResourceState state ON resource.RESOURCESTATEID=state.RESOURCESTATEID
WHERE  SoftwareList.SOFTWARENAME like '%MPLTransact%' and state.DISPLAYSTATE in ('In Use','In Store') GROUP BY SystemInfo.WORKSTATIONNAME,SoftwareList.SOFTWARENAME
ORDER BY 1

======