Did you try to use group by nodes.contact? I tried you command (only without section > filespace_name like '%\c$' < - it didn't work)
select substr(nodes.contact,1,1) as SERVERTYP,sum (filespaces.capacity),sum (filespaces.capacity*pct_util/100) from nodes,filespaces where nodes.node_name=filespaces.node_name group by nodes.contact gives this report SERVERTYP: Unnamed[2]: 20024.3 Unnamed[3]: 16880.92 Is it OK? Hope this helps Tom -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@;VM.MARIST.EDU]On Behalf Of Stefan Holzwarth Sent: Thursday, October 24, 2002 2:19 PM To: [EMAIL PROTECTED] Subject: Group by problem for Storagereports Hello, i tried to realize some storage reports about out NT servers with the following select: select substr(nodes.contact,1,1) as SERVERTYP ,sum (filespaces.capacity), - sum (filespaces.capacity*pct_util/100) from nodes,filespaces where filespace_name like '%\c$' and nodes.node_name=filespaces.node_name group by SERVERTYP But: === ANR2940E The reference 'SERVERTYP' is an unknown SQL column name. | ......................................................V........ c$' and nodes.node_name=filespaces.node_name group by SERVERTYP Any ideas who to group by the first letter of the description? (I use the first letter for asigning the Server to some goups like mail, application, file,.....) Kind regards, Stefan Holzwarth ---------------------------------------------------------------------------- -- Stefan Holzwarth ADAC e.V. (Informationsverarbeitung - Systemtechnik - Basisdienste) Am Westpark 8, 81373 M|nchen, Tel.: (089) 7676-5212, Fax: (089) 76768924 mailto:stefan.holzwarth@;adac.de
