-
-
Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
How to find tape with a certain file
- Thread starter davas
- Start date
Sunhillow
ADSM.ORG Senior Member
Hello,
recently I needed a similar command to list all files from one tape. I modified it a bit, so it should do what you are looking for:
select volume_name, filespace_name, file_name, CAST((FILE_SIZE/1024/1024) As DECIMAL(7,2)) AS SIZE_MB, object_id, segment from contents where file_name = '$filename'
But be aware that CONTENTS may be a huge table!
The "segment" is important in case the file is spanned over two tapes
recently I needed a similar command to list all files from one tape. I modified it a bit, so it should do what you are looking for:
select volume_name, filespace_name, file_name, CAST((FILE_SIZE/1024/1024) As DECIMAL(7,2)) AS SIZE_MB, object_id, segment from contents where file_name = '$filename'
But be aware that CONTENTS may be a huge table!
The "segment" is important in case the file is spanned over two tapes
