Using macro info from nagios logs

[Deborah Martin]

Hi, 

I'm currently trying to put together some reports based on the nagios log
generated using SQL. 

Could anyone tell me, where  $LASTCHECKTIME$ is derived from. 

I'm currently logging the date and time using $DATE and $TIME to give me the
date / time a plugin was run but this doesn't seem 
to tally with $LASTSERVICESTATECHANGE$ and $SERVICEDURATIONSEC$ . 

I guess  I've misunderstood something here ? Would $LASTCHECKTIME$ be a
better macro to use as it uses time since the unix epoch which is GMT based
timestamps ? 

thanks,
deborah 



***************************************************************************
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. 
Any unauthorised distribution or copying is strictly prohibited.

Whilst Kognitio Limited takes steps to prevent the transmission of viruses 
via e-mail, we can not guarantee that any email or attachment is free from
computer viruses and you are strongly advised to undertake your own anti-virus 
precautions.

Kognitio grants no warranties regarding performance, use or quality of any 
e-mail or attachment and undertakes no liability for loss or damage, 
howsoever caused.

Kognitio Limited
Registered in England:  0212 7833
Registered Address:	3a Waterside Park
				Cookham Road
				Bracknell
				Berks
				RG12 1RB
VAT number:			864 4378 92
***************************************************************************



-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null