Close Menu
    Facebook X (Twitter) Instagram
    Tuesday, May 20
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM Reports»SCCM report for Site System status and Hierarchy Design

    SCCM report for Site System status and Hierarchy Design

    Eswar KonetiBy Eswar KonetiJuly 10, 12:40 pm1 Min Read SCCM Reports 206 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Did you ever find difficulty in identifying the site system information when you have multi-tier hierarchy like  central,multiple primary sites and
    each primary has primary and secondary sites.

    It is difficult to identify and check for site settings (like discovery,Site maintenance Tasks etc.) OR Site Component Information until you know all site verywell .

    To make it little easy,I have created a report that gives you hierarchy design information along with site system status.

    Select
    C.servername,b.SiteCode,C.SiteName,C.ReportingSiteCode, b.Updated 'Time Stamp',C.InstallDir,

    Case b.Status
    When 0 Then 'OK'
    When 1 Then 'Warning'
    When 2 Then 'Critical'
    Else ' '
    End AS 'Site Status',
    Case C.Status
    When 1 Then 'Active'
    When 2 Then 'Pending'
    When 3 Then 'Failed'
    When 4 Then 'Deleted'
    When 5 Then 'Upgrade'
    Else ' '
    END AS 'Site State'
    From V_SummarizerSiteStatus B
    Join v_Site C on B.SiteCode = C.SiteCode

    Order By C.Servername

    Should be of helpful !

    CM07 Hierarchy Design report sccm report sccm report for site system status SQL code
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Monitoring Endpoint Security Applications with SCCM ConfigMgr SQL

    October 11, 8:48 pm

    SCCM report list collections with no deployments

    December 05, 12:04 pm

    How to migrate standalone MBAM to SCCM for bitlocker

    November 10, 2:32 pm

    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.