If you are interested in the scheduled backups, try the server command
"set accounting on".  Each backup will create 1 line which contains the
information available in the activity log.  Unfortunately, API backups are
not recorded.  Also, this won't give the totals you are looking for.  Also
look at "query auditoccupancy".

On Wed, 19 May 1999, Richard C. Dempsey wrote:

> For planning purposes, it would be useful to examine the
> distribution of Number of Files, and Megabytes stored by
> backup date and active/inactive status.  Any ideas on how
> to get this with an efficient SELECT query that won't hang
> my ADSM server?
>
> Thanks,
> Rich
>
> Richard C. Dempsey                 email: dempsey AT kodak DOT com
> Public Online Services             pager: 716-975-3539
> 11th Floor, Bldg 83, RL            phone: 716-477-3457
> Eastman Kodak Company              fax:   716-722-3885
> Rochester, NY 14650-2203
>