Modify Query Report

Modify Query Report

SELECT (SoftwareList.SOFTWARENAME) "Software_Name",
MAX(aaov.NAME) "Site",
MAX(SystemInfo.WORKSTATIONNAME) "Workstation" 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 Resources resource ON systeminfo.WORKSTATIONID=resource.RESOURCEID
LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID
LEFT JOIN SiteDefinition siteDef ON resLocation.SITEID=siteDef.SITEID
LEFT JOIN SDOrganization aaov ON siteDef.SITEID=aaov.ORG_ID


 I'd like to add Department, location last logged in User to this query report

  9.2  Build  9230
MSSQL
              New to ADManager Plus?

                New to ADSelfService Plus?