SCCM Configmgr SSRS Report Get list of missing updates for PC from specific Software update group

Few months ago,I posted blog on How to get list of missing/Required software updates for specific computer which helps to identify if a PC is 100% complaint or not for list of available patches(metadata) from SCCM,but that report gives you overall missing patches from SCCM DB irrespective of whether they are part of any software update groups or not.

Since the previous report do not have any limitation to apply on specific software update group,lot of guys commented on the blog post to have filter with software update group so that,they can apply the PC to specific software update group to know the compliance level.

This report is all about that ,to get the list of missing/Required software updates for particular PC from specific Software update group.

image

Report looks like this:

image

Download the RDL report from TechNet Gallery here, upload to your Configmgr SSRS Reports,change the data source and run it.

Note: I have tested this report both in Configmgr 2012 R2 SP1 and Configmgr V1511 ,it works fine.

3 Responses to "SCCM Configmgr SSRS Report Get list of missing updates for PC from specific Software update group"

  1. Hi Eswar,

    When you drill down to the last linked report, it´s no filtering for the SUG select before, it display all missing patches for the selected server. Did I missed something or it's the expected behaviour? I'm on SCCM 1706.

    Reply
    1. Hi Alex,
      I haven't looked the code in file but if you see this behavior happening for all the clients then i think you are right. The last report might be pulling the information about all info what is missing in the client irrespective of the software update group that you have filtered.

      Regards,
      Eswar

      Reply

Leave a Reply