Software Updates - Compliance Report

[adurrant]

Hello,

I'm looking on how to create a custom report based on the default report of 'Compliance 1 - Overall Compliance' however I'm looking to just select the update group and then have predefined collections to report against, something like this: 

Collection	Compliance (%)	Not Compliant (%)	Compliance Unknown
4	69.23%
5	80.00%
6	95.00%
7	86.96%
8	95.00%
10	95.24%
11	91.30%
12	87.50%
13	82.61%
14	90.91%
15	81.25%
16	76.19%
17	70.00%
18	55.00%
19	77.78%
20	65.00%
21	76.19%
22	82.35%
23	87.50%
24	80.00%
25	85.71%
26	78.57%
27	86.69%
28	69.23%
29	72.73%
30	38.46%
31	30.77%

any ideas how I can achieve this? I'm not familiar with SQL reporting unfortunately.. :( 

[adurrant]

bump