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:
Post a Comment