How to Find the Status of Predefined SCCM Maintenance Tasks

Today, I will explain How to Find the Status of Predefined SCCM Maintenance Tasks.

Let’s SCCM How to find out the status of Predefined Maintenance Tasks.

As part of troubleshooting, we often need to know the status of maintenance tasks running on SCCM primary servers.

Maintenance tasks are critical to maintaining a healthy SCCM environment. SCCM Maintenance Tasks results are available via PS or SQL.

Index
SCCM Maintenance Tasks SQL Query

SCCM Maintenance Tasks SQL Query

Completion Status 0 means the task has finished successfully. This data is stored in a table called SQLTaskStatus.

We can also add a column to find a task’s time to run. The query for the same would be:

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

Resource

How to Check Verify the Status of SCCM Predefined Maintenance Tasks – Check SCCM Predefined Maintenance Tasks Status (anoopcnair.com)

We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.

Author

Anoop C Nair is Microsoft MVP! He is a Device Management Admin with more than 20 years of experience (calculation done in 2021) in IT. He is a Blogger, Speaker, and Local User Group HTMD Community leader. His primary focus is Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.