Troy, I don't know much about sql either but you could get that information by doing a query occupancy for the node. That would give you all of the data stored for that node and then use a export node filedata=allactive preview=yes to determine how much of the data is active. Jim Sporer
At 09:57 AM 9/7/2004 -0500, you wrote:
What I would like to have is two (hopefully) simple scripts. Both would take a node name as a parameter. One script would return the total amount of active data being held by TSM for that node. The other would return total inactive data for that node. If it could be condensed into one script that would output both pieces of info, all the better. Unfortunately, an SQL scripter I am not.
Confidentiality Notice follows:
The information in this message (and the documents attached to it, if any) is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken, or omitted to be taken in reliance on it is prohibited and may be unlawful. If you have received this message in error, please delete all electronic copies of this message (and the documents attached to it, if any), destroy any hard copies you may have created and notify me immediately by replying to this email. Thank you.
