ADSM-L

Re: looking for sql-script

1999-06-15 10:05:31
Subject: Re: looking for sql-script
From: Doug Thorneycroft <dthorneycroft AT LACSD DOT ORG>
Date: Tue, 15 Jun 1999 07:05:31 -0700
The account log is comma deliniated, and imports nicely into
a database product, where you can generate the report that you
need. Below is a sample of the report that I use.
_________________________________________________________________________________________
CS02       Date:    Time:       Normal:  Runtime:       Files backed        KB 
backed up:
           6/9/99   23:26         Yes       85.98            201              
1,939,444
           6/10/99  23:26         Yes       85.50            165              
1,834,320
           6/11/99  23:35         Yes       94.88            164              
1,863,850

CS06       Date:    Time:       Normal:  Runtime:       Files backed        KB 
backed up:
           6/8/99   23:12         Yes        1.95            283                
5,565
           6/9/99   23:12         Yes        2.05            381                
7,479
           6/10/99  23:12         Yes        1.83            342                
7,191
           6/11/99  23:14         Yes        3.47            2440               
16,216


Winfried Heilmann wrote:
>
> Hi,
>
> maybe someone can help me:
>
> I need a report with the following backup/archive-information:
>
> node_name
> schedule_name
> schedule_start (date/time)
> schedule_end (date/time)
> duration  (hh:mm)
> transferred bytes
> transferred files (if possible)
> status
>
> example:
>
> node1 sched1 06/15/99 03.00 06/15/99 03:33 00:33 1002022 12 failed
>
> Does anybody have a prepared select-script for this query. I think those infos
> are in the "actlog"- table.
>
> Thanks
>
> winfried
>
> winfried.heilmann AT infracor DOT de
<Prev in Thread] Current Thread [Next in Thread>