You could try,

select node_name, sum(physical_mb), as DATA_IN_MB, sum(num_files) from
occupancy group by node_name order by node_name


Brian Johnson
Merrill Lynch

212-647 3557

> -----Original Message-----
> From: Richard Sims [SMTP:rbs AT BU DOT EDU]
> Sent: Wednesday, September 20, 2000 12:16 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: Another ADSM capacity question
>
> >How do I find out the total storage used by a node
>
> Do 'Audit License', then 'Query Auditoccupancy'.
> Break down with 'Query Occupancy'.
>   Richard Sims, BU