Let’s see SCCM Maintenance Tasks List Secondary and Primary Site Server. 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.
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 site Maintenance Task Names | Task Type | Last Start Time | Last Completion Time | Completion Status | Run Now |
|---|---|---|---|---|---|
| Backup SMS Site Server | 2 | 00:00.0 | 00:00.0 | NULL | 0 |
| Check Application Title with Inventory Information | 1 | 20:10.0 | 20:30.0 | 0 | 0 |
| Clear Undiscovered Clients | 1 | 00:00.0 | 00:00.0 | NULL | 0 |
| Delete Aged Application Request Data | 1 | 15:10.0 | 15:20.0 | 0 | 0 |
| Delete Aged Application Revisions | 1 | 05:11.0 | 05:12.0 | 0 | 0 |
| Delete Aged Client Download History | 1 | 05:11.0 | 05:21.0 | 0 | 0 |
| Delete Aged Client Operations | 1 | 10:17.0 | 10:22.0 | 0 | 0 |
| Delete Aged Cloud Management Gateway Traffic Data | 1 | 40:10.0 | 40:16.0 | 0 | 0 |
| Delete Aged CMPivot Results | 1 | 40:10.0 | 40:15.0 | 0 | 0 |
| Delete Aged Collected Files | 1 | 00:09.0 | 00:14.0 | 0 | 0 |
| Delete Aged Computer Association Data | 1 | 05:09.0 | 05:15.0 | 0 | 0 |
| Delete Aged Console Connection Data | 1 | 20:17.0 | 20:22.0 | 0 | 0 |
| Delete Aged Delete Detection Data | 1 | 15:17.0 | 15:17.0 | 0 | 0 |
| Delete Aged Device Wipe Record | 1 | 15:10.0 | 15:15.0 | 0 | 0 |
| Delete Aged Discovery Data | 1 | 00:09.0 | 00:14.0 | 0 | 0 |
| Delete Aged Distribution Point Usage Stats | 1 | 15:17.0 | 15:22.0 | 0 | 0 |
| Delete Aged Enrolled Devices | 1 | 00:00.0 | 00:00.0 | NULL | 0 |
| Delete Aged EP Health Status History Data | 1 | 25:10.0 | 25:15.0 | 0 | 0 |
| Delete Aged Exchange Partnership | 1 | 15:10.0 | 15:15.0 | 0 | 0 |
| Delete Aged Inventory History | 1 | 00:08.0 | 00:29.0 | 0 | 0 |
| Delete Aged Log Data | 1 | 05:11.0 | 05:16.0 | 0 | 0 |
| Delete Aged Metering Data | 1 | 00:06.0 | 00:11.0 | 0 | 0 |
| Delete Aged Metering Summary Data | 1 | 00:06.0 | 00:11.0 | 0 | 0 |
| Delete Aged Notification Server History | 1 | 15:17.0 | 15:22.0 | 0 | 0 |
| Delete Aged Notification Task History | 1 | 15:17.0 | 15:22.0 | 0 | 0 |
| Delete Aged Passcode Records | 1 | 20:17.0 | 20:22.0 | 0 | 0 |
| Delete Aged Replication Data | 1 | 10:16.0 | 10:22.0 | 0 | 0 |
| Delete Aged Replication Summary Data | 1 | 10:16.0 | 10:22.0 | 0 | 0 |
| Delete Aged Status Messages | 1 | 00:06.0 | 00:11.0 | 0 | 0 |
| Delete Aged Threat Data | 1 | 20:10.0 | 20:15.0 | 0 | 0 |
| Delete Aged Unknown Computers | 1 | 30:10.0 | 30:10.0 | 0 | 0 |
| Delete Aged User Device Affinity Data | 1 | 25:10.0 | 25:15.0 | 0 | 0 |
| Delete Expired MDM Bulk Enroll Package Records | 1 | 35:10.0 | 35:15.0 | 0 | 0 |
| Delete Inactive Client Discovery Data | 1 | 00:00.0 | 00:00.0 | NULL | 0 |
| Delete Obsolete Alerts | 1 | 05:11.0 | 05:21.0 | 0 | 0 |
| Delete Obsolete Client Discovery Data | 1 | 00:00.0 | 00:00.0 | NULL | 0 |
| Delete Obsolete Forest Discovery Sites And Subnets | 1 | 20:10.0 | 20:15.0 | 0 | 0 |
| Delete Orphaned Client Deployment State Records | 1 | 35:10.0 | 35:15.0 | 0 | 0 |
| Monitor Keys | 1 | 00:06.0 | 00:06.0 | 0 | 0 |
| Rebuild Indexes | 1 | 00:00.0 | 00:00.0 | NULL | 0 |
| Summarize File Usage Metering Data | 1 | 00:06.0 | 00:11.0 | 0 | 0 |
| Summarize Installed Software Data | 1 | 10:17.0 | 10:22.0 | 0 | 0 |
| Summarize Monthly Usage Metering Data | 1 | 00:06.0 | 00:11.0 | 0 | 0 |
| Update Application Available Targeting | 1 | 20:17.0 | 20:22.0 | 0 | 0 |
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.
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 Names | Task Type | Last Start Time | Last Completion Time | Completion Status | Run Now |
|---|---|---|---|---|---|
| Delete Aged Log Data | 1 | 00:07.0 | 00:12.0 | 0 | 0 |
| Delete Aged Replication Data | 1 | 00:07.0 | 00:12.0 | 0 | 0 |
| Delete Aged Replication Summary Data | 1 | 00:07.0 | 00:12.0 | 0 | 0 |
| Rebuild Indexes | 1 | 00:00.0 | 00:00.0 | NULL | 0 |
ConfigMgr Secondary site Maintenance Task Names
Resources
- Reference for maintenance tasks in Configuration Manager
- Maintenance tasks for Configuration Manager
Hello Annop,
Which log file to refer if any of the maintenance task was not run or failed? Please let me know
Can you check the site status mentioned here? https://www.anoopcnair.com/reset-sccm-cb-critical-site-status-summarizer-counter/