How to Check Verify the Status of SCCM Predefined Maintenance Tasks

0

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 Maintenance Tasks - SCCM Predefined Maintenance Tasks
SCCM Predefined Maintenance Tasks

If you want to 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 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 the management studio, you will get the details of SCCM + SQL 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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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