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