I am responsible for multiple work centers for SCCM.  For part of my job I need to pull reports for patches that show who has and does not have specific patches or updates.  Currently I have to run the same report multiple times to gather the data. I know I could consolidate the collections but that would not allow me to show the work centers the problems I need them to fix for manual remediation.  I could really use some help with a custom report.

example layout

company(upper collection)

analytics (sub collection)

security (sub collection)

helpdesk (sub collection)

I need a report that will show me not only the standard installed /required data but also the subcollection that machine is in.

Can I run a report against the upper collection and either drill down into the sub collections or at least have it show the sub collection name so I can task out work needed?

machine name  analytics

what do you have so far?  you indicated you run the same report multiple times.  Can you post what that one is?  It might be (sort of) easy to modify to include details about specific collection memberships--but in order to do that we'll have to see what you have so far.