ADSM-L

[ADSM-L] Syntax of select statement

2010-02-12 10:37:22
Subject: [ADSM-L] Syntax of select statement
From: "Moyer, Joni M" <joni.moyer AT HIGHMARK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 12 Feb 2010 10:36:22 -0500
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.

<Prev in Thread] Current Thread [Next in Thread>