Display all Application Metering Policy details via SQL
Article ID: 172986
Updated On:
Products
Inventory Solution
Issue/Introduction
How can I see all the legacy Application Metering Policy details via SQL so I don't have to review each one manually?
Environment
ITMS 8.x
Resolution
The details for the Application Metering policies are kept in the State column of the resource's Item table record.
The following query will provide this data:
SELECT i.[Name], i.State FROM Item i
JOIN ItemClass ic ON ic.Guid = i.Guid
WHERE ic.ClassGuid = 'FB54A92B-B61A-463E-B721-A8402D5DF7F5'
Feedback
Yes
No
Powered by
