How to remove a decomissioned server from SSRS reports

6.5 and older
Copy Article URL Copied

How to remove a decommissioned file server from the drop down menu in SQL Report Manager?

To remove this server from reports, open MS SQL Management Studio, connect to your SQL server which hosts the Netwrix databases, click on "New query" and execute the following query:

use NetWrix_File_Server_Change_Reporter
delete from Sessions where sessions.Object = 'decommissioned_server_name';

Go Up