Close Menu
    Facebook X (Twitter) Instagram
    Tuesday, May 20
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»CM2012»SCCM Configmgr SQL Query to check software update is superseded by what software updates

    SCCM Configmgr SQL Query to check software update is superseded by what software updates

    Eswar KonetiBy Eswar KonetiFebruary 21, 4:42 pm2 Mins Read CM2012 8,789 Views
    Share
    Facebook Twitter LinkedIn Reddit

     

    There was a question raised by someone on MyItform list ,asking for ‘is there a way to get superseded patch list’ for all windows 7”. when I read the question ,I was thinking ,we can get this using the default reports but when I check the default reports,there is no such report that match this requirement  .

    So ,I sat for sometime in the lab ,started writing the SQL Query ,found something . So thought of writing this blog post that helps others who are in similar needs.

    If you want to know particular patch (ex:Cumulative Update for Windows 10 Version 1511 (KB3124200)) superseded by what software updates in SCCM/Configmgr ,you can simply browse Software Library /Software updates nodes,search with this title ,right click on the Software Update Properties ,Go to Supersedence Information ,You can see, this software update is superseded by (To replace ) also ,if this software update supersedes by any other update .

    image

    This method is easy if you want to check for specific software update but,what if you want to have a list of software updates that are superseded by what software updates ? 

    In Configmgr ,Software update information is scattered across multiple tables/views and depends on your requirement ,you must choose right table to query the information.

    For Writing the SQL Queries /SSRS Reports,always have these 2 as reference 1)Configmgr SQL views and 2)SSRS expressions

    For our requirement, we will be retrieving the software update information from V_updateinfo and superseded information from v_CIRelation_all.

    Based on the above 2 SQL views, I will be retrieving the Software updates that are superseded by what updates.

    SQL Code:

    select UI1.Title,UI1.IsSuperseded,ui1.BulletinID,UI1.InfoURL,
    UI2.Title [S Title],ui2.IsSuperseded,UI2.BulletinID [S BulletinID],UI2.InfoURL [S InfoURL]
    from v_CIRelation_all CA
    left join v_UpdateInfo UI1 on CA.ReferencedCI_ID=UI1.CI_ID
    left join v_UpdateInfo UI2 on ca.CI_ID=ui2.CI_ID
    where RelationType=6
    and UI1.title like '%Windows 10%'

    If you want to list only windows 7 updates ,replace 10 with 7 .if you want to list all Software updates irrespective of OS ,then simply comment the last line using --

    you can use this SQL Code to put in SSRS Reports with your customizations.

    CM12 configmgr SCCM Software update report SQL SSRS superseded info superseded patch list superseded updates supersedes by
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    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

    Identifying devices managed by Intune but not reporting to WUfB using KQL

    November 09, 10:28 am

    4 Comments

    1. John Provencher on March 1, 2025 2:39 AM

      This is old and I don't know that you'll see this, but how would I go about listing the Software Update Group for the superseded patch?

      Reply
      • Eswar Koneti on March 30, 2025 11:22 AM

        Hi,
        can you post the results of what is not working for you?

        Thanks,
        Eswar

        Reply
    2. Mohan on March 14, 2018 6:00 PM

      Is there any way to pull the report for particular month

      Reply
      • Eswar Koneti on March 15, 2018 8:30 PM

        you can use month ,date ,year that is available in v_updateinfo SQL view.

        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.