Maybe you can use script:
select node_name as Node_Name, count(*) as File_Spaces, sum(physical_mb) as
Physical_MB, sum(logical_mb) as Logical_MB, sum(num_files) as Files from
occupancy where stgpool_name = upper('$1') group by node_name
with storage pool name as an argument or just replace $1 by storage pool name
Grigori Solonovitch, Senior Systems Architect, IT, Ahli United Bank Kuwait,
www.ahliunited.com.kw
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Robert
Ouzen
Sent: 03 01 2014 11:59 AM
To: [email protected]
Subject: [ADSM-L] Script for nodes
Hi to all
Did anyone have a script to see which nodes are on storage pools and can share
it.
For now I am running a query nodedata.
T.I.A Best Regards
Robert
Please consider the environment before printing this Email.
________________________________
CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail
message and any attachments hereto may be legally privileged and confidential.
The information is intended only for the recipient(s) named in this message. If
you are not the intended recipient you are notified that any use, disclosure,
copying or distribution is prohibited. If you have received this in error
please contact the sender and delete this message and any attachments from your
computer system. We do not guarantee that this message or any attachment to it
is secure or free from errors, computer viruses or other conditions that may
damage or interfere with data, hardware or software.
