Not sure if this is the correct thread or subject.
I need help with gathering info using sql statement.
Node name: ve_vcenter001
Filespace: *****old 'any name ending with old
below is what I have but it is not working.
I need help with gathering info using sql statement.
Node name: ve_vcenter001
Filespace: *****old 'any name ending with old
below is what I have but it is not working.
select filespaces.node_name,filespaces.filespace_name from filespaces,occupancy where filespaces.filespace_name like '%old' and occupancy.node_name=ve_vcenter001 > /tmp/oldorphan.txt