ADSM-L

Re: Q volume

2015-10-04 17:30:27
Subject: Re: Q volume
From: Richard Cowen [mailto:richard.cowen AT VTMEDNET DOT ORG]
To: ADSM-L AT VM.MARIST DOT EDU
>Hello Everyone,
>
>             I was wondering if there is a way to query volumes for a
>specific day.   I know you can do a q vol stgpool=? but is there any way
>that we can get it to display what tapes were used on a specific day.   Any
>suggestions would be greatly appreciated.
>

adsm> select volume_name from volumes where stgpool_name='TAPEPOOL'
and cast(last_write_date as date)='05/23/2000'

VOLUME_NAME
------------------
M01617
M01617
M01618
--
Richard
Richard
<Prev in Thread] Current Thread [Next in Thread>