How to Check and Verify the Status of SCCM ConfigMgr vNext Predefined Maintenance Tasks

SCCM ConfigMgr vNext (2016?) 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/ConfigMgr predefined maintenance tasks. I know, it’s not a good 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 

No.Maintenance Task Name

Backup SMS Site Server

2Check Application Title with Inventory Information
3Clear Undiscovered Clients
4Delete Aged Application Request Data
5Delete Aged Application Revisions
6Delete Aged Client Operations
7Delete Aged Collected Files
8Delete Aged Computer Association Data
9Delete Aged Delete Detection Data
10Delete Aged Device Wipe Record
11Delete Aged Discovery Data
12Delete Aged Distribution Point Usage Stats
13Delete Aged Enrolled Devices
14Delete Aged EP Health Status History Data
15Delete Aged Exchange Partnership
16Delete Aged Inventory History
17Delete Aged Log Data
18Delete Aged Metering Data
19Delete Aged Metering Summary Data
20Delete Aged Notification Server History
21Delete Aged Notification Task History
22Delete Aged Passcode Records
23Delete Aged Replication Data
24Delete Aged Replication Summary Data
25Delete Aged Status Messages
26Delete Aged Threat Data
27Delete Aged Unknown Computers
28Delete Aged User Device Affinity Data
29Delete Expired MDM Bulk Enroll Package Records
30Delete Inactive Client Discovery Data
31Delete Obsolete Alerts
32Delete Obsolete Client Discovery Data
33Delete Obsolete Forest Discovery Sites And Subnets
34Evaluate Provisioned AMT Computer Certificates
35Monitor Keys
36Rebuild Indexes
37Summarize File Usage Metering Data
38Summarize Installed Software Data
39Summarize Monthly Usage Metering Data
40Update Application Available Targeting 

About Author 

Anoop is Microsoft MVP and Veeam Vanguard ! He is a Solution Architect on enterprise client management with more than 13 years of experience (calculation done on the year 2014) in IT. He is Blogger, Speaker and Local User Group Community leader. His main focus is on Device Management technologies like SCCM 2012,Current Branch, Intune. He writes about the technologies like SCCM, SCOM, Windows 10, Azure AD, Microsoft Intune, RMS, Hyper-V etc...

    Find more about me on:
  • googleplus
  • twitter
  • facebook
  • linkedin
  • youtube
Posted in: ConfigMgr (SCCM), SCCM 2016

Leave a Comment and Contact Anoop