Report request in software

Report request in software

hi, i  have a simple  software report  showing pc name, softwre,company, key, if is licenced and location.  but i can't found the "agreement licence number"  to add it. 
can anybody help me. 

thanks in advanced.

here is  the actual query 


select WORKSTATIONNAME, SOFTWARENAME as "Softwre ",mfg.NAME as "Company",  PRODUCTKEY as "Key", (SELECT CASE WHEN sinf.LICENSEID IS NULL THEN 'No' ELSE 'SI' END) as "Licenced", ResourceLocation.LOCATION from SystemInfo sys LEFT JOIN SoftwareInfo sinf ON sys.WORKSTATIONID = sinf.WORKSTATIONID LEFT JOIN ResourceLocation ON sys.WORKSTATIONID = ResourceLocation.RESOURCEID LEFT JOIN SoftwareList slist ON sinf.SOFTWAREID = slist.SOFTWAREID LEFT JOIN SoftwareType stype ON slist.SOFTWARETYPEID = stype.SOFTWARETYPEID LEFT JOIN SoftwareCategory swcat ON slist.SOFTWARECATEGORYID = swcat.SOFTWARECATEGORYID LEFT JOIN SWInstallationKeyInfo swins ON sinf.SOFTWAREINFOID = swins.SOFTWAREINFOID LEFT JOIN WmiSwUsageInfo uinf ON sinf.SOFTWAREINFOID = uinf.SOFTWAREINFOID LEFT JOIN SoftwareManufacturer mfg ON slist.SWMANUFACTURERID = mfg.SWMANUFACTURERID <SITE_CRITERIA> ORDER BY 1
      • Topic Participants

      • CIT

              New to ADManager Plus?

                New to ADSelfService Plus?