ADSM-L

Re: SQL Query within TSM

2004-01-08 09:15:13
Subject: Re: SQL Query within TSM
From: Guillaume Gilbert <guillaume.gilbert AT CGI DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 8 Jan 2004 09:12:34 -0500
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 "
>

<Prev in Thread] Current Thread [Next in Thread>
  • SQL Query within TSM, tsmadmin account for Excaliber Business Solutions
    • Re: SQL Query within TSM, Guillaume Gilbert <=