help with software installation report managed

help with software installation report managed

Lords 
The following query would add that region belong, can you help me where I can add that line.

select WORKSTATIONNAME as "Workstation", MODEL as "Modelo", SERVICETAG as "N° de serie", SOFTWARENAME as "Software", rest.DISPLAYSTATE as "State",aau.FIRST_NAME as "User", dd.DEPTNAME as "Department", sdorg.NAME as "Site", (SELECT CASE WHEN sinf.LICENSEID IS NULL THEN 'No' ELSE 'Yes' END) as "Is Licensed" from SoftwareList slist  LEFT JOIN SoftwareInfo sinf ON slist.SOFTWAREID = sinf.SOFTWAREID LEFT JOIN SystemInfo sys ON sinf.WORKSTATIONID = sys.WORKSTATIONID LEFT JOIN SoftwareType stype ON slist.SOFTWARETYPEID = stype.SOFTWARETYPEID  LEFT JOIN SWInstallationKeyInfo swins ON sinf.SOFTWAREINFOID = swins.SOFTWAREINFOID LEFT JOIN WmiSwUsageInfo uinf ON sinf.SOFTWAREINFOID = uinf.SOFTWAREINFOID  LEFT JOIN Resources res ON sys.WORKSTATIONID = res.RESOURCEID LEFT JOIN ResourceOwner reso ON res.RESOURCEID = reso.RESOURCEID LEFT JOIN DepartmentDefinition dd ON reso.DEPTID = dd.DEPTID LEFT JOIN SDUser sdu ON reso.USERID = sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID = aau.USER_ID LEFT JOIN ResourceLocation ON res.RESOURCEID = ResourceLocation.RESOURCEID LEFT JOIN SiteDefinition sd ON ResourceLocation.SITEID = sd.SITEID LEFT JOIN SDOrganization sdorg ON sd.SITEID = sdorg.ORG_ID LEFT JOIN ResourceState rest ON res.RESOURCESTATEID = rest.RESOURCESTATEID WHERE SOFTWARETYPE = 'Managed' <SITE_CRITERIA> ORDER BY 4
              New to ADManager Plus?

                New to ADSelfService Plus?