Re: Query report
2001-08-07 10:49:59
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!
|
|
|