Hey Everyone,
I've been trying to get the proper output of archived data for a particular
node, but I keep getting hung up on the archive_date parameter and was
wondering if anyone could help out?
I am trying to get information on all archived data for the following:
node_name=fjsu101
owner=appb2b
filespace_id=11
Between the dates of 05/01/2009 & 05/02/2009
I was trying: select * from archives where node_name='FJSU101' and
owner='appb2b' and filespace_id=11 and date(archive_date) > 04/31/2009 as a
starting point, but I'm still having no luck. Any suggestions are greatly
appreciated!!!!
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.
|