nagios logs to qv help !!

[mjayachandran]

Hi,

See the Table below

Timestamps	Serve	Service	Status
12/30/2013 18:56:50	A	Check Load Average	OK
12/30/2013 18:58:14	A	Check Load Average	WARNING
12/30/2013 18:59:42	A	Check Load Average	WARNING
12/30/2013 21:07:45	B	Check Load Average	OK
12/30/2013 22:48:48	C	Check Load Average	WARNING
12/30/2013 22:49:20	B	Check Load Average	OK
12/30/2013 22:50:38	C	Check Load Average	OK
12/30/2013 23:10:53	D	Check Load Average	CRITICAL
12/30/2013 23:12:17	D	Check Load Average	CRITICAL
12/30/2013 23:13:44	D	Check Load Average	WARNING
12/30/2013 23:15:22	D	Check Load Average	OK

I have many log file that are from Nagios which is a server monitoring application. Nagios write all the server logs to 1 log file like shown in the above table. I am trying to achieve the below graph for Server A only. Similarly for Server B and so on.
I'm a rookie to QV and need your help coding

Can you help me achieve the above

by looking at the graph questions like below should be answerable:

How long Server A was in Critical State

How long Server A was in Warning State

[mjayachandran]

any help here friends !!