How to remove a decomissioned server from SSRS reports

Last review: Oct 10, 2013
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