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.
select -
char(o.node_name,16) as "Node", -
char(o.stgpool_name,12) as "Pool", -
char(s.devclass, 12) as "Devclass", -
cast(sum(o.physical_mb)/1024 as decimal(8,1)) as "GiB", -
sum(o.num_files) as "Files" -
from -
occupancy o -
join stgpools s on o.stgpool_name = s.stgpool_name -
where -
o.node_name like upper('$1') -
group by -
o.node_name, o.stgpool_name, s.devclass
select -
o.node_name, -
o.stgpool_name, -
devclass, -
sum(o.physical_mb)/1024 as "GiB", -
sum(o.num_files) as "Files" -
from -
occupancy o, -
stgpools -
where -
o.stgpool_name = stgpools.stgpool_name -
and o.node_name like upper('$1') -
group by -
o.node_name, o.stgpool_name, devclass
"C:\Program Files\Tivoli\TSM\baclient\dsmadmc.exe" -tab