ADSM-L

Re: Q volume

2000-05-24 13:45:08
Subject: Re: Q volume
From: Richard Cowen <richard.cowen AT VTMEDNET DOT ORG>
Date: Wed, 24 May 2000 13:45:08 -0400
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>