[ADSM-L] select statement
2008-08-28 15:36:48
Hello,
The following is a select statement to provide "a total data stored
and tapes used per node in all storage pools".
I have broken down the sql and double checked the tables and column names
are all there. Can anyone see where the hangs ups are?
select vu.node_name, ao.total_mb, count(distinct vu.volume_name) as tapes,
ao.total_mb/count(distinct vu.volume_name) as "AVG MB/tape" from
volumeusage vu, auditocc ao where vu.node_name=ao.node_name group by
vu.node_name, ao.total_mb order by 4
ANR2956E Unable to access SQL base table 'VOLUMEUSAGE'.
|
..........................V....................................
me) as "AVG MB/tape" from volumeusage vu, auditocc ao where vu.
ANS8001I Return code 26.
thanks,
Avy Wong
Business Continuity Administrator
Mohegan Sun
1 Mohegan Sun Blvd
Uncasville, CT 06382
(860)862-8164
(cell) (860)961-6976
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [ADSM-L] select statement,
Avy Wong <=
|
|
|