Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Please be aware that ADSM.ORG will be going through forum software conversion and migration over the next several weeks. The cut-over date and time will be posted in the ADSM.ORG News & Announcements section as we near the target date. Please visit the following link for more details ADSM News & Announcements
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.
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