ADSM-L

[ADSM-L] select statement

2008-08-28 15:36:48
Subject: [ADSM-L] select statement
From: Avy Wong <AWong AT MOHEGANSUN DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 28 Aug 2008 15:35:55 -0400
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>