SCCM Secondary Site Maintenance Tasks | List | ConfigMgr | SQL Query

0
SCCM Secondary Site Maintenance Tasks ConfigMgr

Well, SCCM secondary site maintenance tasks are not discussed much. I thought of covering a very high-level view of predefined maintenance tasks for a Configuration Manager secondary site server.

The predefined maintenance tasks are the clean-up tasks that help ConfigMgr DB to remove unwanted or obsolete data from the SQL Database. You have an option to configure or schedule the maintenance tasks based on your requirement.

Primary Server Maintenance Tasks

Let’s understand the Primary Server Maintenance Tasks. As you can see in the following screen capture, there are around 44 predefined maintenance tasks for SCCM primary site.

SCCM Secondary Site Maintenance Tasks - ConfigMgr
SCCM Secondary Site Maintenance Tasks – ConfigMgr

You can use the following SQL query from the SQL Management studio to get more details about the primary server maintenance tasks.

  select * from SQLTaskStatus
Primary Server Maintenance Tasks
Primary Server Maintenance Tasks
Primary site Maintenance Task NamesTask TypeLast Start TimeLast Completion TimeCompletion StatusRun Now
Backup SMS Site Server200:00.000:00.0NULL0
Check Application Title with Inventory Information120:10.020:30.000
Clear Undiscovered Clients100:00.000:00.0NULL0
Delete Aged Application Request Data115:10.015:20.000
Delete Aged Application Revisions105:11.005:12.000
Delete Aged Client Download History105:11.005:21.000
Delete Aged Client Operations110:17.010:22.000
Delete Aged Cloud Management Gateway Traffic Data140:10.040:16.000
Delete Aged CMPivot Results140:10.040:15.000
Delete Aged Collected Files100:09.000:14.000
Delete Aged Computer Association Data105:09.005:15.000
Delete Aged Console Connection Data120:17.020:22.000
Delete Aged Delete Detection Data115:17.015:17.000
Delete Aged Device Wipe Record115:10.015:15.000
Delete Aged Discovery Data100:09.000:14.000
Delete Aged Distribution Point Usage Stats115:17.015:22.000
Delete Aged Enrolled Devices100:00.000:00.0NULL0
Delete Aged EP Health Status History Data125:10.025:15.000
Delete Aged Exchange Partnership115:10.015:15.000
Delete Aged Inventory History100:08.000:29.000
Delete Aged Log Data105:11.005:16.000
Delete Aged Metering Data100:06.000:11.000
Delete Aged Metering Summary Data100:06.000:11.000
Delete Aged Notification Server History115:17.015:22.000
Delete Aged Notification Task History115:17.015:22.000
Delete Aged Passcode Records120:17.020:22.000
Delete Aged Replication Data110:16.010:22.000
Delete Aged Replication Summary Data110:16.010:22.000
Delete Aged Status Messages100:06.000:11.000
Delete Aged Threat Data120:10.020:15.000
Delete Aged Unknown Computers130:10.030:10.000
Delete Aged User Device Affinity Data125:10.025:15.000
Delete Expired MDM Bulk Enroll Package Records135:10.035:15.000
Delete Inactive Client Discovery Data100:00.000:00.0NULL0
Delete Obsolete Alerts105:11.005:21.000
Delete Obsolete Client Discovery Data100:00.000:00.0NULL0
Delete Obsolete Forest Discovery Sites And Subnets120:10.020:15.000
Delete Orphaned Client Deployment State Records135:10.035:15.000
Monitor Keys100:06.000:06.000
Rebuild Indexes100:00.000:00.0NULL0
Summarize File Usage Metering Data100:06.000:11.000
Summarize Installed Software Data110:17.010:22.000
Summarize Monthly Usage Metering Data100:06.000:11.000
Update Application Available Targeting120:17.020:22.000

SCCM Secondary Site Maintenance Tasks – ConfigMgr

SCCM Secondary Site Maintenance Tasks

Let’s check the details of SCCM Secondary Site Maintenance Tasks. The following are the predefined maintenance tasks available for the secondary site server.

As you can see in the below screen capture, there are only 4 predefined maintenance tasks available for the secondary site server.

SCCM Secondary Site Maintenance Tasks - ConfigMgr
SCCM Secondary Site Maintenance Tasks – ConfigMgr

You can use the following SQL query from the SQL Management studio to get more details about the primary server maintenance tasks.

SELECT * FROM SQLTASKSTATUS
Secondary site Maintenance Task NamesTask TypeLast Start TimeLast Completion TimeCompletion StatusRun Now
Delete Aged Log Data100:07.000:12.000
Delete Aged Replication Data100:07.000:12.000
Delete Aged Replication Summary Data100:07.000:12.000
Rebuild Indexes100:00.000:00.0NULL0
Secondary site Maintenance Task Names

ConfigMgr Secondary site Maintenance Task Names

ConfigMgr Secondary site Maintenance Task Names
ConfigMgr Secondary site Maintenance Task Names

Resources

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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