ADSM-L

AW: Group by problem for Storagereports

2002-10-24 11:14:21
Subject: AW: Group by problem for Storagereports
From: Stefan Holzwarth <stefan.holzwarth AT ADAC DOT DE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 24 Oct 2002 17:13:14 +0200
Group by nodes.contact works, but
groups by the whole string not the first letter.
Regards,
Stefan Holzwarth


-----Ursprüngliche Nachricht-----
Von: Tomás Hrouda [mailto:throuda AT HTD DOT CZ]
Gesendet: Donnerstag, 24. Oktober 2002 16:12
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: Group by problem for Storagereports


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 AT VM.MARIST DOT EDU]On Behalf Of
Stefan Holzwarth
Sent: Thursday, October 24, 2002 2:19 PM
To: ADSM-L AT VM.MARIST DOT EDU
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 AT adac DOT de

<Prev in Thread] Current Thread [Next in Thread>