Color / Colour to Unix output

If you want to add some color to your Unix output, use echo ^[[35m then the text you want e.g. Hello

Where ^[ is "ctrl-v escape" then [

The numeric value will depend on your TERM type (combination of text / background).

echo ^[[0m to reset text (see table below).

The available codes are:

  

0	Normal text, foreground and background
1	Bold text
4	Underline
5	Blink
7	Inverse
30	Black foreground
31	Red foreground
32	Green foreground
33	Yellow foreground
34	Blue foreground
35	Magenta foreground
36	Cyan foreground
37	White foreground
40	Black background
41	Red background
42	Green background
43	Yellow background
44	Blue background
45	Magenta background
46	Cyan backgroud
47	White background

You can combine codes in a single escape sequence by separating them with semicolons.

For example, to create a section of text that is bold text with a yellow foreground and blue background, the escape sequence would be:

^[[1;33;44m

EM 13c - email not working

Setting up EM13c and was wondering why I was not receiving any email notifications of an incident I had set up.

I was clicking on the edit button and going through the setup thinking where is the email option - well it turns out I was staring at it all along and hit a "wood for trees" moment. I think I had seen the email option but thought it was only for setting up the users and not actually for changing whether 13c set out the email. Will put together a more detailed setup guide to 13c once I have all the alerts setup that I need. Watch this space.

Compare columns in a table..

select settings_eil.param_name,  settings_eil.PARAM_VALUE, settings_qa.param_name,  settings_qa.PARAM_VALUE from settings_eil,settings_qa where settings_eil.param_name(+)=settings_qa.param_name order by settings_eil.param_name