[mrtg] Re: Longer-term history recording

Toye, Peter Peter.Toye at gbr.xerox.com
Thu Feb 27 12:10:51 MET 2003


Oh dear, the attachment doesn't seem to have worked. I'll put the email text
in at the end.

My own problem is a bit different, I don't really have time to learn yet
another scripting language and would very much prefer an off-the-shelf tool
to a toolkit and a lot of work.

Regards,

Peter


-----Original Message-----
From: Toye, Peter 
Sent: 27 February 2003 10:14
To: 'Naveen Sivenandan'; 'John West'
Cc: 'mrtg at list.ee.ethz.ch'
Subject: [mrtg] Re: Longer-term history recording


John, Naveen,

I asked a similar question, basically about exporting the database into CSV
format so that I can process it later with Excel or Access or similar. I was
told that rrdtool is a good start. See the attached email.

Regards,

Peter

Managed Network Operations
WorldCom
c/o EDS
Phoenix House
Coronation Road
Cressex Industrial Estate
High Wycombe
HP12 3TA

Tel: 01494 607708
Fax: 01494 607999


-----Original Message-----
From: Naveen Sivenandan [mailto:Naveen.Sivenandan at BTGroup.co.za]
Sent: 25 February 2003 06:30
To: 'John West'
Cc: 'mrtg at list.ee.ethz.ch'
Subject: [mrtg] Re: Longer-term history recording



Hi,,

I would be interested. Requests are often made to me , to look at
utilization trends for more than a 12 month period etc. 

Regards
Naveen

-----Original Message-----
From: John West [mailto:jwest at cptech.com]
Sent: 24 February 2003 09:44
To: mrtg at list.ee.ethz.ch
Subject: [mrtg] Longer-term history recording


Please accept my apologies and a request for redirection if this is an
often discussed topic, a FAQ, or if this is just outright the wrong
forum for this sort of inquiry.

I'm considering writing a companion piece of software for MRTG.  What I
have in mind is something that will capture the graphs that MRTG
produces on a regular basis.  These graphs would be stored, likely in a
database, to provide a longer-term history than MRTG currently allows. 
Naturally, a corresponding web front-end would need to be written to
allow for viewing the archived data.  I'm thinking I'll even link the
live data in as well, just to keep it seamless.

I'm aware that recording the historical images in this manner undoes all
of the effort of the round-robin database.  However, it is a requirement
of my environment.

So, my questions to the list are:

1.) Is anyone else interested in this sort of thing?  If there is enough
interest, I could make the effort to generalize my approach.  If I know
that I can scratch someone else's itch, it makes it far more worth my
while.

2.) Has someone else already done this?  It'd save me the effort.  ;)  I
haven't found any references to such a beast, but MRTG has been around
long enough that I start to doubt that this is an original idea.

3.) Would you recommend saving the raw data or just the images?   By
making some rudimentary guesstimates, it would seem that storing the
images would take far less disk space than the data itself.  The
downside, of course, is that you lose the ability to report on that
data.  If I'm writing this more generally, I can of course make this
optional.

Again, I apologize if I'm posting this in the wrong forum.  Please let
me know if there is somewhere better suited.  Any constructive comments
are most welcome.

Thanks

--John

-- 
John West                          Software Consultant, Perl Monk
Corporate Technologies, Inc.                         781-273-4100

-- Attached file removed by Ecartis and put at URL below --
-- Type: application/pgp-signature
-- Desc: This is a digitally signed message part
-- Size: 190 bytes
-- URL : http://www.ee.ethz.ch/~slist/pantomime/36-signature.asc


--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://www.ee.ethz.ch/~slist/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi

--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://www.ee.ethz.ch/~slist/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi



-- Binary/unsupported file stripped by Ecartis --
-- Err : No filename to use for decode, file stripped.
-- Type: message/rfc822
-- Desc: RE: [mrtg] Exporting mrtg database


--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://www.ee.ethz.ch/~slist/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi


=====================================================================
Dan,

Thanks for this. I'm a bit of an MRTG virgin and don't know where to find
the tools. I don't even have Perl on my PC (the MRTG system is 50 miles away
and on a different network, so I can't even log into it).

I'll poke around that part of Tobi's website.

Regards,

Peter


-----Original Message-----
From: McDonald, Dan [mailto:Dan.McDonald at austinenergy.com]
Sent: 18 February 2003 15:22
To: Toye, Peter
Subject: RE: [mrtg] Exporting mrtg database


rrdtool or rateup?

With rrdtool, it's fairly trivial to write that using the RRDs perl module.
try perldoc RRDs for more information on that library...

I imagine there are similar things in the rateup community as well...

Daniel J McDonald, CCIE #2495, CNX
Lan/Wan Integrator
Austin Energy
1.512.322.6739
dan.mcdonald at austinenergy.com


-----Original Message-----
From: Toye, Peter [mailto:Peter.Toye at gbr.xerox.com]
Sent: Tuesday, February 18, 2003 9:13 AM
To: 'mrtg at list.ee.ethz.ch'
Subject: [mrtg] Exporting mrtg database



I am looking for a tool to export the MRTG database (or selected polled
elements thereof) to a CSV file. I need to be able to script this from an at
or cron job, as we cannot ask staff to do it manually. I've looked at Steve
Shipway's routers.cgi script, but this needs interaction, and with 90 pages
of Perl, it's a tall order to edit it to suit, especially as I'm a
networker, not a Perl programmer.

Does anyone know of any other tools out there which would do the job?

Regards,

Peter

Managed Network Operations
WorldCom
c/o EDS
Phoenix House
Coronation Road
Cressex Industrial Estate
High Wycombe
HP12 3TA
United Kingdom

Tel: +44 1494 607708
Fax: +44 1494 607999

--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://www.ee.ethz.ch/~slist/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi

--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://www.ee.ethz.ch/~slist/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi



More information about the mrtg mailing list