Using SQL to query ADSM
adsm> select distinct volume_name, node_name, filespace_name from contents order by volume_name, node_name, filespace_name
VOLUME_NAME NODE_NAME FILESPACE_NAME
------------------ ------------------ ------------------
G:\ADSM\SERVER\DA- ANDY JACKIE'S HD
G:\ADSM\SERVER\DA- ANDY SQLPROG
G:\ADSM\SERVER\DA- ANDY WINDOWS95B
G:\ADSM\SERVER\DA- MOCK DRIVE E
G:\ADSM\SERVER\DA- ANDY JACKIE'S HD
G:\ADSM\SERVER\DA- ANDY SQLPROG
G:\ADSM\SERVER\DA- ANDY WINDOWS95B
G:\ADSM\SERVER\DA- MOCK DRIVE E