search cancel

How to see all Metering Policy details via SQL

book

Article ID: 172986

calendar_today

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?

Resolution

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'