Best way to Check Verify the Status of SCCM Predefined Maintenance Tasks ConfigMgr Configuration Manager

How to Check Verify the Status of SCCM Predefined Maintenance Tasks ConfigMgr Configuration Manager? SCCM CB also uses the SQLTaskStatus table for storing the results of predefined maintenance tasks. I created an RDL file custom report to check the status of SCCM predefined maintenance tasks.

I know it’s not a best practice to use SQL tables in the reports; rather, we should use views. However, this custom report or RDL file is based on the table.

Latest Posts – SCCM Secondary Site Maintenance Tasks | List | ConfigMgr | SQL Query HTMD Blog (

Verify the Status of SCCM Predefined Maintenance Tasks

More details and download the RDL/SCCM custom report for maintenance tasks from here.

Patch My PC
SCCM 2016 Maintenance Tasks - SCCM Predefined Maintenance Tasks
SCCM Predefined Maintenance Tasks Verify the Status of SCCM Predefined Maintenance Tasks

If you want more details about the status of SCCM vNext / SQL maintenance tasks like Last Start time, Last End time, the completion status of the maintenance task, etc… then the following SQL query also will help you. This query is also discussed in the previous post here.

select *,
 floor(DATEDIFF(ss,laststarttime,lastcompletiontime)/3600) as Hours,
 floor(DATEDIFF(ss,laststarttime,lastcompletiontime)/60)- floor(DATEDIFF(ss,laststarttime,lastcompletiontime)/3600)*60 as Minutes,
 floor(DATEDIFF(ss,laststarttime,lastcompletiontime))- floor(DATEDIFF(ss,laststarttime,lastcompletiontime)/60)*60 as TotalSeconds
 from SQLTaskStatus

The list of predefined SQL maintenance tasks in the SCCM ConfigMgr vNext version! When you run the following query from the management studio, you will get the details of SCCM + SQL maintenance tasks. Verify the Status of SCCM Predefined Maintenance Tasks?

select * from SQLTaskStatus 
  • Backup SMS Site Server
  • Check Application Title with Inventory Information
  • Clear Undiscovered Clients
  • Delete Aged Application Request Data
  • Delete Aged Application Revisions
  • Delete Aged Client Operations
  • Delete Aged Collected Files
  • Delete Aged Computer Association Data
  • Delete Aged Delete Detection Data
  • Delete Aged Device Wipe Record
  • Delete Aged Discovery Data
  • Delete Aged Distribution Point Usage Stats
  • Delete Aged Enrolled Devices
  • Delete Aged EP Health Status History Data
  • Delete Aged Exchange Partnership
  • Delete Aged Inventory History
  • Delete Aged Log Data
  • Delete Aged Metering Data
  • Delete Aged Metering Summary Data
  • Delete Aged Notification Server History
  • Delete Aged Notification Task History
  • Delete Aged Passcode Records
  • Delete Aged Replication Data
  • Delete Aged Replication Summary Data
  • Delete Aged Status Messages
  • Delete Aged Threat Data
  • Delete Aged Unknown Computers
  • Delete Aged User Device Affinity Data
  • Delete Expired MDM Bulk Enroll Package Records
  • Delete Inactive Client Discovery Data
  • Delete Obsolete Alerts
  • Delete Obsolete Client Discovery Data
  • Delete Obsolete Forest Discovery Sites And Subnets
  • Evaluate Provisioned AMT Computer Certificates
  • Monitor Keys
  • Rebuild Indexes
  • Summarize File Usage Metering Data
  • Summarize Installed Software Data
  • Summarize Monthly Usage Metering Data
  • Update Application Available Targeting


SCCM Related Posts Real World Experiences Of SCCM Admins (

SCCM Video Tutorials For IT Pros – HTMD Blog #2 (



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 blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. E writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc…

Leave a Comment

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