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 <[EMAIL PROTECTED]> 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: [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 ______________________________________________________________________ __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
