Re: Select Statement: The ANSWER (GROUP BY)

2002-12-19 Thread Gill, Geoffrey L.
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

FW: Select Statement: The ANSWER (GROUP BY)

2002-12-19 Thread Seay, Paul
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

Re: Select Statement: The ANSWER

2002-12-11 Thread Seay, Paul
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)) || '.'