31 January 2014

Getting the Patch List

How to know which aplications Altiris 7.5 patches?

Run this Qry in SQL or create a report:

SELECT     comp.Name AS Company, vi.Name AS Product
FROM         Inv_Software_Release_Platform AS rp INNER JOIN
                      ResourceAssociation AS ra ON ra.ParentResourceGuid = rp._ResourceGuid AND
                      ra.ResourceAssociationTypeGuid = '292dbd81-1526-423a-ae6d-f44eb46c5b16' LEFT OUTER JOIN
                      RM_ResourceCompany AS comp ON ra.ChildResourceGuid = comp.Guid INNER JOIN
                      RM_ResourceSoftware_Release AS vi ON vi.Guid = rp._ResourceGuid
ORDER BY Company, Product

Press Crtl A in the result pane and past it to Excel...;-)

No comments: