Check the occupancy table for the node, look for type of "Arch", or something like that. I'm not at a console right now or I'd know the exact values...
Curtis Stewart Systems Engineer StorageTek [EMAIL PROTECTED] -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Stefan Holzwarth Sent: Monday, August 08, 2005 9:31 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Select for archive size Hi *SM-ers, some time ago i setup a dedicated TSM node for archiving of all kind of data from different users. Each archive is generated with an (internal) unique ID in the description field under the same "archive-node". Sometimes the different archives come from the same filespace because we use a central networkshare for collection of files to archive. Now our users should pay for their archives. So i started searching for an select statement that gives me the size of an single archive (as in the gui when you estimate retrieve size). The problem is that the archives table shows no size information and the dsmc.exe has no estimate retrieve for automation... Any ideas? Kind regards Stefan Holzwarth