>So, I have to figure a way to do the reporting by my self, and it is very
>easy to query the mediadb for backups, failed and succeded, but how about
>missed scheduled backups ? My guess is that I would have to query the job
>db, but how to do that ?
That's the problem. Networker does not keep track of missing backup.
Host may be down or network problem may prevent backups, no record
is filled in media db indicating the error.
So, no track of "missing/failed" backup.
The trick I did in Networker reporter's backup quality control
is to maintain a config file with static or dynamic rules
and compare with mminfo results.
Rules contain expected level and copies on a weekly Cycle.
For sample :
client_a;S;/DB_/;Skip;Full;Full;Full;Full;Full;Full;0;2;2;2;2;2;2;
reading as :
backups from Client_a, any savesets starting with /DB_
must have schedule Skip-Full-Full-Full-Full-Full-Full
and to be cloned (2 copies) excepted Sunday.
Depending your needs, you may customize it by
replacing S ... for Saveset Staring with <string>
C ... for Saveset Containing <string>
F ... for Saveset Finishing by <string>
E ... for Saveset exact Matching <string>
for your saveset string matching.
You can even use s or S for case sensitivity
Then, load that in a memory array and call mminfo,
requesting client,saveset,copies,level and sscreate(22) fields
Then, rest is just string compare :-)
- wrong level
- missing backup
- missing copies
Perl is rather easy to do that and depending the way
you coded it (file access), your code may be portable from
Windows to Unix (Networker Reporter code is now more
than 200K line and portable on Unix/Windows without changing
a byte to code.)
HTH
Th
Kind regards - Bien cordialement - Vriendelijke groeten,
Thierry FAIDHERBE
Backup/Storage & System Management
LE FOREM - Administration Centrale
Département des Systèmes d'Information
Boulevard Tirou, 104 Tel: + 32 (0)71/206730
B-6000 CHARLEROI Fax: + 32 (0)71/206199
BELGIUM Mail : Thierry.faidherbe<at>forem.be
----- Original Message -----
From: EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU <NETWORKER AT LISTSERV.TEMPLE DOT EDU>
Sent: Wed Nov 25 23:20:11 2009
Subject: [Networker] Reporting on missing scheduled backup
Hi all.
I am a big fan of Networker Reporting Tool, but in an environment with
approx. 600 clients, hourly backup and a need for reporting the last 6
weeks, it has has sadly shown to be too "small", at least in a Windows
environment.
When starting the Networker Reporting Tool I have noticed that it starts
consumig memory until it reaches 2 GB, and then it crashes, this apply for
both older and the newest version on both 32 and 64 bit servers.
So, I have to figure a way to do the reporting by my self, and it is very
easy to query the mediadb for backups, failed and succeded, but how about
missed scheduled backups ? My guess is that I would have to query the job
db, but how to do that ?
There has to be a way, since the Networker Reporting Tools does an execelent
job !
Bye the way, does anybody have any experience with IDATATools for Networker
? It looks very promissing from what I have read so far.
Any hint or adwise are very welcome :-)
Ole Hermansen
No virus found in this outgoing message.
Checked by AVG - www.avg.com
Version: 9.0.709 / Virus Database: 270.14.82/2525 - Release Date: 11/25/09
08:31:00
To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
|
