How to Check Verify the Status of SCCM Predefined Maintenance Tasks


SCCM CB also uses the SQLTaskStatus table for storing the results of predefined maintenance tasks. Long back I created a 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 table. More details and download the RDL/SCCM custom report for maintenance task from here.

SCCM 2016 Maintanance Tasks

If  you want to more details about the status of SCCM vNext / SQL maintenance tasks like Last Start time, Last End time, completion status of the maintenance task etc… then 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 SCCM ConfigMgr vNext version ! When you run the following query from management studio, you will get the details of SCCM + SQL maintenance tasks.

select * from SQLTaskStatus 

[table class=”table table-bordered” ai=”1″ width=”600″ colwidth=”150|100″ colalign=”left”]
Maintenance Task Name

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 [/table]


Please enter your comment!
Please enter your name here

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