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
