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
>
|