ADSM-L

Re: Select Question

2005-09-24 18:40:54
Subject: Re: Select Question
From: TSM_User <tsm_user AT YAHOO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Sat, 24 Sep 2005 15:40:26 -0700
Note that the table is also key'd by node_name so if you pass 
node_name='NODE_NAME' then you will get the information back much more quickly. 
If you want it for every node then be prepared for that select to run a very 
long time. Also in adition to the backups table you might also want to look at 
the archives table (select distinct node_name,class_name from archives).
 
Last, you only need to put the table name in front of the field name when your 
select is on more than one table.
 
K

William Jean <wjean AT GLASSHOUSE DOT COM> wrote:
This should work

select distinct backups.node_name, backups.class_name from backups

Here are the rest of the columns from backups

BACKUPS.BACKUP_DATE
BACKUPS.CLASS_NAME
BACKUPS.DEACTIVATE_DATE
BACKUPS.FILESPACE_ID
BACKUPS.FILESPACE_NAME
BACKUPS.HL_NAME
BACKUPS.LL_NAME
BACKUPS.NODE_NAME
BACKUPS.OBJECT_ID
BACKUPS.OWNER
BACKUPS.STATE
BACKUPS.TYPE

________________________________

From: ADSM: Dist Stor Manager on behalf of Spearman, Wayne
Sent: Thu 9/22/05 12:40 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Select Question




I'm trying to see what Clients are using what management classes. For
instance, server1 is using management class 1week and 1year. I can't
seem to find the right tables or selects. Any help would be appreciated.

Wayne




-----------------------------------------
This message and any included attachments are from NOVANT HEALTH INC.
and are intended only for the addressee(s). The information contained
herein may include trade secrets or privileged or otherwise
confidential information. Unauthorized review, forwarding, printing,
copying, distributing, or using such information is strictly prohibited
and may be unlawful. If you received this message in error, or have
reason to believe you are not authorized to receive it, please promptly
delete this message and notify the sender by e-mail.
If you believe that any information contained in this message is
disparaging or harassing on the basis of gender, race, age, disability,
religion, or national origin, please contact Novant Health, Inc. at 1
-888-378-8250 or 1-800-350-0094 or forward the e-mail to
reports AT novanthealth DOT org.
Thank you.


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

<Prev in Thread] Current Thread [Next in Thread>