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 > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > 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: 704 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