tureem
ADSM.ORG Member
Is there a way to list amount of data stored pr node? My pools keep growing and i need to find out what nodes that takes all the space.
Roar
Roar
-
-
Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
Question
- Thread starter tureem
- Start date
rkampmann
ADSM.ORG Member
Hi,
QUERY AUDITOCCUPANCY (Query Client Node Storage Utilization)
Use this command to display information about client node server storage
utilization. To display current license audit information from the server, use
the AUDIT LICENSE command prior to issuing the QUERY AUDITOCCUPANCY command.
(copied from output of HELP QUERY AUDITOCCUPANCY)
Bye R.
QUERY AUDITOCCUPANCY (Query Client Node Storage Utilization)
Use this command to display information about client node server storage
utilization. To display current license audit information from the server, use
the AUDIT LICENSE command prior to issuing the QUERY AUDITOCCUPANCY command.
(copied from output of HELP QUERY AUDITOCCUPANCY)
Bye R.
damien
ADSM.ORG Member
or,, you could use a select statement,
select node_name, sum(logical_mb) as DATA_IN_MB, sum(num_files) as NUM_OF_FILES
from occupancy group by node_name having min(num_files) >= 1 order by data_in_mb desc
/damien
select node_name, sum(logical_mb) as DATA_IN_MB, sum(num_files) as NUM_OF_FILES
from occupancy group by node_name having min(num_files) >= 1 order by data_in_mb desc
/damien
