ADSM-L

Re: Select Question

2005-09-22 13:15:10
Subject: Re: Select Question
From: William Jean <wjean AT GLASSHOUSE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 22 Sep 2005 13:11:11 -0400
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
______________________________________________________________________

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