Author: "Coats, Jack" <Jack.Coats AT BANKSTERLING DOT COM>
Date: Thu, 12 Aug 2004 06:11:36 -0500
Is there a query or SQL query I could run to get me that can tell me, on a per client basis, how long the backup took from the servers perspective for each backup that ran in the last 24 hours? TIA .
The easy way is to meke sql query: select * from summary You can see the columns and make additional filtering or grouping ot what you need Regards, Svetoslav Tolev "Coats, Jack" <Jack.Coats AT BANKS
Hi, This seemed very usefull, but I don't find all backup clients in this table. Only some of the client machines show in the entity field. Any reason for this? Thanks, Geert "ADSM: Dist Stor Manager
See innumerable past postings about the Summary Table and reliability. The missing clients are probably 5.1, which had problems in this area. The Events table and TSM accounting data have proved mor
Author: "Coats, Jack" <Jack.Coats AT BANKSTERLING DOT COM>
Date: Thu, 12 Aug 2004 09:57:27 -0500
Thanks to all who replied. ... Sofar I have Select Entity,Start_Time,Stop_time,successful from summary - where activity='BACKUP' order by entity But I am having problems getting into the where clause
Author: Curtis Stewart <Curtis.Stewart AT LAWSON DOT COM>
Date: Thu, 12 Aug 2004 10:13:42 -0500
Try " and (start_time between current_timestamp - 24 hours and current_timestamp)" curtis.stewart AT lawson DOT com "Coats, Jack" <Jack.Coats AT BANKSTERLING DOT COM> Sent by: "ADSM: Dist Stor Manage