SCCM Custom Report to check the Status of Predefined Site Maintenance Tasks ConfigMgr Endpoint Manager

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 which can be imported 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 how to find out the status of Predefined Maintenance Tasks.

I couldn’t find the view related to SQLTaskStatus tableso I’ve created the custom report with the above mentioned table rather than view.

Two potential issues :-

1E Nomad

1. Go to Manage option of the report (from 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.

RDL Report
RDL Report1
RDL Report2

2. 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

CUSTOM Report Predefined Maintenance Task
Custom Report for Predefined Maintenance Task

20 thoughts on “SCCM Custom Report to check the Status of Predefined Site Maintenance Tasks ConfigMgr Endpoint Manager”

  1. 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”

    Reply
  2. 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)

    Reply
    • 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

      Reply
      • 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.

  3. Hi Anoop,

    Can you help me !!!

    How to get, Patch installation compliance report including date and time through SCCM custom reporting.

    Reply
  4. 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?

    Reply
    • 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?

      Reply
  5. 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

    Reply

Leave a Comment

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