Well, for one thing, * is not a wildcard in a select statement, it's %, and you need LIKE, not =
where filespace_name LIKE '/root_vdm_4/HMCH1015_E%' On Fri, Feb 12, 2010 at 10:36 AM, Moyer, Joni M <joni.mo...@highmark.com>wrote: > Hello everyone, > > I would like to find all tapes that are within the storage pool TAPE_NDMP > that are associated with datamover NAS_SERVER_2_5YR and the filespace name > of /root_vdm_4/HMCH1015_E_bkup. I ran the following select statement, but > it is not returning any volumes. Any suggestions? Just let me know. > Thanks! > > select distinct volume_name,node_name,filespace_name from volumeusage where > filespace_name='/root_vdm_4/HMCH1015_E*' and stgpool_name='TAPE_NDMP' order > by volume_name > > Here is the contents of tape N02497 which shows the node name and filespace > name that I am looking for, but the above is not showing anything... > Node Name Type Filespace FSID Client's Name for File > Name > --------------- ---- ---------- ---- > -------------------------------------- > NAS_SERVER_2_5- Bkup /reposito- 85 /NAS/ IMAGE > YR ry_bkup > NAS_SERVER_2_5- Bkup /root_vdm- 88 /NAS/ IMAGE > YR _4/HMCH1- > 015_E_bk- > up > > Joni Moyer > Storage Administrator III > (717)302-9966 > joni.mo...@highmark.com > > > ________________________________ > This e-mail and any attachments to it are confidential and are intended > solely for use of the individual or entity to whom they are addressed. If > you have received this e-mail in error, please notify the sender immediately > and then delete it. If you are not the intended recipient, you must not > keep, use, disclose, copy or distribute this e-mail without the author's > prior permission. The views expressed in this e-mail message do not > necessarily represent the views of Highmark Inc., its subsidiaries, or > affiliates. >
