VPN is where the problem lies Richard. Not sure why that would be but it is.
Internet in and of itself is terrible so could be just that I suppose. In any
case mail turns things upside down too so I was wondering if this was all one
query you sent.
select VOLUME_NAME, STGPOOL_NAME, LAST_WRITE_DATE from VOLUMES -
where VOLUME_NAME in -
(select distinct VOLUME_NAME from VOLUMEUSAGE where NODE_NAME='NODE1' -
and STGPOOL_NAME not like '%COPY%' and STGPOOL_NAME not like '%
OFFSITE%' )
________________________________
From: owner-adsm-l AT VM.MARIST DOT EDU on behalf of Richard Sims
Sent: Wed 8/15/2007 4:57 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: query help please
On Aug 15, 2007, at 4:44 AM, Gill, Geoffrey L. wrote:
> Hello everyone,
> I am still out of the country and can't connect to work so I need
> some help please. Here is what I'm looking for. I have te below
> query that returns a complete list of tapes a node has data on but
> I am looking for something that I might add to it that would narrow
> the search to tapes that were written between specific dates.
>
> I do have someone back at work who is backing me up that can run
> these queries to gather the info but I'm not able to help from
> China as my access seems to be blocked from here, not work. Just
> try reading about falun gong from here or tiananmen square and
> you'd invariably get "page cannot be displayed" before the search
> returns anything. If you do get a list 99% of what is returned is
> also blocked, while normal searches work just fine.
>
> Anyway, if anyone can help me so I can forward to her I sure would
> appreciate it.
>
> select distinct node_name,volume_name,stgpool_name from volumeusage
> where node_name='NODE1'
How about VPN access to your site from the Filter All Evil country?
That might work.
You can play with a Select based upon the following example, adding
timestamp range tests as desired...
select VOLUME_NAME, STGPOOL_NAME, LAST_WRITE_DATE from VOLUMES -
where VOLUME_NAME in -
(select distinct VOLUME_NAME from VOLUMEUSAGE where NODE_NAME='NODE1' -
and STGPOOL_NAME not like '%COPY%' and STGPOOL_NAME not like '%
OFFSITE%' )
Richard Sims http://people.bu.edu/rbs/
|
