Computers consuming license

Products

• IT Management Suite

Issue/Introduction

Here's a script to shows which computers are consuming licenses

Environment

ITMS 8.x

Resolution

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 = '%%'