Send Knowledge Base Article
The article has been sent to your inbox successfully.
We never share your data
How to remove a decomissioned server from SSRS reports
KB1745 | Last review: Apr 17, 2014 | Netwrix Auditor for File Servers | All versions
|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:
delete from Sessions where sessions.Object = 'decommissioned_server_name';
Was this information helpful?