Close Menu
    Facebook X (Twitter) Instagram
    Sunday, July 20
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»CM2012»SCCM Configmgr SSRS Report Get list of missing updates for client from specific Software update group

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

    Eswar KonetiBy Eswar KonetiDecember 20, 12:59 am2 Mins Read CM2012 11,607 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Few months ago,I posted a blog on How to get list of missing/Required software updates for specific computer .This report basically helps to identify if the PC missing any patches to confirm the device is fully compliant or not. But this report is based on all the software updates available in the SCCM and whether they are part of any software update group or not.

    Since the report is pulling the data from all the updates in SCCM, there is huge demand from my blog readers to help getting similar report but limit the report to specific software update group. So that, it will be easier to identify the list of missing patches for specific client from specific software update group.

    This is a valid question and not every organisation deploy all the patches that are available in SCCM. As per organisation security standards, you can decide to deploy only security and critical updates hence you create a SUG group only for this.

    I have made some changes to the previous report and added some filters to select the software update group.

    A report RDL file is uploaded to Technet Gallery here, upload the report to your Configmgr SSRS Reports,change the data source and run it.

    image

    Report looks like this:

    image

    Hope you find this report useful.

    Collection Compliance configmgr patch compliance report Patch Report Reports SCCM Software update compliance Software update group SQL SSRS SUP report Update report
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    Optimize Your Intune Workflow with a Powerful Browser Extension

    March 22, 10:39 am

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 pm

    5 Comments

    1. Ricky Kollberg on September 3, 2018 7:09 PM

      Hi Eswar
      I have used this report and a like it wery much 🙂
      But now a have discovered that the dedaline is not correct or displayed from another deployment
      For example KB4132216 are in 4 different deployment whit different dedlines.
      So if a run the report "List Missing patches for Specific client for specific UG" and choose UG
      "All OS Critical and Security Manual Deployments 2018-08-14 22:45:09" and a collection whit manual handeled servers
      "SUM SRV - Windows Security & Critical Updates Manual Deployment"
      and a choos a server Software Updates Missing on xxxxserver.
      KB4134416 will display Aug14 10:32 as deadline but the deadline for the KB4132216 in SUG is 2018-09-22
      Deadline is wery important for us, I want to be abel to send this report to different stakehoders that have servers
      in manuall mode patching and warn them that patching is going to happen at this deadline.
      Is this some thing you can correct in this report?

      Reply
      • Eswar Koneti on October 6, 2018 11:52 PM

        Hi,
        Thanks for your feedback. Deadline is something that is not very accurate i believe ,i need to look at it further more or delete the deadline for now . Because if the update is part of SU group and is deployed multiple times to a collection then it wont show correct details. For now ,please ignore the deadline .I am running short of time due to office 365 project timelines ,may take time to look at it and update the reports.

        Thanks,
        Eswar

        Reply
    2. Alexandre Ramos on October 26, 2017 2:50 AM

      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
      • Eswar Koneti on November 9, 2017 9:46 AM

        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
    3. Madhu R on August 10, 2017 4:31 PM

      your the master in SCCM hatts off to you sir

      Reply

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2024 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.