Understanding MRTG Logs

by Derek Lim on October 22, 2009

For those who like me want to be able to extract the raw data from MRTG for analysis but do not understand what it means, refer to the following:

http://oss.oetiker.ch/mrtg/doc/mrtg-logfile.en.html

Just to highlight a little more on the UNIX time stamp, I used excel to convert into date and there is a slight change to the formula. The ; should be rplaced with ,

= (x+y)/86400+DATE(1970,1,1)

Y is your GMT time in seconds. E.g. my GMT is +8, hence Y is 8hrs x 60mins x 60s.

Finally do remember to change the column category of your excel column to date and time hence you will be seeing garbage.

If you are still unsure, you can refer to the following website which automatically converts the UNIX time stamp for you.

Leave a Comment

Previous post: Step By Step Guide To Creating A New Finance Aggregator Site

Next post: How do I make the permalinks for post titles open in a new browser window?