Hi Don,

I don't know about HSM, is this what you want?

Select volume_name,node_name,filespace_name,file_name, file_size from
contents where filespace_name='FILENAME_FS_NAME' and
file_name='FILNAME_TO_FIND_OUT'

Phillip Guan