SCCM Default Reports Missing in Console

Question

SCCM Default Reports Missing in Console “No Items Found”

But I can access the reports via webservice  & webportal URLs from the database

Eg:http://Database/Reports;http://Database/ReportServer

But from other machines, it’s not able to access “Page can’t be displayed ” error am getting.

And the main issue it’s not integrating with SCCM Console. It’s showing as

“No Items Found”.

As I checked there is no permission issues with the accounts I am using in DB and as well a Site Server both having domain admin access as well.

WebReporturl - How To Manage Devices Community Forum - Welcome to the world of Device Management! This is community build by Device Management Admins for Device Management Admins❤️ Ask your questions!! We are here to help you! - SCCM Default Reports Missing in Console Report error - How To Manage Devices Community Forum - Welcome to the world of Device Management! This is community build by Device Management Admins for Device Management Admins❤️ Ask your questions!! We are here to help you! - SCCM Default Reports Missing in Console

in progress 0
VAISHNAV. K 4 months 8 Answers 134 views Beginner 0

Answers ( 8 )

  1. Hi,

    I have faced same issue in SCCM 1906 version with SQL server as 2016 version.

    Is that SQL Server service is running with service account or local system account?

    Is that SSRS service is running with service account or local account?

    Thanks
    Karthikeyan

  2. Any update on this issue please?

  3. Thanks for the reply Harjith. But am not using any proxy.

  4. I normally do the following troubleshooting steps to make sure everything is ok with sccm SSRS report

    https://www.anoopcnair.com/sccm-troubleshooting-tips-on-reporting-server-ssrs-issues/

    Some users are not visible the reports on the SCCM console. The following reasons the users are not getting the reports folder.

    (1) The SCCM database configured on other server.

    (2) Report Server Encryption Key may be correpted.

    Please refer the document for resolve the issue.

    Summery below

    Step 1: Open the Reporting Services Configuration Manager Connection on the database server

    Step 2: Open the Report Server instance

    Step 3: go to the Encryption Keys location and take the backup of encryption key

    Step 4: Go to the Delete Encrypted content and wait 15 mins.

    Step 5: Close the SCCM console and open the SCCM console report folder.

    If the problem is not solved. Please proceed the below step

    Step 1: Go to report server installed Server and open the command prompt (Runas administrator)

    Step 2: run the below command

    mofcomp.exe “C:Program Files (x86)Microsoft SQL Server110Sharedsqlmgmproviderxpsp2up.mof”
    Step 3: Close the SCCM console and open the SCCM console report folder.

    As per https://gallery.technet.microsoft.com/SCCM-Reports-not-visible-1961bc25

    I have not tested this solution

    • Hi Anoop, I have already gone through the below troubleshooting steps.Got below error

      CMD:-

      C:Usersvaishnav.LAB>mofcomp.exe “C:Program Files (x86)Microsoft SQL Server110Sharedsqlmgmproviderxpsp2up.mof”
      Microsoft (R) MOF Compiler Version 10.0.14393.0
      Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
      File ‘C:Program Files (x86)Microsoft SQL Server110Sharedsqlmgmproviderxpsp2up.mof’ not found!

      C:Usersvaishnav.LAB>

  5. First, check to see if the SQL Server Reporting Services service is running as Local System.

    If you are using a proxy, then you need to enable “bypass proxy server for local addresses” in Internet Explorer. Open Internet Explorer, go to Internet Option, click on Connections tab, click on LAN Settings, and select the checkbox. Again this is only if you are using a proxy.
    https://snipboard.io/dEbvrn.jpg

    Give this a try and if it’s still an issue, we can suggest other steps.

Leave an answer

Sorry, you do not have a permission to answer to this question .