This is the RED Part:
This is the section that specifically reflects the query provided by cnorborg.
This query allows me to list all devices that are in violation of a specific policy rule, and then counts the number of times each of those devices violated the rule.
In our environment, a single device has the potential of 48 unique violations/occurrences of a single policy rule.
Re: Compliance Report, Summarize & Count Multiple Violations Per Device
