Count of items for each Security Clearance Level

Mike_Davis

Hello,

Would anyone know the SQL to write a LiveReport which shows the counts of items defined with various security clearance levels across the Enterprise;

something like;

 

Level	Name	No of Items
50	Protected	52
40	Restricted	245
10	Unclassified	2081

Thanks