Re: [ADSM-L] List of Nodes fr specific STG

Hi Steve



Great It's just what I needed ... This question is that tried to figure the 
difference about two output I got about occupancy of a STG with Dedup for TSm6 
on it.



·         Here the first script:

select  '_' as "Mark",  node_name , sum(logical_mb) as "Logical Occupancy" from 
occupancy  where node_name in  (select node_name from nodes where 
domain_name='DOFACULTIES') and stgpool_name in ('DEDUP6TSM') group by node_name 
order by 3



              Output:



Mark      NODE_NAME                                                             
 Logical Occupancy

-----     ------------------------------------------------------------------    
 ----------------------------------

_         WWW                                                                   
                           14844.80

_         EDU1                                                                  
                          582710.36

_         MAIL                                                                  
                          593474.80



·         Second script



/**** Run before  AUDIT LICENSES   ****/

select cast(n.node_name as varchar(16)) as "Nodename",  
cast(sum(occ.backup_mb)/1024  as varchar(16)) as "BACKUP_GB", 
cast(sum(occ.archive_mb)/1024 as varchar(16)) as "ARCHIVE_GB" ,

cast(n.TCP_ADDRESS as varchar(20)) as "TCPIP Address" , cast(n.CLIENT_VERSION 
as varchar(2)) as "Version" , cast(n.CLIENT_RELEASE as varchar(2)) as "Release" 
,cast(n.CLIENT_LEVEL as varchar(2)) as

"Level" , cast(n.CLIENT_SUBLEVEL as varchar(2)) as "Sublevel" , 
cast(n.platform_name as varchar(16)) as "Platform" from nodes n , auditocc occ 
where n.node_name=occ.node_name and contact='$1'

group by n.node_name , n.TCP_ADDRESS , n.PLATFORM_NAME , n.CLIENT_VERSION , 
n.CLIENT_RELEASE , n.CLIENT_LEVEL , n.CLIENT_SUBLEVEL order by 1





Output:



Nodename              BACKUP_GB             ARCHIVE_GB            TCPIP Address 
            Version      Release      Level      Sublevel      Platform

-----------------     -----------------             -----------------        
---------------------             --------         --------        ------       
 ---------     -----------------

EDU1                               895                                    0     
                132.XX.XX.XX                                6                 4 
                  0                7             Linux x86-64

MAIL                               800                                    0     
                132.XX.XX.XX                                6                 4 
                  0                7             Linux x86-64

WWW                               14                                    0       
              132.XX.XX.XX                                6                 4   
                0                7             Linux x86-64



I tried to understand the difference ????



Best Regards Robert



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Steven Harris
Sent: Friday, July 05, 2013 11:33 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] List of Nodes fr specific STG



Hi Robert



That is an easy one



select distinct node_name from volumeusage where 
stgpool_name='Your_storage_pool'



Regards



Steve



Steven Harris

TSM Admin

Canberra Australia



On 5/07/2013 6:14 PM, Robert Ouzen wrote:

> Hi to

>

> I tried to figure a way to known the current nodes on a specific STG pool 
> name. I search about a script to do the job  maybe.

>

> Any ideas ?

>

> Best regards

>