Subscribe to report

[gooooba]

Hi,

great work, but I have a question.
How do I subscribe to sub reports of main report "Software Updates Compliance - Overview" for example...
This is great report for overview but in the end I need e-mail more detail than general overview once per month for security operations center SOC.

Example: In the main report I can select yelow bar to show only computers with latest CU missing as that is the main thing that SOC is interested about. The question is how to subscribe to "sub" report with only computers missing latest CU.

thank you

[jonasatgit]

Hi @gooooba nor sure if you found the answer yet, but here it is.
Use the report "Software Updates Compliance - Overview compliance list" and subscribe to that one. That report is used to show the list when you click on any yellow bar.

[gooooba]

Thank you. Any Idea how would we add absolute number of computers on overview charts besides percentage.

For example 'computers in percent'('absolute number of computers')

[gooooba]

I managed to work something out. Under series label data I put this for last rollup:

for compliant:
=Sum(IIf(Fields!LastRollupStatus.Value = 3, 1, 0)) &
" systems (" &
FormatPercent(
Sum(IIf(Fields!LastRollupStatus.Value = 3, 1, 0))
/ Count(Fields!LastRollupStatus.Value), 2
) & ")"

for non compliant:
=Sum(IIf(Fields!LastRollupStatus.Value <> 3, 1, 0)) &
" systems (" &
FormatPercent(
Sum(IIf(Fields!LastRollupStatus.Value <> 3, 1, 0))
/ Count(Fields!LastRollupStatus.Value), 2
) & ")"

then something similar for all other data./reports..

it looks something like this now:

[jonasatgit]

Hi @gooooba , that looks really nice. Cool idea. If I find some time I will add that to the solution if that's okay.

[gooooba]

Sure would be great if you add it. One other thing I noticed, is Systems with install error system number is different overview report than if you open the subreport 'Software Updates Compliance - Errorlist' with report type 'update install errors'. can't seem to find why...maybe you can check if/when you got time.

maybe it is just my data label expression that is wrong...

=Sum(IIf(Fields!UpdatesApprovedMissingAndError.Value = 0, 1, 0)) &
" systems (" &
FormatPercent(
Sum(IIf(Fields!UpdatesApprovedMissingAndError.Value = 0, 1, 0))
/ Sum(Fields!Counter.Value), 2
) & ")"

=Sum(IIf(Fields!UpdatesApprovedMissingAndError.Value > 0, 1, 0)) &
" systems (" &
FormatPercent(
Sum(IIf(Fields!UpdatesApprovedMissingAndError.Value > 0, 1, 0))
/ Sum(Fields!Counter.Value), 2
) & ")"

[jonasatgit]

Hi @gooooba I created a new version containing your suggestion. I think I also might have fixed the last error you described.
Please download the version from here: https://github.com/jonasatgit/updatereporting/tree/dev2 (Dev2 Branch) and let me know what you think. You can install the new version next to the old one, when using a different folder in Report Server.

[jonasatgit]

I just released a new version with the fix.