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 [EMAIL PROTECTED] 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.
