Try this
select count(volume_name), vu.node_name from volume_usage vu, nodes n
where vu.node_name=n.node_name and copy_type='BACKUP' and stgpool_name
!= 'OFFSITEPPOOL' and n.domain_name='SYSSERV'
Regards
Steve Harris
Unemployed and Impoverished TSM Admin
Sydney Australia
Fred Johanson wrote:
Management would like to know how many tapes are being used by each
domain(=administrative unit). Logically, I think the query should look like
this:
select count(volume_name),node_name from volumeusage where copy_type='BACKUP'
and not stgpool_name='OFFSITEPOOL' and node_name in (select node_name from
domains where domain_name='SYSSERV')
But that produces this message
ANR2942E The column reference 'NODE_NAME' is not allowed in this context
because it is part of an outer SQL query expression.
Any thoughts?
Fred Johanson
TSM Administrator
University of Chicago
773-702-8464
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.423 / Virus Database: 270.14.38/2467 - Release Date: 10/29/09
07:38:00
