Re: [hobbit] Trying to make graphs with bb-roracle.ksh 2.20

[<fredbo (at) club-internet.fr>]

ManyÂthanksÂRobert,ÂItÂworksÂ!Â

JustÂaÂdetailÂatÂtheÂendÂofÂtheÂscriptÂ:

####################
29ÂÂdone
ÂÂÂÂ30ÂÂ;;Â#ÂaddÂtwoÂsemi-colonÂhere
ÂÂÂÂ31
ÂÂÂÂ32ÂÂÂÂ*)ÂÂÂÂexitÂ0
ÂÂÂÂ33ÂÂÂÂÂÂÂÂÂÂ;;
ÂÂÂÂ34
ÂÂÂÂ35ÂÂesac
ÂÂÂÂ36ÂÂexitÂ0
ÂÂÂÂ37ÂÂ#endÂofÂextra-rrd.sh
####################


BestÂregards.

Fred.


Here'sÂwhatÂIÂdid:

InÂhobbitgraph.cfgÂaddÂtheseÂtwoÂstanzas:
[oradb]
ÂÂÂÂÂÂÂÂFNPATTERNÂoradb(.*).rrd
ÂÂÂÂÂÂÂÂTITLEÂOracleÂTablespaceÂUtilitzation
ÂÂÂÂÂÂÂÂYAXISÂ%ÂFull
ÂÂÂÂÂÂÂÂDEF:p (at) RRDIDX@= (at) RRDFN@:pct:AVERAGE
ÂÂÂÂÂÂÂÂLINE2:p (at) RRDIDX@# (at) COLOR@:@RRDPARAM@
ÂÂÂÂÂÂÂÂ-uÂ100
ÂÂÂÂÂÂÂÂ-lÂ0
ÂÂÂÂÂÂÂÂGPRINT:p (at) RRDIDX@:LAST:Â\:Â%5.1lfÂ(cur)
ÂÂÂÂÂÂÂÂGPRINT:p (at) RRDIDX@:MAX:Â\:Â%5.1lfÂ(max)
ÂÂÂÂÂÂÂÂGPRINT:p (at) RRDIDX@:MIN:Â\:Â%5.1lfÂ(min)
ÂÂÂÂÂÂÂÂGPRINT:p (at) RRDIDX@:AVERAGE:Â\:Â%5.1lfÂ(avg)\n
[oradb1]
ÂÂÂÂÂÂÂÂFNPATTERNÂoradb(.*).rrd
ÂÂÂÂÂÂÂÂTITLEÂOracleÂTablespaceÂUtilitzation
ÂÂÂÂÂÂÂÂYAXISÂUsed(MB)
ÂÂÂÂÂÂÂÂDEF:p (at) RRDIDX@= (at) RRDFN@:used:AVERAGE
ÂÂÂÂÂÂÂÂLINE2:p (at) RRDIDX@# (at) COLOR@:@RRDPARAM@
ÂÂÂÂÂÂÂÂ-lÂ0
ÂÂÂÂÂÂÂÂGPRINT:p (at) RRDIDX@:LAST:\:Â%5.1lfÂ(cur)
ÂÂÂÂÂÂÂÂGPRINT:p (at) RRDIDX@:MAX:\:Â%5.1lfÂ(max)
ÂÂÂÂÂÂÂÂGPRINT:p (at) RRDIDX@:MIN:\:Â%5.1lfÂ(min)
ÂÂÂÂÂÂÂÂGPRINT:p (at) RRDIDX@:AVERAGE:\:Â%5.1lfÂ(avg)\n

InÂhobbitserver.cfg:
ÂÂ-ÂAddÂoradbÂ(orÂwhateverÂyouÂbb-roracleÂreportsÂas)ÂtoÂtheÂTEST2RRDÂline
ÂÂ-ÂAddÂoradbÂandÂoradb1ÂtoÂtheÂGRAPHSÂline

InÂhobbitlaunch.cfg:
ÂÂ-ÂAddÂ"--extra-script=/home/hobbit/server/ext/extra_rrd.shÂ--extra-tests=oradb"ÂtoÂtheÂCMDÂlineÂinÂ[rrdstatus]Âstanza
ÂÂ-ÂAddÂ"--extra-script=/home/hobbit/server/ext/extra_rrd.shÂ--extra-tests=oradb"ÂtoÂtheÂCMDÂlineÂinÂ[rrdata]Âstanza

CreateÂ$BBHOME/server/ext/extra_rrd.shÂas:
#!/bin/bash

#ÂInputÂparameters:ÂHostname,ÂtestnameÂ(column),ÂandÂmessagefile
HOSTNAME="$1"
TESTNAME="$2"
FNAME="$3"

caseÂ$TESTNAMEÂin
ÂÂoradb)Â#Âoradb
ÂÂÂÂÂÂÂÂgrepÂ"ÂTablespaceÂ"Â$FNAMEÂ|ÂgrepÂ-vÂ"TablespaceÂcheckÂdisabled"Â|ÂwhileÂreadÂLINE
ÂÂÂÂÂÂÂÂdo
ÂÂÂÂÂÂÂÂÂÂTSNAME=`echoÂ$LINEÂ|ÂawkÂ'{printÂ$4}'`
ÂÂÂÂÂÂÂÂÂÂTSSIZE=`echoÂ$LINEÂ|ÂawkÂ'{printÂ$6}'Â|ÂcutÂ-f1Â-d"M"`
ÂÂÂÂÂÂÂÂÂÂ#TSPCTUSED=`echoÂ$LINEÂ|ÂawkÂ'{printÂ$9}'|cutÂ-f1Â-d"%"|cutÂ-f2Â-d">"`
ÂÂÂÂÂÂÂÂÂÂTSPCTUSED=`echoÂ$LINEÂ|ÂawkÂ'$2Â~Â/\&green/Â{printÂ$9};Â$2Â~Â/\&yellow/Â{printÂ$10};Â$2Â~/\&red/Â{printÂ$10}'Â|cutÂ-f1Â-d"%"|cutÂ-f2Â-d">"`
ÂÂÂÂÂÂÂÂÂÂTSUSED=`echoÂ$TSSIZEÂ$TSPCTUSEDÂ|ÂawkÂ'{printÂ$1*$2/100}'`

ÂÂÂÂÂÂÂÂÂÂ#ÂTheÂRRDÂdatasetÂdefinitions
ÂÂÂÂÂÂÂÂÂÂechoÂ"DS:pct:GAUGE:1200:0:100"ÂÂÂ#heartbeatÂ=Â1200Â(20Âminutes)ÂsinceÂbb-roracleÂrunsÂ10ÂminutesÂ--ÂSettingÂlowerÂcouldÂcauseÂgapsÂinÂgraphs
ÂÂÂÂÂÂÂÂÂÂechoÂ"DS:used:GAUGE:1200:0:U"ÂÂÂ#heartbeatÂ=Â1200Â(20Âminutes)ÂsinceÂbb-roracleÂrunsÂ10ÂminutesÂ--ÂSettingÂlowerÂcouldÂcauseÂgapsÂinÂgraphs

ÂÂÂÂÂÂÂÂÂÂ#ÂTheÂfilename
ÂÂÂÂÂÂÂÂÂÂechoÂ"oradb,${TSNAME}.rrd"

ÂÂÂÂÂÂÂÂÂÂechoÂ"$TSPCTUSED:$TSUSED"

ÂÂÂÂÂÂÂÂÂÂ#echoÂ"$TSNAMEÂpctused=$TSPCTUSED--Âused=$TSUSED--"Â>>Â/tmp/oradb.rrd.outÂÂ#debug/testingÂstatement
ÂÂÂÂÂÂÂÂdone

ÂÂ*)ÂÂÂÂexitÂ0
ÂÂÂÂÂÂÂÂ;;

esac
exitÂ0
#endÂofÂextra-rrd.sh

---------------

RobertÂHerronÂ--ÂtheÂ"R.Herron"ÂinÂbb-roracle.shÂrevisionÂhistory.