Probably already been asked but I cannot find this ...

During a patching weekend I would like to generate a report to show the compliance rate for;

(a) the overall weekend deployment

(b) the individual collections for that weekend

I was wondering if there was a way to trigger the out of the box reports, passing in the required 'Update group' and 'Collection' parms.  The main report would be the 'Software Updates - A Compliance \ Compliance 1 - overall compliance'

Yes, I could schedule these - however - the collection name will change from month to month.  So I would rather be able to trigger these to run from outwith SCCM with the parms being dynamically altered.

Finally, I would like to collate all the weekends collection report into one key compliance report for the weekend. Can the 'Software Updates - A Compliance \ Complaince 1 - overall compliance' accept multiple collection parms?

Thanks, Thomas

Why does the collection name change?

Sure, report scheduling is built into SSRS and ConfigMgr will even set this up for you. All you have to do is right-click on any report and click Create Subscription. You'll need to go into the Reporting Service Configuration tool to set up a few basic things about e-mail to be able to create report subscriptions that are e-mailed.

I think you cant get that report with multiple collection, as that will be scheduled, 

You're right sorry, missed that part. But then I second John's question, why would the collection name change?

Jason, Sharad and John - thanks for the quick responses.

Had already looked at the scheduling option and thats what raised the question

Collection name - this changes from month to month...as this is how it was designed - not saying this is correct - its just the way it currently is.  I will be having a discussion about this with the team to see if I can influence how we can amend this going forward.

As I cannot address the naming convention (just now) - do I have an option for running the report via SQL and passing in the parm that way?

Thanks.

I personally do not know any way you can automate this if the collection name changes.

I have one idea that "may" work... If the collection name stays similar you may possibly be able to edit the report, save it as a custom report, remove the prompt and hard code where collection name like '%blah bah%'

But the real solution is to not change the collection. Collections are almost always reused from month to month to make things easier and avoid mistakes.

If the Collection ID does not change, you can change the Label from Collection Name to Collection ID like the picture shows.