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/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]
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@VM.MARIST.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
> [EMAIL PROTECTED]
> ********************************
