1RRDXPORT(1) rrdtool RRDXPORT(1)
2
6 rrdxport - Export data in XML format based on data from one or several
7 RRD
8
10 rrdtool xport [-s|--start seconds] [-e|--end seconds]
11 [-m|--maxrows rows] [--step value] [--json] [-t|--showtime] [--enumds]
12 [--daemon|-d address] [DEF:vname=rrd:ds-name:CF] [CDEF:vname=rpn-
13 expression] [XPORT:vname[:legend]]
14
16 The xport function's main purpose is to write an XML formatted
17 representation of the data stored in one or several RRDs. It can also
18 extract numerical reports.
19 If no XPORT statements are found, there will be no output.
21 -s|--start seconds (default end-1day)
23 The time when the exported range should begin. Time in seconds
24 since epoch (1970-01-01) is required. Negative numbers are relative
25 to the current time. By default one day worth of data will be
26 printed. See also "AT-STYLE TIME SPECIFICATION" in rrdfetch for a
27 detailed explanation on how to specify time.
28 See "OUTPUT FORMAT" below for details on how this affects the
30 output.
31 -e|--end seconds (default now)
33 The time when the exported range should end. Time in seconds since
34 epoch. See also "AT-STYLE TIME SPECIFICATION" in rrdfetch for a
35 detailed explanation on how to specify time.
36 See "OUTPUT FORMAT" below for details on how this affects the
38 output.
39 -m|--maxrows rows (default 400 rows)
41 This works like the -w|--width parameter of rrdgraph. In fact it
42 is exactly the same, but the parameter was renamed to describe its
43 purpose in this module. See rrdgraph documentation for details.
44 --step value (default automatic)
46 See rrdgraph documentation.
47 --daemon|-d address
49 Address of the rrdcached daemon. If specified, a "flush" command is
50 sent to the server before reading the RRD files. This allows
51 rrdtool to return fresh data even if the daemon is configured to
52 cache values for a long time. For a list of accepted formats, see
53 the -l option in the rrdcached manual.
54 rrdtool xport --daemon unix:/var/run/rrdcached.sock ...
56 -t|--showtime
58 include the time into each data row.
59 --json
61 produce json formatted output (instead of xml)
62 --enumds
64 The generated xml should contain the data values in enumerated
65 tags.
66 <v0>val</v0><v1>val</v1>
68 DEF:vname=rrd:ds-name:CF
70 See rrdgraph documentation.
71 CDEF:vname=rpn-expression
73 See rrdgraph documentation.
74 XPORT:vname[:legend]
76 At least one XPORT statement should be present. The values
77 referenced by vname are printed. Optionally add a legend.
78
80 The output is enclosed in an xport element and contains two blocks. The
81 first block is enclosed by a meta element and contains some meta data.
82 The second block is enclosed by a data element and contains the data
83 rows.
84 Let's assume that the xport command looks like this:
86 rrdtool xport \
88 --start now-1h --end now \
89 DEF:xx=host-inout.lo.rrd:output:AVERAGE \
90 DEF:yy=host-inout.lo.rrd:input:AVERAGE \
91 CDEF:aa=xx,yy,+,8,* \
92 XPORT:xx:"out bytes" \
93 XPORT:aa:"in and out bits"
94 The resulting meta data section is (the values will depend on the RRD
96 characteristics):
97 <meta>
99 <start>1020611700</start>
100 <step>300</step>
101 <end>1020615600</end>
102 <rows>14</rows>
103 <columns>2</columns>
104 <legend>
105 <entry>out bytes</entry>
106 <entry>in and out bits</entry>
107 </legend>
108 </meta>
109 The resulting data section is:
111 <data>
113 <row><t>1020611700</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
114 <row><t>1020612000</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
115 <row><t>1020612300</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
116 <row><t>1020612600</t><v>3.4113333333e+00</v><v>5.4581333333e+01</v></row>
117 <row><t>1020612900</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
118 <row><t>1020613200</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
119 <row><t>1020613500</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
120 <row><t>1020613800</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
121 <row><t>1020614100</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
122 <row><t>1020614400</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
123 <row><t>1020614700</t><v>3.7333333333e+00</v><v>5.9733333333e+01</v></row>
124 <row><t>1020615000</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
125 <row><t>1020615300</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
126 <row><t>1020615600</t><v>NaN</v><v>NaN</v></row>
127 </data>
128 All the statistics in the output will use the same step. The first
130 sample will be the first sample starting immediately after --start. The
131 last sample will be the one ending at or immediately after --end.
132 Each sample has a timestamp and one or more values. The timestamps
134 associated with a value in RRDtool ALWAYS represent the time the sample
135 was taken. Since any value you sample will represent some sort of past
136 state your sampling apparatus has gathered, the timestamp will always
137 be at the end of the sampling period.
138 RRDtool does not store the actual samples, but does internal resampling
140 of the values presented to it. Nevertheless when a data value is
141 presented with a single timestamp the timestamp is at the end of the
142 period the value represents. Note that the timestamp itself is outside
143 the period the sample is valid for. For more details about this, see
144 PDP calculation explanation.
145 So the time range for a sample with a timestamp is actually from
147 "timestamp - step" inclusive to "timestamp" exclusive.
148 The first line of the sample output:
150 <row><t>1020611700</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
152 therefore means that the values for the interval 1020611400 to
154 1020611699 were 3.4 and 54.4 for "out bytes" and "in and out bits"
155 respectively, because the value was taken at 1020611700.
156
158 rrdtool xport \
159 DEF:out=if1-inouts.rrd:outoctets:AVERAGE \
160 XPORT:out:"out bytes"
161
163 rrdtool xport \
164 DEF:out1=if1-inouts.rrd:outoctets:AVERAGE \
165 DEF:out2=if2-inouts.rrd:outoctets:AVERAGE \
166 CDEF:sum=out1,out2,+ \
167 XPORT:out1:"if1 out bytes" \
168 XPORT:out2:"if2 out bytes" \
169 XPORT:sum:"output sum"
170
172 The following environment variables may be used to change the behavior
173 of "rrdtool xport":
174 RRDCACHED_ADDRESS
176 If this environment variable is set it will have the same effect as
177 specifying the "--daemon" option on the command line. If both are
178 present, the command line argument takes precedence.
179
181 Tobias Oetiker <tobi@oetiker.ch>
1821.7.2 2019-05-27 RRDXPORT(1)