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.