SCCM Custom Report to check the Status of Predefined Site Maintenance Tasks. This is a long pending post. I’ve created a custom report to get the status of the SCCM 2007, ConfigMgr 2012, and CB predefined maintenance tasks. I’ve uploaded the RDL file to GitHub imported it to your SSRS.
Download the RDL file from GitHub. Run the report and be aware of the status of your maintenance tasks on SCCM 2012 and 2007 site servers (on a weekly or daily basis).
Latest Post – Check SCCM Predefined Maintenance Tasks Status (anoopcnair.com) & SCCM Secondary Site Maintenance Tasks | List | ConfigMgr | SQL Query HTMD Blog (anoopcnair.com)
SCCM Custom Report to check the Status of Predefined Site Maintenance Tasks?
Completion Status ZERO (0) means the task finished successfully. There is a table called SQLTaskStatus, which holds this data. We can also add a column to find the time a task took to run.
Checking the status of maintenance tasks is always important and should be part of Weekly health checks. This post is a continuation of my old post on how to find out the status of Predefined Maintenance Tasks.
I couldn’t find the view related to the SQLTaskStatus table, so I’ve created the custom report with the above-mentioned table rather than view.
Two potential issues:-
1. Go to the Manage option of the report (from the SSRS web report). Click on Manage –> Data Sources –> Click on A Shared Data Source and browse to connect to /ConfigMgr_SiteCode/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602} and APPLY. Run the report. It should work.
2. Another problem could be with permission. Probably, you don’t have access to tables. Can you try running the following query from SQL management studio?
select * from SQLTaskStatus
Author
Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management 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 main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. E writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc…
I tried to import this rdl file in to our SSRS but getting below error:
“The report definition is not valid. Details: The report definition has an invalid target namespace ‘http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition’ which cannot be upgraded. (rsInvalidReportDefinition) Get Online Help”
Oops that’s is strange. I’ll check again 🙁
I’m getting the following error:
The SELECT permission was denied on the object ‘SQLTaskStatus’, database ‘CM_DI1’, schema ‘dbo’.
—————————-
Query execution failed for dataset ‘DataSet1’. (rsErrorExecutingCommand)
—————————-
An error has occurred during report processing. (rsProcessingAborted)
One problem could be :-
Go to Manage option of the report. Click on Manage –> Data Sources –> Click on A Shared Data Source and browse to connect to /ConfigMgr_SiteCode/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602} and APPLY. Run the report. It may work.
Another problem could be with permission. Probably, you don’t have access on tables. Can you try running the following query from SQL management studio.
select * from SQLTaskStatus
After uploading the report the first thing I did was configure that data source, so i’m guessing its a permission issue too. Our DBA locks us down pretty good 😉 Bummer. Looks like you built a handy report. Thanks for sharing.
All the best to you. As I know how it would be (dealing with SQL team) 🙂
Hey Anoop, great report! Are we supposed to be able to see the status of ‘all’ site maintenance tasks?
Yes, all SCCM predefined site maintenance tasks.
Ah, I was only seeing 13 tasks in the report. We have a CAS and primary site. It was only pulling the 13 tasks in the CAS site. Any tips on getting it to pull from the primary site as well?
Try to check out http://www.anoopcnair.com/2013/10/22/predefined-maintenance-task-sccm-configmgr-2012-r2/
Hi Anoop,
Can you help me !!!
How to get, Patch installation compliance report including date and time through SCCM custom reporting.
This works great once the data source was changed, many thanks Anoop,
Thank you for this very informative report!
Thanks Anoop,
How to identify machines which got deleted by Maintenance Tasks ? Please help.
Hi Anoop,
How to identify machines which are deleted by Maintenance Tasks ?
Hello Anoop. This is a very helpful post. I was wondering if you knew what the other “CompletionStatus” codes are? I know 0 means it completed, but what does 1 mean?
Hello Seth – Even I’m not sure about this now. This is very old report published many years before. I think 1 means failed or running. Can you please test it and confirm back?
Hello Anoop C Nair,
I don’t find the RDL file in your path.
Is it always available?
Thanks you
I don’t think you need RDL anymore because this is available in the console itself. But you can download the RDL from https://github.com/AnoopCNair/SCCM-Maintenance-Task-Download-RDL-file-for-SSRS-report/blob/main/Status%20of%20Predefined%20Maintenance%20Tasks.rdl
Hello Annop,
Thank you for your reply.
I know it is available in the console but I want just to schedule this report.
Have a nice day