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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Whitlock, Brett
Sent: Thursday, August 03, 2006 5:09 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] primary and copy storage pool comparisons


query occupancy 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Tim Brown
Sent: Thursday, August 03, 2006 12:19 PM
To: ADSM-L AT VM.MARIST DOT 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: tbrown AT cenhud DOT com
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/
--------------------------------------------------------