Try so (for TSM 5) for last 24 hours

select entity, activity, sum(bytes) as sum from summary where entity in
(select node_name from nodes) and cast((current_timestamp-end_time)hours
as decimal)<24 and activity in ('BACKUP','ARCHIVE','RESTORE','RETRIEVE')

Dmitry
http://www.s-iberia.com


group by activity, entity

On 12.10.2011 19:01, Lee, Gary D. wrote:

Could another approach be to check the actlog for ane4977i and ane4961i 
message, dividing the total in 4977 by total in 4961?

That gives you what you inspected divided by what you changed.

Actually reverse the two and you'll get a decimal easily converted to a 
percentage.

If I've missed something here, please let me know.


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310