Is this what you are looking for?
q auditoccup = select node_name,backup_mb,archive_mb, spacemg_mb,total_mb
from auditocc
q occup= select
node_name,type,filespace_name,stgpool_name,num_files,physical_mb,logical_mb
from occupancy
Sung Y. Lee
E-mail [EMAIL PROTECTED]
Alex Paschal
<AlexPaschal@FREIGH To: [EMAIL PROTECTED]
TLINER.COM> cc:
Sent by: "ADSM: Subject: Re: SQL to do q
auditoccupancy?
Dist Stor Manager"
<[EMAIL PROTECTED]
DU>
05/01/2002 05:14 PM
Please respond to
"ADSM: Dist Stor
Manager"
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
