This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_000_01C074DA.5CA42E10
Content-Type: text/plain;
charset="iso-8859-1"
Here is the .xbpmonrc_sears (sears being one of my masters).
You use this as follows:
/usr/openv/netbackup/bin/admincmd/bpdbjobs -report -format ~/.xbpmonrc_sears.
I plan to (in my spare time :-)) set it up to use the -all_columns report.
That give you a comma delimited list with much, much more information.
Try the bpdbjobs with such a format file and then
/usr/openv/netbackup/bin/admincmd/bpdbjobs -report -all_columns.
If you decide to pursue this, then you might want to start with the all_columns
stuff instead. What I have been able to figure out from the all_columns report
is attached.
Kelly
-------------
WINDOW MAIN 1
{
REFRESHRATE 0 10
"MASTER SERVER" "sears"
JOBWINDOWS 0 5
"JOB LIST" 327
WIDTH 919
}
LIST JOBS 1
{
1 1 6 1 0 1 -1 0 ""
2 2 8 1 0 4 1 0 ""
3 3 5 1 0 2 1 0 ""
4 4 6 1 0 3 -1 0 ""
5 15 5 1 0 5 1 0 ""
6 5 8 1 0 6 1 0 ""
7 6 6 1 0 7 1 0 ""
8 7 6 1 0 0 1 0 ""
9 8 7 1 0 0 1 0 ""
10 9 7 1 0 0 1 0 ""
11 10 5 1 0 0 1 0 ""
12 11 7 1 0 0 1 0 ""
13 16 3 1 0 0 1 0 ""
14 0 9 1 0 0 1 0 ""
15 12 7 1 0 0 1 0 ""
16 13 5 1 0 0 1 0 ""
17 0 32 2 0 0 1 0 ""
18 0 11 1 0 0 1 0 ""
19 14 7 1 0 0 1 0 ""
20 0 5 1 0 0 1 0 ""
}
--
Kelly Wyatt, Kelly.Wyatt AT SAS DOT com
Senior Systems Programmer
Strategic Recovery
SAS Institute Inc. / SAS Campus Drive / Cary, NC 27513
http://www.sas.com
SAS... The Power to Know
-----Original Message-----
From: Richard C Bond [mailto:rbond AT mbt.washington DOT edu]
Sent: Friday, December 22, 2000 12:42 PM
To: [ISS] Veritas-Users
Subject: RE: [Veritas-bu] Advanced Reporter
Hmm- could you share the details ( format etc )
rcb
On Fri, 22 Dec 2000, [ISS] Veritas-Users wrote:
> We do a bpdbjobs with a specific format file, throw it through a perl job to
> create a comma delimited list and then read it into SAS. We have all backup
> data since May, 1999. This has been helpful for trend analysis. We also
> have web reports we run against this data. I want to look at the NBAR to see
> what if does that we don't or can't do with our stuff to see if it is worth
> scrapping our stuff and using NBAR. In the mean time, this works well for us.
>
> If you have SAS this works well. If you don't, then I know where you can get
> it :-).
>
> Kelly
>
> P.S. To respond to me directly, send email to Kelly.Wyatt AT SAS DOT com.
> The "from email" address for this post is a folder, not a valid user.
>
> --
>
> Kelly Wyatt, Kelly.Wyatt AT SAS DOT com
> Senior Systems Programmer
> Strategic Recovery
> SAS Institute Inc. / SAS Campus Drive / Cary, NC 27513
> http://www.sas.com
> SAS... The Power to Know
>
> -----Original Message-----
> From: Jewell, Jason T [mailto:jj151001 AT exchange.DAYTONOH.NCR DOT com]
> Sent: Thursday, December 21, 2000 8:49 AM
> To: Veritas-bu (E-mail)
> Subject: RE: [Veritas-bu] Advanced Reporter
>
>
> When we make reports and web pages we just get the information from the flat
> files NBU gives us in /usr/openv/netbackup/db/jobs ,
> /usr/openv/netbackup/db/jobs/done and in /usr/openv/netbackup/db/error on
> each of our master servers. For example, we have a cron job that kicks off
> every few hours to build html pages for jobs based on the files in the above
> directories, these pages are then accessible to our users through an
> HTML/JavaScript front end on our intranet. We dump (ftp) these files into a
> central location, so that each master server and its clients are accessible
> from the same front end. So I guess we have done "something like this" but
> not exactly what you want, I think.
>
> As for Advanced Reporter, we also are curious about any advice. This tool
> has proved to be finicky for us.
>
> Jason Jewell
> NCR 1611 Main ST
> Dayton OH 45479
> 937-445-4173
> http://www.ncr.com
>
> > -----Original Message-----
> > From: Dean, James [SMTP:jimmy.dean AT usi DOT net]
> > Sent: Wednesday, December 20, 2000 8:20 PM
> > To: Veritas-bu (E-mail)
> > Subject: [Veritas-bu] Advanced Reporter
> >
> > Does anyone have in-depth knowledge into advanced reporter, that would be
> > able to give me some insight as to the type of database that it is running
> > if any. I am looking to tape into the Adv. Reporter for a client care web
> > page. I am a little tired of answering the question "Did my server back
> > up
> > last night?"
> >
> > I do have a web page that does some of this on a server by server basis,
> > but
> > what I am really looking to do is dump 5 different master servers logs and
> > image information into a consolidated database and query from there.
> >
> > Has anyone done something like this that could suggest even just the
> > database structure that you might have used.
> >
> > Thanks,
> > James Dean
> > USi
> > _______________________________________________
> > Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
> > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> _______________________________________________
> Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> _______________________________________________
> Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>
--
-
Richard Bond (rbond AT mbt.washington DOT edu (206) 605-3561
System Administrator K-351, Health Sciences Center
Department of Molecular Biotechnology Box 357730
University of Washington Seattle, WA 98195
------_=_NextPart_000_01C074DA.5CA42E10
Content-Type: text/plain;
name="all_columns.txt"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="all_columns.txt"
jobid 305 8
=0A=
jobtype 0 8=0A=
state 3 8=0A=
status 1 8=0A=
class austin.unix $22=0A=
schedule full $10=0A=
client aussrv01 $22=0A=
server ausback.unx $20=0A=
started 0950916985 8=0A=
elapsed 0000011093 8=0A=
ended 0950928078 8=0A=
stunit austin-1.pc $20=0A=
try 1 8=0A=
operation <blank>=0A=
kbytes 21022930 8=0A=
files 416421 8=0A=
pathlastwritten <blank>=0A=
percent <blank>=0A=
jobpid 12944 8=0A=
owner root $8=0A=
subtype 1 8=0A=
classtype 0 8=0A=
scheduletype 0 8=0A=
priority 0 8=0A=
group <blank>=0A=
masterserver ausback $20=0A=
retention units 3 8=0A=
retentionperiod 2 8=0A=
compression 0 8=0A=
kbyteslastwritt 0 8=0A=
fileslastwritt 0 8=0A=
filelistcount 1 8=0A=
files ALL_LOCAL_DRIVES $50=0A=
trycount 1 8=0A=
trypid 12944 8=0A=
trystunit austin-1.pc $20=0A=
tryserver ausback.unx $20=0A=
trystarted 950916985 8=0A=
tryelapsed 11093 8=0A=
tryended 950928078 8=0A=
trystatus 1 8=0A=
trystatusdesc the requested operation was partially successful $80=0A=
trystatuscount 28 8=0A=
trystatuslines 02/18/00 18:36:31 - mounting AU0050 $80=0A=
02/18/00 18:36:32 - connecting $80=0A=
02/18/00 18:36:33 - connected; connect time: 000:00:01 $80=0A=
02/18/00 19:17:36 - mounted; mount time: 000:41:05 $80=0A=
02/18/00 19:17:36 - positioning to file 1 $80=0A=
=09
02/18/00 19:18:02 - positioned; position time: 000:00:26$80=0A=
=09
02/18/00 19:18:02 - begin writing =0A=
=09
02/18/00 19:32:14 - positioning to file 2=0A=
=09
02/18/00 19:32:14 - positioned; position time: 000:00:00=0A=
02/18/00 19:41:45 - positioning to file 3=0A=
02/18/00 19:41:45 - positioned; position time: 000:00:00=0A=
02/18/00 19:52:12 - positioning to file 4=0A=
02/18/00 19:52:12 - positioned; position time: 000:00:00=0A=
02/18/00 20:01:46 - positioning to file 5=0A=
02/18/00 20:01:46 - positioned; position time: 000:00:00=0A=
02/18/00 20:10:10 - positioning to file 6=0A=
02/18/00 20:10:10 - positioned; position time: 000:00:00=0A=
02/18/00 20:18:48 - positioning to file 7=0A=
02/18/00 20:18:48 - positioned; position time: 000:00:00=0A=
02/18/00 20:32:53 - positioning to file 8=0A=
02/18/00 20:32:53 - positioned; position time: 000:00:00=0A=
02/18/00 20:47:59 - positioning to file 9=0A=
02/18/00 20:47:59 - positioned; position time: 000:00:00=0A=
02/18/00 21:03:58 - positioning to file 10=0A=
02/18/00 21:03:58 - positioned; position time: 000:00:00=0A=
02/18/00 21:23:42 - positioning to file 11=0A=
02/18/00 21:23:42 - positioned; position time: 000:00:00=0A=
02/18/00 21:41:03 - end writing; write time: 002:23:01=0A=
trybyteswritten 21022930 8=0A=
tryfileswritten 416421 8=0A=
------_=_NextPart_000_01C074DA.5CA42E10--
|