Hi:
This was posted by someone previously:
select node_name, sum(logical_mb) as Data_In_MB, sum(num_files) as Num_of_files
from occupancy group by node_name order by node_name asc
>>> rwagner AT ZEUNASTAERKER DOT DE 05/15/00 05:19AM >>>
Folks,
anyone having a select which shows me the number of active files and the size of
these files
in MB of a certain node?
TIA
Reinhold Wagner, Zeuna Staerker GmbH & Co. KG
|