Thanks Thomas! -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Thomas Denier Sent: Tuesday, November 29, 2011 2:36 PM To: [email protected] Subject: Re: [ADSM-L] List of Nodes and Space Requirements
-----Craig Ballenger wrote: ----- >How do I generate a list of TDPO nodes and their space usage in TSM? select node_name,sum(logical_mb) from occupancy where node_name in (select distinct node_name from filespaces where filespace_type='API:ORACLE') group by node_name If you have copy pools, this query will count both primary pool space and copy pool space. You can avoid this by adding: stgpool_name='<your pool name here>' to the selection criteria for occupancy table records. Thomas Denier
