Submit a ticketCall us

WebinarVisual Monitoring Tactics: Getting More Log Search Value from SolarWinds Log & Event Manager with nDepth Webcast

Do things seem to make more sense when they are visualized? Are you an IT professional or security expert with a wish for more cybersecurity tools that provide an intuitive visual experience? Join Alexis Horn and Jamie Hynds from SolarWinds as they demonstrate how the nDepth feature in LEM can help make visualizing log search results a reality.

Register now.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Hide Databases from Appinsight for SQL via the All Databases widget

Hide Databases from Appinsight for SQL via the All Databases widget

 

Updated July 27, 2018

Overview

This article discusses a workaround to hide databases from the AppInsight for SQL via the All Databases widget.

 

Note: This does not unmanage the database. This workaround hides the database from being shown, but the Orion Platform will still alert on it.  To prevent the database from triggering alerts, make sure you unmanage the database on the Database Details page's Management widget before proceeding.

 

Environment

  • SAM 6.2+

Resolution

Step 1: 

  1. Log into the Orion 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 the Orion 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