Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Database Performance Analyzer (DPA) > Change the display color of a database instance

Change the display color of a database instance

Overview

New database instances may have colors similar to the colors of existing database instances. 

Environment

  • DPA

Cause 

 

Ignite chooses database colors based on the names of the host and database instance. In many environments, these names are similar due to naming standards.

Resolution

  1. From the main page of Ignite, click the Options link
  2. On the Options page, click the Database Query Tool link
  3. Enter in the following query and click the Execute Query button: select NAME from COND;
  4. Note the name for the database instance that you want to recolor.
  5. Enter the following statement but substitute the name for MYINSTANCE_MYHOST and substitute in the color of your choice for "33023".  See below for color codes. 
  6. Click the Execute Query button.
    1. Use this for version Ignite Version 7.0 or later:

       insert into CON_COLOR (TEXTSTRING, COLOR)  values ('MYINSTANCE_MYHOST',33023);

    2. Use this for version Ignite Version 4.3 or earlier:

      insert into CON_COLOR (DBID, TEXTSTRING, COLOR) values (0,'MYINSTANCE_MYHOST',33023);
      Note: When running Ignite 4.3 or below with SQL Server or DB2 databases that contain a backslash in their NAME, remove this backslash when entering it as MYINSTANCE_MYHOST.

  7. Wait one minute so Ignite will reload the new colors, then go back to the "Options" page and click "Clear Ignite Chart Cache"

Color Codes

Below are some common color codes that can be used:

COLOR                        NUMBER
Black                           0
White                           16777215
Red                              230
Orange                         33023
Yellow                          65535
Green                           2534179
Blue                             16711680
Purple                          16718476
Cyan                            16776960
Magenta                       16711935
Light Gray                     12632256
Dark Gray                     4210752

Gray                             8421504

The numbers are a BGR value (reversed endian of RGB). The formula for RGB to BGR is:
 
(blue*65536) + (green*256) + red;

Last modified
16:51, 22 Dec 2015

Tags

Classifications

Public