How to Find SCCM Server Components Data Site Status Details from SQL DB Configuration Manager

How to Find SCCM Server Components Data Site Status Details from SQL DB Configuration Manager. In SCCM, ServerComponents, ServerData, and SiteStatus tables are very important. We can get loads of information from these 3 tables.

I was troubleshooting on SCCM 2012 SQL based (not SQL replication) replication (thanks to Umair Khan for more details on this) related issues and found that these tables would be really useful to understand the status of the replication and other SCCM related troubleshooting.

How to Find SCCM Server Components Data Site Status Details from SQL DB?

I’m not going to explain SQL troubleshooting part in this post. Most of the information are available in Umair’s posts as mentioned above. In this post, I just wanted to share the details of┬áServerData and SiteStatus.

Patch My PC

This would be useful at the time of SQL troubleshooting on SCCM 2012 replication issues.

select * from ServerData

How to Find SCCM Server Components Data Site Status Details from SQL DB Configuration Manager
How to Find SCCM Server Components Data Site Status Details from SQL DB Configuration Manager

Select * from Sites

How to Find SCCM Server Components Data Site Status Details from SQL DB Configuration Manager
How to Find SCCM Server Components Data Site Status Details from SQL DB Configuration Manager

Select * from ServerComponents

How to Find SCCM Server Components Data Site Status Details from SQL DB Configuration Manager
How to Find SCCM Server Components Data Site Status Details from SQL DB Configuration Manager

Resources

Windows 10 Latest Version Of Client Operating System From Microsoft (anoopcnair.com)

6 thoughts on “How to Find SCCM Server Components Data Site Status Details from SQL DB Configuration Manager”

  1. Kool ! Nice one.. ­čÖé But fetching out desire data from all these tables using SQL Query is something really annoying :S

    Reply
    • I know, Unfortunately, if you’ve hierarchy in SCCM 2012 with SCCM CAS and Primary then we need to deal with it. It’s very new for SCCM admins. My heading spinning now because of some SQL based replication issues.
      Regards
      Anoop

      Reply
  2. Hi sir,
    my environment has SCCM 2012 R2… with 1 CAS, 4 primary, and 32 secondary….

    i am handling a secondary site related to first primary site…

    now the task is I have to reinstall (refresh) the windows 7 profession version OS in my secondary site, already we have windows 7 professional version but with 3 drives in it, so now i have to push OS with partisioning only one drive and push OS into all systems and no data should be lost,…

    please specify me what are the requirements and steps involved in it

    Regards
    Kapil

    Reply

Leave a Comment

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