Maybe something like:

select entity as node_name, date(start_time) as date, cast(activity as -
varchar(10)) as activity, time(start_time) as start, time(end_time) as
end, -
cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as -
decimal(7,0)) as files, successful -
        from summary -
      where date(start_time)> date(current_timestamp - 1 day) -
      and (entity like 'HM%' or entity like 'GEO%') -
      order by successful

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 01/18/2005
10:33:11:

> Hello All!
>
> I have been trying, what seems like forever, to get this select
statement
> to work and I am just not sure what I am doing wrong... Any suggestions?
 I
> am trying to get a list of the backups of all of the servers that begin
> with hm* and geo* within the past 24 hours and if they were successful,
> missed or failed.  Thank you in advance!  Here is what I have so far,
but
> it doesn't seem to work:
>
> select entity as node_name, date(start_time) as date, cast(activity as
> varchar(10)) as activity, time(start_time) as start, time(end_time) as
end,
> cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as
> decimal(7,0)) as files, successful
>         from summary
>       where date(start_time) > current_timestamp - 1 day
>       and entity like 'hm*,geo*'
>        group by entity
>       order by successful
>
> ********************************
> Joni Moyer
> Highmark
> Storage Systems
> Work:(717)302-6603
> Fax:(717)302-5974
> joni.moyer AT highmark DOT com
> ********************************