TypeType:truefalseptype-stringManaged Software10Managed SoftwareAll Software73bded50-f1aa-4ff4-a80e-a6c9e047d472VersionVersion:truefalseptype-string%1073bded50-f1aa-4ff4-a80e-a6c9e047d472NameName:truefalseptype-string%1073bded50-f1aa-4ff4-a80e-a6c9e047d472Discovered sinceDiscovered since:truefalsePType-DateTimeNOW-301073bded50-f1aa-4ff4-a80e-a6c9e047d472CompanyCompany:truefalseptype-string%1073bded50-f1aa-4ff4-a80e-a6c9e047d472Installed Software{cd39b720-f871-11d2-8643-00104b74a9df}Hidden, NoReplication, ReadonlyAltiris.Reporting.DataSource.RawSqlDataSourceAltiris.Reporting.DataSource, Version=8.1.4528.0, Culture=neutral, PublicKeyToken=d516cb311cfb6e4fGuidCompanyfalsefalseptype-string%1073bded50-f1aa-4ff4-a80e-a6c9e047d472Computer Namefalsefalseptype-string%1073bded50-f1aa-4ff4-a80e-a6c9e047d472Discovered sincefalsefalsePType-DateTimeNOW-301073bded50-f1aa-4ff4-a80e-a6c9e047d472Namefalsefalseptype-string%1073bded50-f1aa-4ff4-a80e-a6c9e047d472Software Namefalsefalseptype-string%1073bded50-f1aa-4ff4-a80e-a6c9e047d472TrusteeScopeScoping ParametertruefalsePType-ScopeTrusteeListS-1-1-0,S-1-5-21-584045613-2877177974-2588806179-1006,S-1-5-21-584045613-2877177974-2588806179-10181073bded50-f1aa-4ff4-a80e-a6c9e047d472Typefalsefalseptype-stringManaged Software1073bded50-f1aa-4ff4-a80e-a6c9e047d472Versionfalsefalseptype-string%1073bded50-f1aa-4ff4-a80e-a6c9e047d472= '%Discovered since%'
ORDER BY spi.Name
ELSE
IF ('%Type%' = 'All Software')
BEGIN
SELECT sci.[Guid]
,sci.Name
,sc.[Version]
,company.Name AS [Company]
,inst.cnt AS [Count]
FROM vRM_Software_Component_Item sci
JOIN Inv_Software_Component sc
ON sci.Guid = sc._ResourceGuid
JOIN (SELECT COUNT(DISTINCT _ResourceGuid) AS cnt, _SoftwareComponentGuid
FROM Inv_InstalledSoftware iis
Join vComputer comp on iis._ResourceGuid=comp.Guid
JOIN #sctemp sct on sct.Guid= iis._ResourceGuid
WHERE InstallFlag = 1
GROUP BY _SoftwareComponentGuid)inst
ON inst._SoftwareComponentGuid = sci.Guid
LEFT JOIN (SELECT ra.ParentResourceGuid AS sofCompGuid, rc.Name
FROM RM_ResourceCompany rc
JOIN ResourceAssociation ra
ON ra.ChildResourceGuid = rc.Guid
AND ra.ResourceAssociationTypeGuid = '292DBD81-1526-423A-AE6D-F44EB46C5B16')company
ON company.sofCompGuid = sci.Guid
WHERE ('%Name%' = '%' OR LOWER (sci.Name) LIKE LOWER ('%Name%'))
AND ('%Version%' = '%' OR sc.[Version] LIKE '%Version%')
AND ('%Company%' = '%' OR LOWER (company.Name) LIKE LOWER ('%Company%'))
AND sci.[CreatedDate] >= '%Discovered since%'
ORDER BY sci.Name
END
drop table #sctemp
]]>7717fb81-325b-4acf-ba4a-2774fb03a072LinkMenu7717fb81-325b-4acf-ba4a-2774fb03a072