Define the colors used for colored ranges

The colors that are available for selection when users create colored ranges are customizable. By default, four colors are available (gray, green, yellow, and red). However, you can add more colors, edit existing colors, and remove colors.

Add a new color

To add a new color to the drop-down list that is displayed when users create colored ranges in reports, follow these steps:

1. Type db in the command box, and then press Enter.
2. Enter scmessage in the Table field and then click the Search icon.
3. Select message.edit in the Format Name column.
4. In the Class field, type Global.
5. In the Message Number field, enter chart.<color name>. For example, type chart.black.
6. In the Text field, type the name of the color as you want it to be displayed on the UI. For example, type Black.
7. Click Add to add this record to the scmessage table.
8. Type gl in the command box, and then press Enter.
9. Enter Chart Threshold Color Indicator in the List Name field, and then click Search to open the Chart Threshold Color Indicator global list.
10. Add new number to the comma-delimited list in the Value List field. For example, update {"1","2","3","4"} to {"1","2","3","4","5"}.
11. In the Display List field, enter the value that you entered in the Message Number field of the scmessage table in step 5. For example, type chart.black.
12. Click Save, click Rebuild Global List in the More menu, and then click Save again. The color is then added to the list in the SM message List field.
13. Type db in the command box, and then press Enter.
14. Enter colorindicatorsetting in the Table field and then click the Search icon.
15. Select colorindicatorsetting in the Format Name column.
16. Enter Inbox in the File field, and then click Search.
17. Click Add to open the Color Indicator Setting Wizard.
18. In the Value field, enter the name of the color that you want to add.
19. In the Foreground Color field, specify the foreground color. To do this, enter the hex code of the color, or you click the text field, and then select a color from the color palette.
20. In the Background Color field, specify the background color (this is the color that is displayed in reports). To do this, enter the hex code of the color, or you click the text field, and then select a color from the color palette.
21. Click OK to add the color to the table, and then click Save to save your changes.
22. Log out and then log back in to Service Manager for your changes to take effect in reports.

Modify an existing color

To modify a color in the drop-down list that is displayed when users create colored ranges in reports, follow these steps:

1. Type db in the command box, and then press Enter.
2. Enter colorindicatorsetting in the Table field and then click the Search icon.
3. Select colorindicatorsetting in the Format Name column.
4. Enter Inbox in the File field, and then click Search.
5. Click Edit beside the color that you want to modify to open the Color Indicator Setting Wizard.
6. Modify the colors in the Foreground Color and Background Color fields as desired. To do this, enter the hex code of the color, or you click the text field, and then select a color from the color palette.
7. Click OK, and then click Save to save your changes.
8. Log out and then log back in to Service Manager for your changes to take effect in reports.

Remove an existing color

To remove a color from the drop-down list that is displayed when users create colored ranges in reports, follow these steps:

1. Type gl in the command box, and then press Enter.
2. Enter Chart Threshold Color Indicator in the List Name field, and then click Search to open the Chart Threshold Color Indicator global list.
3. From the following fields, delete the values that correspond to the color you want to remove:
   • Value List
   • Display List
   • Message Number
4. Click Save, click Rebuild Global List in the More menu, and then click Save again. The color is then removed from the list in the SM message List field.
5. Type db in the command box, and then press Enter.
6. Enter colorindicatorsetting in the Table field and then click the Search icon.
7. Select colorindicatorsetting in the Format Name column.
8. Enter Inbox in the File field, and then click Search.
9. Click Delete beside the color that you want to remove from the drop-down list.
10. Click Save to save your changes.
11. Log out and then log back in to Service Manager for your changes to take effect in reports.