Queries for determining licenses in use

Products

• IT Management Suite

Issue/Introduction

 You are looking for a query to verify what client machines are using licenses.

Environment

ITMS 8.x

Resolution

The following queries will help determine what resources are using active licenses:

Use the following query, adding the appropriate GUID for the product information

SELECT i.name 'Solution', vi.name 'Machine Name'
FROM LicenseInUse liu
JOIN vItem vi ON
vi.guid = liu.resourceguid
Join item i ON
i.guid = liu.licensingPolicyGuid
where liu.licensingPolicyGuid like '<Product GUID>'

GUIDs:
You can get a list of solution's GUIDs with the following query:

SELECT i.name 'Solution License', liu.licensingPolicyGUID 'guid'
from LicenseInUse liu
Join Item i on
i.guid = liu.licensingPolicyGuid

Here are some Solutions GUIDs as example:

Inventory Solution	CD39B720-F871-11D2-8643-00104B74A9DF
Inventory Pack for Servers	6772A2A4-DD9D-4497-89CD-15FBF7DE3F7D
Altiris Patch Management Solution	C6D19F78-1434-49AC-BEC8-D18255E99F57
Altiris Software Management Solution	AD3F5980-D9E9-11D3-A318-0008C7A09198
Deployment Solution	2C9A27A0-A5B4-4D9E-9D5B-B2E0A3FA99E5