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'