How to remove a decomissioned server from SSRS reports

Email It to Me Print this Page
Question How to remove a decommissioned file server from the drop down menu in SQL Report Manager?
Answer 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';
Was this information helpful?