Code

ba2c353ba4e328cc6ab12fc0ae4bf0320756f2ef
[pkg-rrdtool.git] / doc / rrdxport.txt
1 RRDXPORT(1)                         rrdtool                        RRDXPORT(1)
5 N\bNA\bAM\bME\bE
6        rrdxport - Export data in XML format based on data from one or several
7        RRD
9 S\bSY\bYN\bNO\bOP\bPS\bSI\bIS\bS
10        r\brr\brd\bdt\bto\boo\bol\bl x\bxp\bpo\bor\brt\bt [-\b-s\bs|-\b--\b-s\bst\bta\bar\brt\bt _\bs_\be_\bc_\bo_\bn_\bd_\bs] [-\b-e\be|-\b--\b-e\ben\bnd\bd _\bs_\be_\bc_\bo_\bn_\bd_\bs]
11        [-\b-m\bm|-\b--\b-m\bma\bax\bxr\bro\bow\bws\bs _\br_\bo_\bw_\bs] [-\b--\b-s\bst\bte\bep\bp _\bv_\ba_\bl_\bu_\be] [-\b--\b-d\bda\bae\bem\bmo\bon\bn _\ba_\bd_\bd_\br_\be_\bs_\bs]
12        [D\bDE\bEF\bF:\b:_\bv_\bn_\ba_\bm_\be=\b=_\br_\br_\bd:\b:_\bd_\bs_\b-_\bn_\ba_\bm_\be:\b:_\bC_\bF] [C\bCD\bDE\bEF\bF:\b:_\bv_\bn_\ba_\bm_\be=\b=_\br_\bp_\bn_\b-_\be_\bx_\bp_\br_\be_\bs_\bs_\bi_\bo_\bn]
13        [X\bXP\bPO\bOR\bRT\bT:\b:_\bv_\bn_\ba_\bm_\be[:\b:_\bl_\be_\bg_\be_\bn_\bd]]
15 D\bDE\bES\bSC\bCR\bRI\bIP\bPT\bTI\bIO\bON\bN
16        The x\bxp\bpo\bor\brt\bt function's main purpose is to write an XML formatted repre-
17        sentation of the data stored in one or several R\bRR\bRD\bDs. It can also
18        extract numerical reports.
20        If no _\bX_\bP_\bO_\bR_\bT statements are found, there will be no output.
22        -\b-s\bs|-\b--\b-s\bst\bta\bar\brt\bt _\bs_\be_\bc_\bo_\bn_\bd_\bs (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 section in the _\br_\br_\bd_\b-
27            _\bf_\be_\bt_\bc_\bh documentation for a detailed explanation on how to specify
28            time.
30        -\b-e\be|-\b--\b-e\ben\bnd\bd _\bs_\be_\bc_\bo_\bn_\bd_\bs (default now)
31            The time when the exported range should end. Time in seconds since
32            epoch.  See also AT-STYLE TIME SPECIFICATION section in the _\br_\br_\bd_\b-
33            _\bf_\be_\bt_\bc_\bh documentation for a detailed explanation of ways to specify
34            time.
36        -\b-m\bm|-\b--\b-m\bma\bax\bxr\bro\bow\bws\bs _\br_\bo_\bw_\bs (default 400 rows)
37            This works like the -\b-w\bw|-\b--\b-w\bwi\bid\bdt\bth\bh parameter of _\br_\br_\bd_\bg_\br_\ba_\bp_\bh.  In fact it
38            is exactly the same, but the parameter was renamed to describe its
39            purpose in this module. See _\br_\br_\bd_\bg_\br_\ba_\bp_\bh documentation for details.
41        -\b--\b-s\bst\bte\bep\bp _\bv_\ba_\bl_\bu_\be (default automatic)
42            See rrdgraph documentation.
44        -\b--\b-d\bda\bae\bem\bmo\bon\bn _\ba_\bd_\bd_\br_\be_\bs_\bs
45            Address of the rrdcached daemon. If specified, a "flush" command is
46            sent to the server before reading the RRD files. This allows r\brr\brd\bd-\b-
47            t\bto\boo\bol\bl to return fresh data even if the daemon is configured to cache
48            values for a long time.  For a list of accepted formats, see the -\b-l\bl
49            option in the rrdcached manual.
51              rrdtool xport --daemon unix:/var/run/rrdcached.sock ...
53        -\b--\b-e\ben\bnu\bum\bmd\bds\bs
54            The generated xml should contain the data values in enumerated
55            tags.
57             <v0>val</v0><v1>val</v1>
59        D\bDE\bEF\bF:\b:_\bv_\bn_\ba_\bm_\be=\b=_\br_\br_\bd:\b:_\bd_\bs_\b-_\bn_\ba_\bm_\be:\b:_\bC_\bF
60            See _\br_\br_\bd_\bg_\br_\ba_\bp_\bh documentation.
62        C\bCD\bDE\bEF\bF:\b:_\bv_\bn_\ba_\bm_\be=\b=_\br_\bp_\bn_\b-_\be_\bx_\bp_\br_\be_\bs_\bs_\bi_\bo_\bn
63            See _\br_\br_\bd_\bg_\br_\ba_\bp_\bh documentation.
65        X\bXP\bPO\bOR\bRT\bT:\b:_\bv_\bn_\ba_\bm_\be:\b::\b:_\bl_\be_\bg_\be_\bn_\bd
66            At least one _\bX_\bP_\bO_\bR_\bT statement should be present. The values refer-
67            enced by _\bv_\bn_\ba_\bm_\be are printed. Optionally add a legend.
69 O\bOu\but\btp\bpu\but\bt f\bfo\bor\brm\bma\bat\bt
70        The output is enclosed in an x\bxp\bpo\bor\brt\bt element and contains two blocks. The
71        first block is enclosed by a m\bme\bet\bta\ba element and contains some meta data.
72        The second block is enclosed by a d\bda\bat\bta\ba element and contains the data
73        rows.
75        Let's assume that the _\bx_\bp_\bo_\br_\bt command looks like this:
77          rrdtool xport \
78                  --start now-1h --end now \
79                  DEF:xx=host-inout.lo.rrd:output:AVERAGE \
80                  DEF:yy=host-inout.lo.rrd:input:AVERAGE \
81                  CDEF:aa=xx,yy,+,8,* \
82                  XPORT:xx:"out bytes" \
83                  XPORT:aa:"in and out bits"
85        The resulting meta data section is (the values will depend on the RRD
86        characteristics):
88          <meta>
89            <start>1020611700</start>
90            <step>300</step>
91            <end>1020615600</end>
92            <rows>14</rows>
93            <columns>2</columns>
94            <legend>
95              <entry>out bytes</entry>
96              <entry>in and out bits</entry>
97            </legend>
98          </meta>
100        The resulting data section is:
102          <data>
103            <row><t>1020611700</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
104            <row><t>1020612000</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
105            <row><t>1020612300</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
106            <row><t>1020612600</t><v>3.4113333333e+00</v><v>5.4581333333e+01</v></row>
107            <row><t>1020612900</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
108            <row><t>1020613200</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
109            <row><t>1020613500</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
110            <row><t>1020613800</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
111            <row><t>1020614100</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
112            <row><t>1020614400</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
113            <row><t>1020614700</t><v>3.7333333333e+00</v><v>5.9733333333e+01</v></row>
114            <row><t>1020615000</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
115            <row><t>1020615300</t><v>3.4000000000e+00</v><v>5.4400000000e+01</v></row>
116            <row><t>1020615600</t><v>NaN</v><v>NaN</v></row>
117          </data>
119 E\bEX\bXA\bAM\bMP\bPL\bLE\bE 1\b1
120          rrdtool xport \
121                  DEF:out=if1-inouts.rrd:outoctets:AVERAGE \
122                  XPORT:out:"out bytes"
124 E\bEX\bXA\bAM\bMP\bPL\bLE\bE 2\b2
125          rrdtool xport \
126                  DEF:out1=if1-inouts.rrd:outoctets:AVERAGE \
127                  DEF:out2=if2-inouts.rrd:outoctets:AVERAGE \
128                  CDEF:sum=out1,out2,+ \
129                  XPORT:out1:"if1 out bytes" \
130                  XPORT:out2:"if2 out bytes" \
131                  XPORT:sum:"output sum"
133 E\bEN\bNV\bVI\bIR\bRO\bON\bNM\bME\bEN\bNT\bT V\bVA\bAR\bRI\bIA\bAB\bBL\bLE\bES\bS
134        The following environment variables may be used to change the behavior
135        of "rrdtool xport":
137        R\bRR\bRD\bDC\bCA\bAC\bCH\bHE\bED\bD_\b_A\bAD\bDD\bDR\bRE\bES\bSS\bS
138            If this environment variable is set it will have the same effect as
139            specifying the "--daemon" option on the command line. If both are
140            present, the command line argument takes precedence.
142 A\bAU\bUT\bTH\bHO\bOR\bR
143        Tobias Oetiker <tobi@oetiker.ch>
147 1.3.99909060808                   2008-09-25                       RRDXPORT(1)