Yes, you and Alex came up with just what I needed. Is there somewhere the selects from the query commands are in the data base? ... Just learning SQL ... JC
> -----Original Message----- > From: Sung Y Lee [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, May 01, 2002 5:25 PM > To: [EMAIL PROTECTED] > Subject: Re: SQL to do q auditoccupancy? > > 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_m > b > 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
