gw-userdb-size.bat
Generated on Tue Dec 05 17:44:03 Eastern Standard Time 2006 from gw-userdb-size.bat
@echo off
title GW-USERDB-SIZE: Look for large User DBs, send an alert to gwmon@sobac.com
echo (large message DB indicates runaway rule)
echo Date : 15 February 2005
echo Author : Bob Jonkman [bjonkman@sobac.com]
echo.
:begin
rem Threshold in MiBytes
set THRESHOLD=1000
echo Threshold=%THRESHOLD% MiBytes
rem DATE variable must be in a filename compatible format! eg. no slashes, use dashes instead (yyyy-mm-dd)
set outputfile=gw-userdb-size-%date%.csv
echo Output file is "%outputfile%"
echo Gathering sizes...
set AGENT=COTADM
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\cotadm.example.com\mail\cotadm\ofuser\*.db >> %AGENT%.poadir
set AGENT=CNS01
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\cns01.example.com\cns01\cns01\ofuser\*.db >> %AGENT%.poadir
set AGENT=CNS02
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\cns02.example.com\cns02\cns02\ofuser\*.db >> %AGENT%.poadir
set AGENT=CNS03
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\cns03.example.com\cns03\cns03\ofuser\*.db >> %AGENT%.poadir
set AGENT=CNS04
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\cns04.example.com\cns04\CNS04\ofuser\*.db >> %AGENT%.poadir
set AGENT=CNS05
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\cns05.example.com\cns05\cns05\ofuser\*.db >> %AGENT%.poadir
set AGENT=EDC01
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\edc01.example.com\edc01\edc01\ofuser\*.db >> %AGENT%.poadir
set AGENT=EDC02
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\edc02.example.com\edc02\edc02\ofuser\*.db >> %AGENT%.poadir
set AGENT=UPD01
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\upd01.example.com\uds01\upd01\ofuser\*.db >> %AGENT%.poadir
set AGENT=UPD02
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\upd02.example.com\uds02\upd02\ofuser\*.db >> %AGENT%.poadir
set AGENT=GWP01
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\gwp01.example.com\gwp01\gwp01\ofuser\*.db >> %AGENT%.poadir
set AGENT=GWP02
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\gwp02.example.com\gwp02\gwp02\ofuser\*.db >> %AGENT%.poadir
set AGENT=GWP03
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\gwp03.example.com\gwp03\gwp03\ofuser\*.db >> %AGENT%.poadir
set AGENT=WES01
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\wes01.example.com\wes01\wes01\ofuser\*.db >> %AGENT%.poadir
set AGENT=WES02
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\wes02.example.com\wes02\wes02\ofuser\*.db >> %AGENT%.poadir
set AGENT=WES03
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\wes03.example.com\wes03\wes03\ofuser\*.db >> %AGENT%.poadir
set AGENT=WES04
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\wes04.example.com\wes04\wes04\ofuser\*.db >> %AGENT%.poadir
set AGENT=WES05
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\wes05.example.com\wes05\wes05\ofuser\*.db >> %AGENT%.poadir
set AGENT=CNL01
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\cnl01.example.com\cnl01\CNL01\ofuser\*.db >> %AGENT%.poadir
set AGENT=COR01
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\cor01.example.com\cor01\cor01\ofuser\*.db >> %AGENT%.poadir
set AGENT=COR02
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\cor02.example.com\cor02\cor02\ofuser\*.db >> %AGENT%.poadir
set AGENT=COR03
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\cor03.example.com\cor03\cor03\ofuser\*.db >> %AGENT%.poadir
set AGENT=COR04
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\cor04.example.com\cor04\cor04\ofuser\*.db >> %AGENT%.poadir
set AGENT=FIN01
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\fin01.example.com\fin01\FIN01\ofuser\*.db >> %AGENT%.poadir
set AGENT=EXP01
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\exp01.example.com\cotexp01\exp01\ofuser\*.db >> %AGENT%.poadir
set AGENT=CNL02
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\cnl02.example.com\cnl01\cnl02\ofuser\*.db >> %AGENT%.poadir
set AGENT=TRAIN01
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.poadir
dir /-c \\train01.example.com\mail\train01\ofuser\*.db >> %AGENT%.poadir
echo Create list of USER.DB sizes
gawk -f gw-userdb-size.awk -v THRESHOLD=%THRESHOLD% *.poadir > %outputfile%
echo Create Web page of MSG.DB sizes...
gawk -f csv2html.awk -f library.awk -v TITLE="GW User DB sizes %DATE% %TIME%" %outputfile% > gw-userdb-size.html
rem We're currently not doing alerts on UserDBs
goto HTMLPublish
rem Make sure old alerts are deleted
if exist msgalrt.101 del msgalrt.101
echo Check for alert...
gawk -f alert.awk -f library.awk -v THRESHOLD=%THRESHOLD% -v COMP=GT -v FIELDNUM=4 -v TO=gwmon@w01431.corp.example.com -v SUBJECT="GWAlert: USER.DB exceeds %THRESHOLD% MiBytes" -v ALERTFILE=msgalrt.101 %outputfile%
echo Append Domain Free Space information...
set AGENT=COTPRI
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.mtadir
dir /-c \\cotpri.example.com\mail>> %AGENT%.mtadir
set AGENT=COTGATE
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.mtadir
dir /-c \\cotgate.example.com\mail>> %AGENT%.mtadir
set AGENT=COTWEB
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.mtadir
dir /-c \\cotweb.example.com\mail>> %AGENT%.mtadir
set AGENT=COTSEC1
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.mtadir
dir /-c \\cotsec1.example.com\mail>> %AGENT%.mtadir
set AGENT=COTSEC2
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.mtadir
dir /-c \\cotsec2.example.com\mail>> %AGENT%.mtadir
set AGENT=COTSEC3
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.mtadir
dir /-c \\cotsec3.example.com\mail>> %AGENT%.mtadir
set AGENT=RestoreServer
echo Agent= %AGENT%
echo Agent= %AGENT% > %AGENT%.mtadir
dir /-c \\cotgw600.corp.example.com\mail >> %AGENT%.mtadir
Echo Parse free space information...
gawk -f gwmon-freespace.awk *.???dir > gwmon-freespace.csv
echo Create Free Space Web page...
gawk -f csv2html.awk -f library.awk -v TITLE="GW Server Free Disk Space %DATE% %TIME%" gwmon-freespace.csv > gwmon-freespace.html
:HTMLPublish
echo Publish Web pages...
copy *.html \\cotgw506\sys\apache2\htdocs\stats\
rem ##### DEBUG ##### Suspended Freespace alerts --Bob Jonkman, 17 August 2005
goto end
rem Clean up previous alert
if exist freealrt.101 del freealrt.101
echo Create Free Space alert...
gawk -f alert.awk -f library.awk -v THRESHOLD=%FREESPACE% -v COMP=LT -v TO=gwmon@w01431.corp.example.com -v ALERTFILE=freealrt.101 gwmon-freespace.csv
echo Send Alerts...
if exist *.101 copy *.101 c:\mercury\queue
rem Clean up alerts
if exist *.101 del *.101
:end
rem EOF: gw-userdb-size.BAT
1 files processed.