Using SQL to query ADSM
Suppose you want to know what nodes have files on a particular volume?
- SELECT DISTINCT NODE_NAME FROM CONTENTS WHERE VOLUME_NAME=‘G:\ADSM\SERVER\DATA1.DSM’
Suppose you want to know what nodes have what filespaces on a particular volume?
- SELECT DISTINCT NODE_NAME, FILESPACE_NAME FROM CONTENTS WHERE VOLUME_NAME=‘G:\ADSM\SERVER\DATA1.DSM’
How about for all volumes?
- SELECT DISTINCT VOLUME_NAME, NODE_NAME, FILESPACE_NAME FROM CONTENTS ORDER BY VOLUME_NAME, NODE_NAME, FILESPACE_NAME