SQL Query to list Computers consuming licenses

Products

• IT Management Suite

Issue/Introduction

SQL Query to shows list computers consuming licenses with the Product name ( like Inventory , Patch Management )

Environment

ITMS 8.x

Resolution

Run the below SQL query against the Altiris Database (default Database name is "Symantec_CMDB" ) to list computers consuming licenses with the Product name 

SELECT rc.Guid AS ComputerGuid, rc.Name AS ComputerName, i.Name AS ProductName
FROM LicenseInUse lic
join
( SELECT rc.Guid,rc.ResourceTypeGuid, rc.Name, rc.IsManaged, rc.[Deleted] FROM [RM_ResourceVirtual_Machine] rc
    UNION ALL
    SELECT rc.Guid,rc.ResourceTypeGuid, rc.Name, rc.IsManaged, rc.[Deleted] FROM [RM_ResourceComputer] rc
    ) rc ON rc.Guid = lic.ResourceGuid
join Item i ON i.Guid = lic.LicensingPolicyGuid
--WHERE rc.Name = '%%'

 

Please note: Broadcom always recommend to have full working Altiris Database backup for safer side.