Re: Select Statement: The ANSWER (GROUP BY)

You're the man Paul.

This has helped me discover that it looks like upgrading the client is NOT
the answer. I've cut out the crap so you can see just the numbers. This is
from this morning, and as I see it, more than half of the nodes I've got are
not in this report. A very large number of those nodes were upgraded to
5.1.5.4 over the weekend. I also see that some of the older clients with
"SAME LEVEL" software report properly and some not.

Has anyone else run this yet?

MBYTES     CONNECTIONS     Level
------------     -----------     --------
54563.38               1     5.1.5.4
18579.98               1     5.1.5.4
1139.31               1     5.1.5.4
879.92               1     4.2.1.15
634.93               1     4.1.2.12
606.88               1     4.1.2.12
470.70               1     4.2.1.32
294.23               1     4.2.1.20
253.10               1     4.2.1.15
241.28               1     4.2.1.20
232.93               1     4.2.1.15
192.74               1     4.2.1.15
168.54               1     4.2.1.15
167.73               1     4.2.1.15
164.49               1     4.1.2.12
156.05               1     4.2.1.32
151.87               1     4.2.1.20
145.41               1     5.1.1.0
145.39               1     4.2.0.0
144.12               1     4.2.1.15
141.51               1     4.2.1.15
23.77               1     4.1.2.12
0.00               1     4.2.1.32
0.00               1     4.1.2.12
0.00               1     4.1.2.0
0.00               1     4.1.2.12
0.00               1     4.1.2.12
0.00               1     4.2.1.20
0.00               1     4.2.1.32
0.00               1     4.2.1.20
0.00               1     5.1.1.3
0.00               1     4.1.2.12
0.00               1     4.1.2.12
0.00               1     4.2.1.32
0.00               1     4.1.2.12
0.00               1     4.1.2.12
0.00               1     4.1.2.12
0.00               1     4.1.1.16
0.00               1     4.2.1.32
0.00               1     4.2.1.32
0.00               1     4.2.1.20
0.00               1     4.2.1.32
0.00               1     4.1.1.16
0.00               1     4.2.1.15
0.00               1     4.2.1.15
0.00               1     4.2.1.32

Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   gillg AT saic DOT com
Phone:  (858) 826-4062
Pager:   (877) 905-7154



> -----Original Message-----
> From: Seay, Paul [mailto:seay_pd AT NAPTHEON DOT COM]
> Sent: Tuesday, December 17, 2002 1:12 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: FW: Select Statement: The ANSWER (GROUP BY)
>
>
> This was what I finally provided to the person asking the question.
>
> Try this as a define script input through the browser.
>
> select summary.entity as "NODE NAME", nodes.domain_name as
> "DOMAIN", nodes.platform_name as "PLATFORM",
> cast((cast(sum(summary.bytes) as float) / 1024 / 1024) as
> decimal(10,2)) as MBYTES , count(*) as "CONNECTIONS", cast
> (client_version as char(1)) || '.' || cast (client_release as
> char(1)) || '.' || cast (client_level as char(1)) || '.' ||
> trim(cast(client_sublevel as char(2))) as "Level" from
> summary ,nodes where summary.entity=nodes.node_name and
> summary.activity='BACKUP' and start_time>current_timestamp -
> 1 day group by entity, domain_name, platform_name,
> client_version, client_release, client_level, client_sublevel
> order by MBytes desc
>
> Make sure when you paste it in the window that you take all
> the returns out. There should be only one line when you get done.
>
> It worked for me.
>
> If you do a q script f=d this is what you will see if it is right: