AIL PROTECTED]]
> Sent: Tuesday, December 17, 2002 1:12 PM
> To: [EMAIL PROTECTED]
> 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.
>
&g
ease,
client_level,
client_sublevel order by MBytes desc Last
Update by (administrator): PDS00
Last Update Date/Time: 12/12/2002 17:14:57
Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180
-Original
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)) ||
'.'