[Xymon] export usage reports for management

[Steve Holmes]

Excellent! Thanks. One more reason to upgrade. But this will save me LOTS
of time.
Thanks Henrik.
Steve

On Wed, Jan 11, 2012 at 12:08 PM, Henrik Størner <henrik at hswn.dk> wrote:

> On 11-01-2012 17:43, Steve Holmes wrote:
>
>> I know this isn't really what Xymon is designed to do, but I've been
>> asked to produce data for a text based report of usage (cpu, memory, and
>> disk weekly averages (which I've yet to convince them might not make
>> sense)) from Xymon history or rrd data for management. The requester
>> will put the data I provide into a spreadsheet.
>>
>> Before I go re-inventing the wheel I'm wondering if anyone has done
>> something like this already.
>>
>
> perfdata.cgi - ships with Xymon 4.3.x. Dumps all of the data in the RRD
> files to a comma-separated file (CSV) that you can import into Excel for
> further processing.
>
> Hmm, I see it isn't documented. Anyway, I do the extract once a month with
> this script:
>
>
> #!/bin/sh
>
> START=`date '+%Y%m01' --date="1 month ago"`
> END=`date '+%Y%m01'`
>
> xymoncmd perfdata.cgi $START $END 2>/dev/null | \
>   gzip >~ftp/perfmonthly/data-$END.gz
>
>
> If you only want to export data from a particular group of Xymon servers,
> perfdata.cgi takes a "--page=REGEXP" option to only extract data for hosts
> that appear on a page matching REGEXP (a regular expression). But it is
> surprisingly fast to export data from even a very large number of hosts.
>
> There's also a "--csv=CHAR" option, in case your local Excel version uses
> another character than comma as the delimiter in CSV-files (around here, we
> use semi-colon...)
>
> Here's an example of the data:
>
> "hostname";"datasource";"**rrdcolumn";"measurement";"**time";"value"
> "myserver01";"la.rrd";"la";"**pctbusy";"20111201010000";2.**753750
> "myserver01";"la.rrd";"la";"**pctbusy";"20111201030000";2.**359861
> "myserver01";"la.rrd";"la";"**pctbusy";"20111201050000";3.**428056
> "myserver01";"la.rrd";"la";"**pctbusy";"20111201070000";2.**363194
> "myserver01";"la.rrd";"la";"**pctbusy";"20111201090000";3.**246250
>
> As you can see, it is a rather raw export of the RRD data with a timestamp
> on RRD datapoint - it doesn't do any aggregation/averaging over the past
> week. You'll have to do that yourself in Excel.
>
> "pctbusy" means the "percent CPU busy". For Unix-systems, perfdata.cgi
> pulls data from the "vmstat" data, so you will also get a "percent busy"
> reading for those systems - not a "load average".
>
> There are some other data items:
>
> "myserver01";"memory.actual.**rrd";"realmempct";"Virtual";"**
> 20111201010000";0.000000
> "myserver01";"memory.real.rrd"**;"realmempct";"RAM";"**
> 20111201010000";49.708333
> "myserver01";"memory.swap.rrd"**;"realmempct";"Swap";"**
> 20111201010000";23.416667
>
> "Virtual", "RAM" and "Swap" correspond to the data-items you'll see on the
> "Memory" status in Xymon.
>
> "myserver01";"disk,C.rrd";"**pct";"/C";"20111201010000";77.**000000
>
> How full a disk is.
>
>
> Note that since this pulls data directly from the RRD files, the
> granularity of the data depends on how old they are. If you pull data from
> the past week, you'll get 5-minute or 30-minute readings; if you pull data
> more than 48 days old, you'll only get 1-day averages.
>
>
> Regards,
> Henrik
> ______________________________**_________________
> Xymon mailing list
> Xymon at xymon.com
> http://lists.xymon.com/**mailman/listinfo/xymon<http://lists.xymon.com/mailman/listinfo/xymon>
>



-- 
If they give you ruled paper, write the other way. -Juan Ramon Jimenez,
poet, Nobel Prize in literature (1881-1958)

Truth never damages a cause that is just. -Mohandas Karamchand Gandhi
(1869-1948)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20120111/4729107d/attachment.html>