Skip to main content

How to remove a decomissioned server from SSRS rep

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

Resolution

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';