Hi, Unless I misunderstand your question you are asking for three separate lists so I think the only way to do it is using three sql queries.
Something like this perhaps: select node_name from nodes select node_name - as "Node name", - filespace_name as "File space name", - sum(physical_mb) as "MB's" - from occupancy - group by node_name,filespace_name select node_name - as "Node name", - sum(physical_mb) as "MB's" - from occupancy - group by node_name Please note that these queries will list *all* your nodes. Depending on how many nodes you have registered the resulting lists may be quit long. And also note that the amount of data reported is the sum of all data on all storage pools for that node/filespace, including copy pools. You may or may not want this. We usually prefer to know only the amount of data that is stored in the primary pools because we use that number for creating invoices. I hope this helps. Kind regards, Alexander ------------------------------------------------------------ Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing & Networking Services > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of Joni Moyer > Sent: donderdag 2 september 2004 13:55 > To: [EMAIL PROTECTED] > Subject: select statement - filespaces > > > Hello all! > > I was just wondering if there is any way to list each node, each > filespace/node, size & amount used and then total each > individual node's > size (space used only). Is such a select statement > possible? Thanks! > > ******************************** > Joni Moyer > Highmark > Storage Systems > Work:(717)302-6603 > Fax:(717)302-5974 > [EMAIL PROTECTED] > ******************************** >