Craig McAllister wrote:

> Hi All,
>         I need to know how to calculate the number of objects held in the
> ADSM DB for each filespace, including all the inactive files, so I can give
> an estimate of the amount my DB has to be extended by.
>
>         Can anyone help?

You might try:

select node_name, filespace_name, count(*) as "Total Objects" from backups
group by node_name, filespace_name



--
Ray Schafer                   | schafer AT tkg DOT com
Ray Schafer                   | schafer AT tkg DOT com
The Kernel Group              | Network Computing Consulting