<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-SG link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hi All,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’ve setup a way to collect logs and later import logs into an rrd database.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Now lets say at the time of collection is 2pm.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>By the time (say 4pm) I return to the office and import the data into the rrd database.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The graph when generated will show a time gape of between 4pm and 2pm (where the last data is seen).<o:p></o:p></p><p class=MsoNormal>This is because the graph by default is the latest time.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>How do I specify to rrdgraph that I want to only show the graph up to the last time of data collection (2pm).<o:p></o:p></p><p class=MsoNormal>I can obtain the last unixtime of the last record imported to put it into a script if that helps.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Here is a sample of the graph I am generating.<o:p></o:p></p><p class=MsoNormal>$1 = 1 day, 1 week, 5 weeks, 1 year<o:p></o:p></p><p class=MsoNormal>$2 = file name extension for 1day, 1 week,5 weeks, 1year<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>rrdtool graph $GRAPHOPTS --start -$1 $WWWPREFIX/client-$2.$IMGFILEEND -w $WSIZE -h $HSIZE -l 0\<o:p></o:p></p><p class=MsoNormal> -t "Client License Utilisation" \<o:p></o:p></p><p class=MsoNormal> -v "packets" \<o:p></o:p></p><p class=MsoNormal> DEF:client-license=$FILE.$RRDFILEEND:client-license:AVERAGE \<o:p></o:p></p><p class=MsoNormal> DEF:client-detected=$FILE.$RRDFILEEND:client-detected:AVERAGE \<o:p></o:p></p><p class=MsoNormal> DEF:client-active=$FILE.$RRDFILEEND:client-active:AVERAGE \<o:p></o:p></p><p class=MsoNormal> DEF:client-paying=$FILE.$RRDFILEEND:client-paying:AVERAGE \<o:p></o:p></p><p class=MsoNormal> DEF:client-internet=$FILE.$RRDFILEEND:client-internet:AVERAGE \<o:p></o:p></p><p class=MsoNormal> LINE1:client-license#ff00ff:"License " \<o:p></o:p></p><p class=MsoNormal> LINE2:client-detected#0000ff:"Detected " \<o:p></o:p></p><p class=MsoNormal> LINE3:client-active#00ffff:"Active " \<o:p></o:p></p><p class=MsoNormal> LINE4:client-paying#ffff00:"Logged in " \<o:p></o:p></p><p class=MsoNormal> LINE5:client-internet#ff0000:"Network Devices " \<o:p></o:p></p><p class=MsoNormal> CDEF:perc-client-license=client-license,1,* \<o:p></o:p></p><p class=MsoNormal> CDEF:perc-client-detected=client-detected,1,* \<o:p></o:p></p><p class=MsoNormal> CDEF:perc-client-active=client-active,1,* \<o:p></o:p></p><p class=MsoNormal> CDEF:perc-client-paying=client-paying,1,* \<o:p></o:p></p><p class=MsoNormal> CDEF:perc-client-internet=client-internet,1,* \<o:p></o:p></p><p class=MsoNormal> COMMENT:"\l" \<o:p></o:p></p><p class=MsoNormal> COMMENT:"Licenese limit " \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-license:AVERAGE:"avg %6.1lf \t" \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-license:LAST:"last %6.1lf \t" \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-license:MAX:"max %6.1lf " \<o:p></o:p></p><p class=MsoNormal> COMMENT:"\l" \<o:p></o:p></p><p class=MsoNormal> COMMENT:"Detected devices " \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-detected:AVERAGE:"avg %6.1lf \t" \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-detected:LAST:"last %6.1lf \t" \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-detected:MAX:"max %6.1lf " \<o:p></o:p></p><p class=MsoNormal> COMMENT:"\l" \<o:p></o:p></p><p class=MsoNormal> COMMENT:"Active devices " \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-active:AVERAGE:"avg %6.1lf \t" \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-active:LAST:"last %6.1lf \t" \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-active:MAX:"max %6.1lf " \<o:p></o:p></p><p class=MsoNormal> COMMENT:"\l" \<o:p></o:p></p><p class=MsoNormal> COMMENT:"Logged in users " \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-paying:AVERAGE:"avg %6.1lf \t" \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-paying:LAST:"last %6.1lf \t" \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-paying:MAX:"max %6.1lf " \<o:p></o:p></p><p class=MsoNormal> COMMENT:"\l" \<o:p></o:p></p><p class=MsoNormal> COMMENT:"Network Devices " \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-internet:AVERAGE:"avg %6.1lf \t" \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-internet:LAST:"last %6.1lf \t" \<o:p></o:p></p><p class=MsoNormal> GPRINT:perc-client-internet:MAX:"max %6.1lf" \<o:p></o:p></p><p class=MsoNormal> COMMENT:"\l"<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Could somebody comment on how to do this?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks a lot!<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regards,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Michael<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>