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: [email protected] 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 [EMAIL PROTECTED] Thank you. ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
