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 to store predefined maintenance task results. 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.

Let’s SCCM how to find out the status of Predefined Maintenance Tasks. We often need to know the status of maintenance tasks running on SCCM primary servers as part of troubleshooting. Maintenance tasks are critical to maintaining a healthy SCCM environment. SCCM Maintenance Tasks results via PS or SQL.

Completion Status 0 means the task has finished successfully. There is a table called SQLTaskStatus which holds this data. We can also add a column to find the time a task took to run. The query for the same would be:

Patch My PC

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

Verify the Status of SCCM Predefined Maintenance Tasks

For more details, download the RDL/SCCM custom report for maintenance tasks from here.

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 the Last Start time, Last End time, the completion status of the maintenance task, etc… then the following SQL query will also help you.

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 (


1 thought on “Best way to Check Verify the Status of SCCM Predefined Maintenance Tasks ConfigMgr Configuration Manager”

Leave a Comment

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