Marc,
Don't think you can do this, including backup date.
I am posting a select which does the rest
/* Script Name: Q_TAPE_VOLS */
/* Description: Display the TAPES that */
/* relate to a specific node */
/* and filespace */
/* Parameter: node name filespace name */
/* and storage pool */
/* Example: run q_tape_vols test2 test2\data: tape2 */
select distinct volume_name,node_name,filespace_name from -
volumeusage where node_name = upper('$1') -
and filespace_name = upper('$2') -
and stgpool_name = upper('$3')
Marc Lowers <[EMAIL PROTECTED]> on 07/30/2002 05:00:29 PM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: John Naylor/HAV/SSE)
Subject: select statement using filespaces and tapes
I'm looking for a select statement which will provide me with a list of
tapes associated with a given node, filespace name and backup date. I've
been looking into linking the backups table with another to provide the
result but this has been unsuccessful so far.
Am I close or miles off with this method?
Marc.
**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.
Scottish Hydro-Electric, Southern Electric, SWALEC and S+S
are trading names of the Scottish and Southern Energy Group.
**********************************************************************
