Auditocc = select node_name, sum(physical_mb) from occupancy group by
node_name
occupancy = select * from occupancy where ......
= select node_ame, filespace_name, sum(physical_mb) from occupancy
group by node_name, filespace_name
Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail
-----Original Message-----
From: Coats, Jack [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 3:04 PM
To: [EMAIL PROTECTED]
Subject: SQL to do q auditoccupancy?
Someone have a guess as to how to do an SQL query to mostly duplicate the
"query auditoccupancy" command or even "query occupancy"?
... TIA ... JC
