Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Server & Application Monitor (SAM) > Hide Databases from Appinsight in SAM for SQL 'All Databases' Resource

Hide Databases from Appinsight in SAM for SQL 'All Databases' Resource

Updated: November 1, 2017

Overview

This article discusses a workaround to Hide Databases from the Appinsight for SQL 'All Databases' Resource

 

Please note.  This will hide the database from being shown, but it will still alert on it.  If you want to keep the database from alerting as well, please make sure you unmanage the database from the database details page before you go through this process.

 

Environment

  • SAM 6.2+

Resolution

Step 1: 

  1. Log into the web console.
  2. Navigate to the Appinsight for SQL Details page for your SQL instance.
  3. In the URL of the browser, the last couple of digits refers to the ApplicationID.

Example: http://Solarwinds/Orion/APM/SqlBlack...NetObject=ABSA:168

  1. Take note of this applicationID.

 

Step 2:

  1. Log into your SolarWinds server
  2. Open database manager
  3. Click Add Default Server
  4. Expand the Orion Database
  5. Locate the table 'APM_SqlBbDatabase'
  6. Run the following query:
SELECT TOP 1000 * FROM [dbo].[APM_SqlBbDatabase] where applicationId = 168
  1. Please update the ApplicationID to match your Application ID which you gathered from Step 1.
  2. Click Enable table editing above the Query text box.
  3. Uncheck the box in the column 'visible' to hide the database from this view. 

 

  1. Click 'Enable table editing' again once you're done un-checking all of the Databases which you do not want to appear on the Appinsight for SQL Details Page.

 

 

 

 

 

Last modified

Tags

Classifications

Public