select stgpool_name,sum(num_files) as total_files, sum(logical_mb)as total_logical_mb from occupancy group by stgpool_name
Regards, Rama -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Whitlock, Brett Sent: Thursday, August 03, 2006 5:09 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] primary and copy storage pool comparisons query occupancy -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tim Brown Sent: Thursday, August 03, 2006 12:19 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] primary and copy storage pool comparisons I thought once I used a command that would compare the primary and copy storage pools, showing whether or not they are in sync. Does anyone know of this or am I just mistaken. Tim Brown Systems Specialist Central Hudson Gas & Electric 284 South Ave Poughkeepsie, NY 12601 Email: [EMAIL PROTECTED] Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 -------------------------------------------------------- If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/ --------------------------------------------------------
