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/
