ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to see all Metering Policy details via SQL


Article ID: 172986


Updated On:


Inventory Solution


How can I see all the legacy Application Metering Policy details via SQL so I don't have to review each one manually?


The details for the 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'