ADSM-L

Re: Query report

2001-08-07 10:49:59
Subject: Re: Query report
From: "Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>
Date: Tue, 7 Aug 2001 10:50:40 -0400
You'll have to work at it a bit, but you can get the backup start/end time
by:

select * from filespaces where nodename='BLAH'

You can get the files with errors by:

select * from actlog where msgno=4007 and nodename in ('BLAH1','BLAH2')

Of course instead of select *, you can select just the fields you want to
see.
It will take a little massaging, but the info is there.

I would be inclined to set up a scheduled script that dumped the previous 24
hours to a disk file each day for all clients, and let your users write
their own report!



<Prev in Thread] Current Thread [Next in Thread>