Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

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