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

7
Advertisement

In SCCM 2012, 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 troubleshoting.

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

Site Status 1

SCCM Server Data Table Details
No.IDNameSiteCodeServerRoleSQLInstanceSQLPortConfigMgrDatabaseSiteStatusRecoveryCount

Select * from Sites

Select-Sites-SCCM2012-SQL

SCCM Sites Table Details Part 1
No.SiteKey SiteCode SiteName ReportToSite Status DetailedStatus TimeStamp SomeId SiteType
SCCM Sites Table Details Part 2
No.BuildNumberVersion SiteServer InstallDir TimeZoneInfo Capabilities DefaultMP DefaultMPType
SCCM Sites Table Details Part 2
No.DefaultMPSslState DefaultMPCapabilities LocaleID ReplicatesReservedRanges Settings rowversion

Select * from ServerComponents

Select-Server Components-SCCM2012-SQL

 

SCCM 2012 Server Components
No.IDName
1130SMS_SITE_CONTROL_MANAGER
2131SMS_COLLECTION_EVALUATOR
3132SMS_DISCOVERY_DATA_MANAGER
4133SMS_DISTRIBUTION_MANAGER
5134SMS_MP_CONTROL_MANAGER
6135SMS_MP_DEVICE_MANAGER
7136SMS_MP_FILE_DISPATCH_MANAGER
8137SMS_COMPONENT_MONITOR
9138SMS_AMT_OPERATION_MANAGER
10139SMS_AMT_PROXY_COMPONENT
11140SMS_DELIVERY_SCOPE_EVALUATOR
12141SMS_STATE_MIGRATION_POINT
13142SMS_FALLBACK_STATUS_POINT
14143SMS_PXE_SERVICE_POINT
15144SMS_MULTICAST_SERVICE_POINT
16145AI_UPDATE_SERVICE_POINT
17146SMS_WSUS_CONFIGURATION_MANAGER
18147SMS_WSUS_CONTROL_MANAGER
19148SMS_SRS_REPORTING_POINT
20149SMS_AWEBSVC_CONTROL_MANAGER
21150SMS_PORTALWEB_CONTROL_MANAGER
22151SMS_ENROLL_SERVER
23152SMS_ENROLL_WEB
24153SMS_INBOX_MANAGER
25154SMS_INBOX_MONITOR
26155SMS_OUTBOX_MONITOR
27156SMS_INVENTORY_DATA_LOADER
28157SMS_INVENTORY_PROCESSOR
29158SMS_SOFTWARE_INVENTORY_PROCESSOR
30159SMS_LAN_SENDER
31160SMS_ASYNC_RAS_SENDER
32161SMS_ISDN_RAS_SENDER
33162SMS_X25_RAS_SENDER
34163SMS_SNA_RAS_SENDER
35164SMS_OFFER_MANAGER
36165SMS_OBJECT_REPLICATION_MANAGER
37166SMS_RULE_ENGINE
38167SMS_AI_KB_MANAGER
39168SMS_WSUS_SYNC_MANAGER
40169SMS_OFFLINE_SERVICING_MANAGER
41170SMS_POLICY_PROVIDER
42171SMS_PACKAGE_TRANSFER_MANAGER
43172SMS_SCHEDULER
44173SMS_EXCHANGE_CONNECTOR
45174SMS_COMPONENT_STATUS_SUMMARIZER
46175SMS_SITE_SYSTEM_STATUS_SUMMARIZER
47176SMS_OFFER_STATUS_SUMMARIZER
48177SMS_NETWORK_DISCOVERY
49178SMS_CLIENT_CONFIG_MANAGER
50179SMS_WINNT_SERVER_DISCOVERY_AGENT
51180SMS_AD_SYSTEM_DISCOVERY_AGENT
52181SMS_AD_USER_DISCOVERY_AGENT
53182SMS_AD_SECURITY_GROUP_DISCOVERY_AGENT
54183SMS_DATABASE_NOTIFICATION_MONITOR
55184SMS_CLIENT_CONFIG_MANAGER
56185SMS_PROVIDERS
57186SMS_SOFTWARE_METERING_PROCESSOR
58187SMS_STATE_SYSTEM
59188SMS_CLIENT_HEALTH
60189SMS_SYSTEM_HEALTH_VALIDATOR
61190SMS_WAKEONLAN_COMMUNICATION_MANAGER
62191SMS_CLIENT_CONFIG_MANAGER
63192SMS_WAKEONLAN_MANAGER
64193SMS_REPLICATION_MANAGER
65194SMS_CLOUD_SERVICES_MANAGER

7 COMMENTS

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

    • 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

  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

LEAVE A REPLY

Please enter your comment!
Please enter your name here