Help with select

Hi,

I need some help with this. I would like to have the following output on a
select from backup table on Domino trans.logs.

NODENAME       ACTIVE_VERSION INACTIVE_VERSION
Node 1         120            62
Node2          80             99


select NODE_NAME,FILESPACE_NAME,STATE,CLASS_NAME,
TYPE,HL_NAME,LL_NAME,OBJECT_ID,BACKUP_DATE, DEACTIVATE_DATE from backups
where node_name='STO-W24-TDP' and filespace_name='STO-LNS01.DOMLOGS'

NODE_NAME    FILESPACE_NAME     STATE           CLASS_NAME       TYPE
HL_NAME         LL_NAME       OBJECT_ID  BACKUP_DATE      DEACTIVATE_DATE
STO-W24-TDP  STO-LNS01.DOMLOGS  ACTIVE_VERSION    DAILY_TDP_CLASS  FILE
\0E9479006B6D25C1   S0004683.TXN  182853209        2004-11-10

          10:00:49.000000
STO-W24-TDP  STO-LNS01.DOMLOGS  ACTIVE_VERSION    DAILY_TDP_CLASS  FILE
\0E9479006B6D25C1   S0004684.TXN  182853210        2004-11-10

                    10:00:55.000000
STO-W24-TDP  STO-LNS01.DOMLOGS  INACTIVE_VERSION  DAILY_TDP_CLASS  FILE
\0E9479006B6D25C1  S0004137.TXN  178918122    2004-10-06
2004-10-18

                         11:00:45.000000      04:05:05.000000
STO-W24-TDP  STO-LNS01.DOMLOGS  INACTIVE_VERSION  DAILY_TDP_CLASS  FILE
\0E9479006B6D25C1 S0004138.TXN  178918123     2004-10-06
2004-10-18

                          11:00:51.000000     04:05:05.000000



I got this select but it doesnt work. I wonder what I need to add etc?!?!
Select    Node_name,
          sum(ant_act),
          sum(ant_inact)
from
   (Select Node_name
                  CASE when state = 'ACTIVE_VERSION'    then 1 else 0 END
   ant_act ,
                  CASE when state = 'INACTIVE_VERSION' then 1 else 0 END
   ant_inact
   from  backups ) t1
group by Node_name ;


Anyway, the reason why I want this is that I have seen that incremental
backup on two of our Domino servers fails to start when Domisch.log gets
corrupted, (I have a PMR about this).
Usually I dont read log files on a day to day basis... and it took me some
time before I realized I had a problem and found a workaround.
The two system expired 60 000 trans. log which brought back some tapes...



TIA
Henrik



















-------------------------------------------------------------------
The information contained in this message may be CONFIDENTIAL and is
intended for the addressee only. Any unauthorised use, dissemination of the
information or copying of this message is prohibited. If you are not the
addressee, please notify the sender immediately by return e-mail and delete
this message.
Thank you.