Here is what you will need select distinct node_name,volume_name,stgpool_name from volumeusage where node_name='xxxxx'