Skip to content
SCCM Secondary Site Maintenance Tasks List Primary Site Server

SCCM Secondary Site Maintenance Tasks List Primary Site Server

Written By Anoop C Nair
Last Updated June 29, 2024
Posted In SCCM
SHARE

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.

Patch My PC
Index
SCCM Primary Server Maintenance Tasks
SCCM Primary Server Maintenance Tasks Names
SCCM Secondary Site Maintenance Tasks
SCCM Secondary Site Maintenance Tasks Names
SCCM Secondary Site Maintenance Tasks List Primary Site Server -Table 1

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.

SCCM Secondary Site Maintenance Tasks List Primary Site Server - Fig.1
SCCM Secondary Site Maintenance Tasks List Primary Site Server – Fig.1

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.

SCCM Secondary Site Maintenance Tasks List Primary Site Server - Fig.2
SCCM Secondary Site Maintenance Tasks List Primary Site Server – Fig.2
Primary site Maintenance Task NamesTask TypeLast Start TimeLast Completion TimeCompletion StatusRun Now
Backup SMS Site Server200:00.000:00.0NULL0
Check the 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
Check the Application Title with Inventory Information120: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 List Primary Site Server -Table 2

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.

SCCM Secondary Site Maintenance Tasks List Primary Site Server - Fig.3
SCCM Secondary Site Maintenance Tasks List Primary Site Server – Fig.3

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 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
SCCM Secondary Site Maintenance Tasks List Primary Site Server -Table 3

SCCM Secondary Site Maintenance Tasks Names

In the screenshot below, you can see the names of the secondary maintenance tasks.

SCCM Secondary Site Maintenance Tasks List Primary Site Server - Fig.4
SCCM Secondary Site Maintenance Tasks List Primary Site Server – Fig.4

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.

Written by

Anoop C Nair is Workplace Technology solution architect with 25+ years of experience in global enterprise organizations such as JP Morgan, Capgemini, etc. Microsoft Certified Trainer. Microsoft MVP from 2015 onwards for consecutive 11+ years! He also conducts Intune and modern workplace tech training for enterprise organizations. He is Blogger, Speaker, and Founder of HTMD Community and HTMD Conference. His main focus is on Device Management technologies like Intune, Windows, Cloud PC. He writes about technologies like Intune, SCCM, Windows, Cloud PC, Windows, Entra, Microsoft Security.

Discussion · 2 comments

  1. Hello Annop,
    Which log file to refer if any of the maintenance task was not run or failed? Please let me know

Join the discussion

Your email address will not be published. Required fields are marked *

Related guides

Intune

Windows 11 KB5101650 KB5099414 July 2026 Patch and 3 Zero Day Vulnerabilities and 570 Flaws

Key Takeaways Windows 11 KB5101650 KB5099414 July 2026 Patch and 3 Zero Day Vulnerabilities and 570 Flaws! In the July 2026 Patch, Microsoft introduced new features designed to improve the overall Windows experience. The update adds enhancements to Windows Update for more flexible update management and introduces Point-in-Time Restore, providing an additional recovery option for […]

AC Anoop C Nair 9 min read
Intune

2026 June KB5094126 KB5093998 Windows 11 Patch | 3 Zero Day Vulnerabilities and 200 Flaws

Key Takeaways 2026 June KB5094126 KB5093998 Windows 11 Patch | 3 Zero Day Vulnerabilities and 200 Flaws! The June 2026 Windows 11 Patch Tuesday update brings several improvements to File Explorer. It adds support for additional archive formats, including UU, CPIO, XAR, and NuGet Packages (NUPKG). The update also preserves View and Sort preferences in […]

AC Anoop C Nair 10 min read
Intune

2026 May KB5089549 KB5087420 Windows 11 Patch | 0 Zero Day Vulnerabilities and 120 Flaws

Key Takeaways The Windows 11 May 2026 Patch KB5089549 KB5087420 Update brings important security fixes, performance improvements, and reliability enhancements across the operating system. The update introduces new features such as Xbox Mode for gaming, File Explorer improvements, enhanced input and sharing experiences, better taskbar and Windows Hello reliability, and additional enterprise management capabilities for […]

AC Anoop C Nair 8 min read
SCCM

ConfigMgr 2603 Introduces New Early Update Enrollment Process

Key Takeaways In this post we are discussing the ConfigMgr 2603 Introduces New Early Update Enrollment Process. Microsoft has officially released Configuration Manager version 2603 to the Early Update Ring, giving organizations an opportunity to test upcoming improvements before the global production rollout. The release is targeted at enterprises running ConfigMgr version 2409 or later […]

AC Anoop C Nair 3 min read