Version 2

    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