ADSM-L

Re: AW: Group by problem for Storagereports

2002-11-14 20:36:51
Subject: Re: AW: Group by problem for Storagereports
From: Zlatko Krastev <acit AT ATTGLOBAL DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 15 Nov 2002 02:43:20 +0200
Look at my reply on thread "SQL query - GROUP on derived value?" from 
25.09.2001.
There is a workaround.

Zlatko Krastev
IT Consultant






Stefan Holzwarth <stefan.holzwarth AT ADAC DOT DE>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
24.10.2002 18:13
Please respond to "ADSM: Dist Stor Manager"

 
        To:     ADSM-L AT VM.MARIST DOT EDU
        cc: 
        Subject:        AW: Group by problem for Storagereports


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>
  • Re: AW: Group by problem for Storagereports, Zlatko Krastev <=