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 ADSelfService Plus?