Let’s learn more about the ConfigMgr Delete Aged Cloud Management Gateway Traffic Data maintenance task. This task is enabled by default on all site servers except the secondary server. This task is not available for secondary servers.
SCCM CB also uses the SQLTaskStatus table for storing the results of predefined maintenance tasks. Don’t use tables to create custom reports. Instead, use the SQL views to create custom reports. More details here.
If you want to more details about the status of SCCM / SQL maintenance tasks like
- Last Start time
- Last End time
- Completion status
You don’t need to create a custom report instead you can view the status from the Maintenance Tasks tab in the site system server window in the console.
Reports Download the RDL file for the SSRS report from https://github.com/AnoopCNair/SCCM-Maintenance-Task-Download-RDL-file-for-SSRS-report.
Use this task to delete all aged data about the traffic that passes through the ConfigMgr cloud management gateway from the site database. You can confirm whether this maintenance task is enabled or not by going through the following steps:
- Navigate to \Administration\Overview\Site Configuration\Sites
- Select the Primary server or CAS site server
- Click on the maintenance tasks from the bottom side of the console
- Double click on the Delete Aged Cloud Management Gateway Traffic Data task to configure or change the settings
By default, this maintenance task is enabled and this is the best practice as per Microsoft. If you want to disable this deletion task, you can uncheck the option from “Enable this task” in the above screenshot.
You can also change or Delete data that has been inactive for Days. The default number of days is set as 90 days by default. You can also schedule the days on which this deletion/cleanup task should run against the ConfigMgr DB.
- Minimum inactive days that you can configure – 1
- Maximum inactive days that you can configure – 365
SQL Task Status
Quickly check the status of the SCCM maintenance tasks using the SQL query below:
select * from SQLTaskStatus
Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is a logger, Speaker, and Local User Group HTMD Community leader. His main focus is on 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…