Here is a query to get all volumes used by 1 node :
select distinct -
cast(volumeusage.volume_name as char(6)) as Volume, -
cast(volumes.est_capacity_mb as decimal(6,0)) as "Capacity",-
cast(volumes.pct_utilized as decimal(4,1)) as "% used", -
cast(volumes.status as char(7)) as Status, -
cast(volumes.access as char(6)) as Access, -
date(volumes.last_write_date) as "Last write" -
from volumeusage,volumes -
where volumeusage.node_name=upper('$1') and -
volumeusage.stgpool_name='STG_LTODXN_CL' and -
volumeusage.volume_name=volumes.volume_name -
order by 1
Change your storage pool name accordingly.
Guillaume Gilbert
Backup Administrator
CGI - ITM
(514) 415-3000 x5091
guillaume.gilbert AT cgi DOT com
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]
> On Behalf Of tsmadmin account for Excaliber Business Solutions
> Sent: Thursday, January 08, 2004 7:23 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: SQL Query within TSM
> Importance: High
>
>
> Hi Guys
>
> Would like to know if anyone has seen or wriiten a SQL Query
> in TSM to get info relating
> to what management class, node name, cart/tape, how much of
> data for each node has been backed up.
> The info much be joined together for each node within TSM.
> I require for example :
>
> nodename=TEST
> management class = TEST
> number of carts or which carts test data is stored on
> how much of data test node has stored in TSM.
>
> If anyone could help please advise.
>
> Thks
> Sean
>
>
> "This e-mail is sent on the Terms and Conditions that can be
> accessed by Clicking on this link
> http://www.vodacom.net/legal/email.asp "
>
|