On Jun 13, 2005, at 10:03 AM, Joni Moyer wrote:

...Here is what I have run successfully:
select distinct volume_name,node_name from volumeusage where
node_name='NAS_SERVER_2_OFFSITE'  order by volume_name,node_name

As soon as I place "and filespace_name='/root_vdm_4/*' within it it
shows
no tapes

Refer to SQL conventions for "wildcards", as on p.302 of the TSM 5.1
Technical Guide redbook and other references. You're trying to use OS
wildcards in another context. In SQL, you need to use the LIKE clause
and percent signs.

  Richard Sims