SCCM: missing user created reports after reinstalling Reporting Services component

Anna m 1 Reputation point
2021-11-11T12:22:25.427+00:00

Hello!
Another dude reinstall SCCM reporting services component and all user created reports are lost. I restored vm from backup, log into a report services web console, but didnt find my reports. They should be there because reinstallation was at 28 Oct but my backup is from 27 of Oct.another issue - maybe reports deleted, because user account now deactivated in AD. Because i cant find any logs with that user account now in SCCM Status Message Queries

Any help?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,991 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,601 Reputation points
    2021-11-12T05:57:37.56+00:00

    Hi @Anna m ,
    The uploaded report is not tied to the user.
    If you have a backup before reinstalling, after you restore the report server database, you can view the reports of your report server through the following statement:

    SELECT *
    FROM dbo.Catalog
    WHERE Type = 2

    You could download/manage these reports locally in the report manager (web portal).

    In addition, we usually save related reports locally before uploading/deploying to the report server. The storage location of the local report file depends on the storage path of the report during development.


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.