<html dir="ltr"><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta content="MSHTML 6.00.6000.16762" name="GENERATOR">
<style title="owaParaStyle">P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</style>
</head>
<body ocsi="x">
<div dir="ltr"><font face="Tahoma" color="#000000" size="2">I can think of several ways to achieve this. They all require you to be using RRDTool though.</font></div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
<div dir="ltr"><font face="tahoma" size="2">First, you can load the data in using a script of your own, instead of MRTG. Keep a 'dummy' MRTG file around for the benefit of your web frontend, but dont run MRTG on it. Instead, write your script to obtain the
data, and then store it into the RRD file with an explicit timestamp, 45 mins in the past. This will keep the data correct, and if you use the Routers2 frontend for MRTG/RRD you can set the 'uselastupdate' option in the routers2.conf so that the displayed
graph will be based on the last update time rather than 'now'.</font></div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
<div dir="ltr"><font face="tahoma" size="2">Second option is to write your own frontend or call to RRDTool to generate the graph. An RRDtool function exists to shift data by a number of seconds time-wise so this would correct the offset; of course you'd need
ot be using something like rrd-cgi to generate the graph and the command line would be pretty huge.</font></div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
<div dir="ltr"><font face="tahoma" size="2">Third, you could define your own timezone of 'now-45min' and use that for the Target. Since it would be displayed in the amended timezone this would effect a timeshift. A bit messy, though, even if you can control
the local server's timezone files (you cant do this on Windows as they're compiled into the library)</font></div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
<div dir="ltr"><font face="tahoma" size="2">We have a similar problem for our mail server throughput logs, although the delay is only 10min. We use the first method.</font></div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
<div dir="ltr"><font face="tahoma" size="2">Steve</font></div>
<div dir="ltr"><font face="tahoma" size="2"></font> </div>
<div id="divRpF902707" style="DIRECTION: ltr">
<hr tabindex="-1">
<font face="Tahoma" size="2"><b>From:</b> mrtg-bounces@lists.oetiker.ch [mrtg-bounces@lists.oetiker.ch] On Behalf Of John Doe [abussos@gmail.com]<br>
<b>Sent:</b> Saturday, 13 December 2008 10:20 a.m.<br>
<b>To:</b> mrtg@lists.oetiker.ch<br>
<b>Subject:</b> [mrtg] Applying a time offset to graphs<br>
</font><br>
</div>
<div></div>
<div>
<div><span class="144281121-12122008"><font size="2">Hello,</font></span></div>
<div><span class="144281121-12122008"></span> </div>
<div><span class="144281121-12122008"><font size="2">I am relatively new to MRTG and I had a question that I did not see addressed in the documentation. I am monitoring a combination of Windows Server performance counters, which are updated immediately, and
information retrieved from a database, which is not available until after a delay. As such, the "current" information being retrieved from the database sources is actually 45 minutes old. What I would like to do is to shift the x-axis of the graphs of information
from the database by 45 minutes so that if I am comparing one of those graphs to a performance counter graph, the actual times at which events are displayed match up.</font></span></div>
<div><span class="144281121-12122008"></span> </div>
<div><span class="144281121-12122008"><font size="2">Any help would be appreciated. Thanks!</font></span></div>
</div>
</body>
</html>