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.
This would be useful at the time of SQL troubleshooting on SCCM 2012 replication issues.
select * from ServerData
Select * from Sites
Select * from ServerComponents