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: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154 > -----Original Message----- > From: Seay, Paul [mailto:[EMAIL 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. > > 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:
