Download RDL file for SSRS report for Maintenance Task. Please download the RDL file and import it to your SSRS server. That is it. You are done. Run the report and be aware of the status of your maintenance tasks weekly or daily.

Read the full post from

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

This post is a continuation of my old post how to find out the status of Predefined Maintenance Tasks.

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