Ricky,

The current tsm sql engine doesn't have enough columns to give you the
answer you are looking for.  I suggest this alternate procedure;

1. Do a 'q occ nodename', add up the files and space used values for the 
primary pools.
2. Do an export command with preview=yes - 'exp nodename filed=backupa p=y'.
This will tell you how many active files there are and the space they take up.
3. Do the math between #1 and #2.

Hope this helps,

Bill

At 03:20 AM 7/4/2003, you wrote:
>Does anyone have a script that would tell me how many extra versions (we
>currently have up to 14) exists on a node and how much space they are taking
>up??
>
>The library is beggining to creak at the seems a little (STKL180) buying a
>new one isn't an option so I'm trying to find ways to cut back whats stored,
>I'm hopeing with the above info I can convince the business to lower the
>amount of copies held per file.
>
>Thanks in advance
>
>                ..........Rikk
>
>
>****************************************************************************************************
>Equitas Limited, 33 St Mary Axe, London EC3A 8LL, UK
>NOTICE: This message is intended only for use by the named addressee
>and may contain privileged and/or confidential information.  If you are
>not the named addressee you should not disseminate, copy or take any
>action in reliance on it.  If you have received this message in error
>please notify postmaster AT equitas.co DOT uk and delete the message and any
>attachments accompanying it immediately.
>
>Equitas reserve the right to monitor and/or record emails, (including the
>contents thereof) sent and received via its network for any lawful business
>purpose to the extent permitted by applicable law
>
>Registered in England: Registered no. 3173352 Registered address above
>****************************************************************************************************

----------
Bill Colwell
C. S. Draper Lab
Cambridge Ma.