Close Menu
    Facebook X (Twitter) Instagram
    Tuesday, May 20
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»Patch Reports»SCCM Report Sites with WSUS Sync status

    SCCM Report Sites with WSUS Sync status

    Eswar KonetiBy Eswar KonetiNovember 20, 7:51 am1 Min Read Patch Reports 2,310 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Having multiple sites and checking the status of WSUS synchronization on all servers tedious job and child sites must sync with its parent sites to ensure right compliance levels from clients.

    This report will give you the status of WSUS server with Right content version.

    When SCCM sync with Microsoft Updates,Content version will get increment to +1 and it passes this information to its child sites to sync with right version.

     

    SELECT 
        US.SiteCode, S.ServerName, S.SiteName, US.ContentVersion, US.SyncTime
    FROM
        update_syncstatus US, v_Site S 
        where US.SiteCode=S.SiteCode and US.contentversion <@Version
    ORDER BY
        SyncTime

     

    Prompt for @Version :

    SELECT      distinct ContentVersion from
        update_syncstatus

    configmgr report sccm report Sites wit WSUS Sync status sites with their last wsus sync report SQL WSUS Sync report for all sites in hirarchy WSUS syncronisation wsyncmgr.log
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Monitoring Endpoint Security Applications with SCCM ConfigMgr SQL

    October 11, 8:48 pm

    Disable windows updates (wufb) on selected devices using Intune

    July 07, 11:04 pm

    Efficiently Identify Co-Managed Devices: Techniques and Tools

    January 17, 8:37 pm

    4 Comments

    1. Praveen on January 6, 2017 7:06 PM

      Hi Eswar, Since being an newbie could you please explain how do i create a prompt value (or) specifically how can i fetch version details through query itself without giving an prompt?

      Reply
      • Eswar Koneti on January 12, 2017 6:05 PM

        Hi Praveen,
        I do not have any blog post on 'how to create prompt value in SSRS' but if you have any variables used in the SQL report, prompts will be automatically created in tools that you use like BIDS,report builders etc and all you need is to go properties of the prompt and choose what is needed.
        You can refer these post https://technet.microsoft.com/en-us/library/aa337432(v=sql.105).aspx and https://technet.microsoft.com/en-us/library/aa337401(v=sql.105).aspx

        Regards,
        Eswar

        Reply
    2. srini on October 25, 2013 11:08 PM

      created Report but it is prompting for Version.. what exactly we need to provide input??

      Reply
      • Eswar Koneti on October 29, 2013 7:40 PM

        didnt the blog says to create prompt value ? like this for @Version:

        SELECT distinct ContentVersion from
        update_syncstatus

        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.