Queries for determining licenses used.

book

Article ID: 180581

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

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.licensingPolicyGui
d

Here are some:
Inventory Solution = CD39B720-F871-11D2-8643-00104B74A9DF
Inventory Pack for Servers = 6772A2A4-DD9D-4497-89CD-15FBF7DE3F7D
pcAnywhere Solution = C432B710-F971-11A2-8643-20105BF409AF
Monitor Pack for Servers = ADDA365D-971C-43EB-BD36-2EBDBA77A45A
Software Management Solution = AD3F5980-D9E9-11D3-A318-0008C7A09198