Let’s see the SCCM Maintenance Tasks List for Secondary and Primary Site Server. SCCM secondary site maintenance tasks are not discussed much. I considered covering a high-level view of predefined maintenance tasks for a Configuration Manager secondary site server.
Regular maintenance and monitoring are necessary for Configuration Manager sites and hierarchies to provide services effectively and continuously. This maintenance ensures that the hardware, software, and Configuration Manager database continue to function correctly and efficiently, reducing the risk of failure.
Determining the status of maintenance tasks running on SCCM servers is often necessary as part of troubleshooting. Maintenance tasks are crucial for maintaining a healthy SCCM environment. The results of SCCM maintenance tasks can be obtained via PowerShell or SQL.
Configuration Manager comes with a set of pre-defined maintenance tasks designed to keep the Configuration Manager database healthy. These tasks may not all be available by default at every site, and while some are already enabled, others are not. You have the flexibility to set up schedules for all maintenance tasks.
- Best way to Check Verify the Status of SCCM Predefined Maintenance Tasks ConfigMgr Configuration Manager
- SCCM Console Beginners Guide | ConfigMgr
- How to Promote Pre-Production SCCM Client to Production
- What is Collection? How to Create SCCM Static Collections
| Index |
|---|
| SCCM Primary Server Maintenance Tasks |
| SCCM Primary Server Maintenance Tasks Names |
| SCCM Secondary Site Maintenance Tasks |
| SCCM Secondary Site Maintenance Tasks Names |
SCCM 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 the SCCM primary site.
The predefined maintenance tasks are clean-up tasks that help ConfigMgr DB remove unwanted or obsolete data from the SQL Database. You can configure or schedule the maintenance tasks based on your requirements.
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
SCCM Primary Server Maintenance Tasks Names
In the screenshot below, you can see the names of the primary maintenance tasks.
| 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 the 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 |
| Check the Application Title with Inventory Information | 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
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 screenshot below, the secondary site server has only 4 predefined maintenance tasks available.
Completion Status 0 indicates successful task completion. This information is stored in a table named SQLTaskStatus. Additionally, we can include a column to display the task execution time.
| 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 |
SCCM Secondary Site Maintenance Tasks Names
In the screenshot below, you can see the names of the secondary maintenance tasks.
Resources
- Reference for maintenance tasks in Configuration Manager
- Maintenance tasks for Configuration Manager
We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.
Author
Anoop C Nair is Microsoft MVP! He is a Device Management Admin with more than 20 years of experience (calculation done in 2021) in IT. He is a Blogger, Speaker, and Local User Group HTMD Community leader. His primary focus is Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.
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/