Using SQL to query ADSM
adsm> select colname, typename, remarks from columns where tabname='CONTENTS'
------------------ ------------------ ------------------
VOLUME_NAME VARCHAR Volume Name
NODE_NAME VARCHAR Node Name
FILESPACE_NAME VARCHAR Filespace Name
FILE_NAME VARCHAR Client's Name for
AGGREGATED VARCHAR Aggregated?
FILE_SIZE DECIMAL Stored Size
SEGMENT VARCHAR Segment Number
CACHED VARCHAR Cached Copy?