Hi *SM-ers!
My management would like to know how much they can save by changing our 
retention periods.
Currently, we store most of our backups for 14 days and I will have to find out 
how much we save by changing this to 7 days.
I'm trying to create a SQL statement to retrieve this information. It seems 
that the backups table does contain information about a backup being active or 
inactive, but it does not contain the file size.
Can anybody help me with creating a SQL statement which tells me how much 
inactive backup data is stored on the TSM server for a specific node?
Thank you VERY much in advance for your help!!!!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


**********************************************************************
For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), 
its subsidiaries and/or its employees shall not be liable for the incorrect or 
incomplete transmission of this e-mail or any attachments, nor responsible for 
any delay in receipt.
**********************************************************************