You need to load the 5.1.5 client and the 5.1.5.2 patch. With it the summary data does not get transferred from the client to the server.
Mahesh >>> [EMAIL PROTECTED] 12/10/02 08:30PM >>> As it turns out the clients also have to be updated to correct a problem where the summary table statistics are missing. I talked to a TSM Level 2 person about this just last week. I do not know what levels you have to be at to get the problem corrected, but I thought 5.1.5 was good enough. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -----Original Message----- From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 5:16 PM To: [EMAIL PROTECTED] Subject: Select Statement I got this somewhere and I know it used to work on my 4x server. Now that I'm on 5.1.5.2 I get a lot of nodes report back with 0 Megabytes but they obviously sent files. Anyone who can make it work since my SQL stills are pretty much non existant? /*--------------------------------------------*/ /* Specify a date on the run line as follows */ /* run q_backup 2001-09-30 */ /*--------------------------------------------*/ select entity as node_name, date(start_time) as date, - cast(activity as varchar(10)) as activity, time(start_time)as start, - time(end_time) as end, cast(bytes/1000000 as decimal(6,0))as megabytes, - cast(affected as decimal(7,0)) as files, successful from summary - where date(start_time)='$1' and activity='BACKUP' order by megabytes desc NODE_NAME: NODEA DATE: 2002-12-09 ACTIVITY: BACKUP START: 20:00:51 END: 20:48:07 MEGABYTES: 0 FILES: 100 SUCCESSFUL: YES This one does the same thing with some nodes. It also only reports about half the nodes even though it looks like it's supposed to be going back a full day. NODEA NT_DOM WinNT 0.00 1 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 "CONECTIONS" 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 order by MBytes desc A better one would also work. Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
