Client Management Suite

Is there any report in Altiris server in which I can see what software are installed on which machine’s.

Hello,

Please check .

go to Reports > All Reports, then expand Reports > Discovery and Inventory > Inventory > Cross-platform > Software/Applications > Installed Software or Installed Software by Computer

http://www.symantec.com/connect/forums/sql-querry-altiris-report

https://www-secure.symantec.com/connect/forums/how...

https://www-secure.symantec.com/connect/forums/alt...

Default reports available

Go to Reports > All Reports, then expand Reports > Discovery and Inventory > Inventory > Cross-platform > Software/Applications > Installed Software or Installed Software by Computer.  For example, using the Installed Software report, type '%Adobe%' for the Company OR '%Lync%' for the Name

Either search the name of reports which you require.

Check

https://www-secure.symantec.com/connect/forums/report-or-sql-query-get-all-software-releases-packages

https://www-secure.symantec.com/connect/forums/sql-querry-altiris-report

Hi,

  Please check the following query

SELECT DISTINCT
i.Name AS [Computer Name],
sc.[Name] AS [Software Name],
isc.[Version],
vc.[Name] AS [Company]
FROM vSoftwareComponent sc
LEFT JOIN (ResourceAssociation ra
JOIN dbo.RM_ResourceCompany vc
ON vc.Guid = ra.ChildResourceGuid)
ON sc.Guid = ra.ParentResourceGuid
AND ra.ResourceAssociationTypeGuid = '292DBD81-1526-423A-AE6D-F44EB46C5B16'
LEFT JOIN dbo.Inv_InstalledSoftware iis
ON iis._SoftwareComponentGuid = sc.Guid
AND iis._ResourceGuid iS NOT NULL
AND iis.InstallFlag = 1
LEFT JOIN dbo.Inv_Software_Component isc
ON isc._ResourceGuid = sc.Guid
JOIN dbo.vComputerEx i
ON i.Guid = iis._ResourceGuid
--WHERE LOWER (i.Name) LIKE LOWER ('%Computer%') --Uncomment this if you wish to create a custom report which can filter the results based on a Query Parameter
WHERE sc.Name not like '%Altiris%'
AND sc.Name not like 'Security Update%'
AND sc.Name not like 'Hotfix for %'
AND sc.Name not like 'Update for %'
AND sc.Name not like '%.msu%'
AND sc.Name not like '%.exe%'
AND sc.Name not like '%.msi%'
AND sc.Name not like '%.msp%'
AND sc.Name not like '%.zip%'
AND sc.Name not like ''
AND len(isnull([IP Address],'')) <> 0
and I.FQDN NOT IN (SELECT Name FROM vSource) --Remove this line should you wish to include the Notification Server in the report results
ORDER BY I.Name