OT2CSV

 

ot2csv allows you to extract comma delimited values from the RRD files.

Running ot2csv by itself gives the syntax to be used:

ot2csv version 1.4 2004/03/21

USAGE: ot2csv [-amM] snmp-device-name Interface# [--resolution|-r resolution]

       ot2csv [-amM] snmp-device-name Interface# [--start|-s start] [--end|-e end]

 

       ot2csv [-amM] snmp-device-name OID Instance [--start|-s start] [--end|-e end]

 

EXAMPLE: ot2csv router_1 1

EXAMPLE: ot2csv router_1 1 -s "0:0 20011219" -e "12:0 20011220"

        From the start of the 19th Dec 2001 till midday the following day

EXAMPLE: ot2csv -M router_1 1 -s "0:0 20011219" -e "12:0 20011220"

        As above but showing Maximums

 

Let's say you are monitoring humidity (OID = 1.3.6.1.4.1.13045.1.1.2.4.1.4)

for sensor 2 on a device called 'MyDevice',

then in \OverTime\cfgs\MyDevice.mst file there will be an entry something like this:

 

1.3.6.1.4.1.13045.1.1.2.4.1.4 -1 90 "Percent"Graph of Humidity

2 -2 "Humidity

 

So to dump the data from ot2csv for the 23rd June 2004 do this:

ot2csv MyDevice 1.3.6.1.4.1.13045.1.1.2.4.1.4 2 -s "0:0 20040623" -e "0:0 20040624"