Status of SCCM Predefined Maintenance Tasks

When troubleshooting SCCM maintenance tasks, it is important to verify that predefined maintenance tasks are running as per the schedule.
The below simple query will give us the Task name, Last start time, Last completion time and status of the completed task.
Run this query in SQL Management studio.

********************************************************************************
SELECT TaskName, LastStartTime, LastCompletionTime, CompletionStatus
FROM   SQLTaskStatus

********************************************************************************
More SCCM custom reports can be found here