Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Database Performance Analyzer (DPA) > Hide a registered database instance on the DPA homepage

Hide a registered database instance on the DPA homepage

Table of contents
No headers
Created by Interspire Import, last modified by Melanie Boyd on Nov 16, 2017

Views: 17 Votes: 0 Revisions: 9

Last updated November 16, 2017

There are times when you may want to hide a registered database instance from appearing on the DPA homepage. To do this, first find the ID of the database instance. You can get this information by querying the DPA repository either through a native tool (like SSMS) or by using the Database Query Tool. 

To access the Database Query Tool:

  1. Click Options and then click the Support tab.
  2. Click Database Query tool.

To get a list of database instances and their IDs, run the following query:

SELECT *
FROM COND
ORDER BY ID;

Or, using the Database Query Tool, you can select "Monitored Instances" from a list of pre-defined queries in the Quick Query menu and press the ‘Execute Query’ button.

 

After you know the ID of the database instance you want to hide, update the COND table for that particular ID. For example, to hide a database instance with an ID of 23, issue the following statement:

UPDATE COND
SET f = 'N'
WHERE ID = 23

The result is:

  1. The database instance appears as stopped on the home page.
  2. If you restart/refresh your browser window, it should disappear from view within a few minutes.

 

To display this database instance again, run the following query. (Replace "23" in this example with the ID of the instance.)

UPDATE COND
SET f = 'Y'
WHERE ID = 23
Last modified

Tags

Classifications

Public