ADSM-L
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

[ADSM-L] issue with sql syntax in TSM database

2010-03-16 13:16:30
Subject: [ADSM-L] issue with sql syntax in TSM database
From: yoda woya <yodawoya AT GMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 16 Mar 2010 13:15:21 -0400 
I am trying to run this sql and cannot get a result

select date(start_time),  sum(bytes)

        from
        summary

                where
                ACTIVITY = 'BACKUP'
                or ACTIVITY = 'RESTORE'

                group by date(start_time)


any reasons why??
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  Re: [ADSM-L] Collocation Groups Reclamation and Restore, Michael Green
Next by Date:  [ADSM-L] AIX Restore Question, Melton, Tom
Previous by Thread:  [ADSM-L] TSM Client 6.1.3.2 for AIX, Grigori Solonovitch
Next by Thread:  Re: [ADSM-L] issue with sql syntax in TSM database, Richard Sims
Indexes:  [Date] [Thread] [Top] [All Lists]