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.moyer AT highmark DOT 
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.moyer AT highmark DOT 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.
>