I use follow script:

set sqlmathmode round

set sqldatetimeformat eur

select -

  cast(entity as varchar(10)) as "Node", -

  cast(sum(affected) as varchar(10)) as "Affected", -

  cast(sum(failed) as varchar(10)) as "Failed", -

  case -

    when sum(bytes) \> 1073741824 then -

       cast(sum(bytes)/1073741824 as varchar(24))||' Gb' -

    when sum(bytes) \> 1048576 then -

       cast(sum(bytes)/1048576 as varchar(24))||' Mb' -

    when sum(bytes) \> 1024 then -

       cast(sum(bytes)/1024 as varchar(24))||' Kb' -

    else cast(sum(bytes) as varchar(24)) -

  end as "Num Bytes" -

  from summary -

  where activity='BACKUP' and -

    cast((current_timestamp - start_time) days as decimal) <= 30 -

  group by entity

Maxim Batourine
Faculty of Architecture, Landscape, and Design
University of Toronto
E-mail: maxim.batourine AT utoronto DOT ca
Tel: 416-978-0701



Maxim Batourine
Faculty of Architecture, Landscape, and Design
University of Toronto
E-mail: maxim.batourine AT utoronto DOT ca
Tel: 416-978-0701



> -----Original Message-----
> From: Toni Banire [mailto:Toni.T.Banire AT GSK DOT COM]
> Sent: Thursday, December 06, 2001 2:41 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: total monthly backups
>
>
> Need help on this one
>
> Is there a way to extract a list of total backups over a
> monthly period.
>
> I currently have this SQL statement
>
> SELECT start_time, end_time, entity, bytes from summary where
> activity ='BACKUP' and end_time between 'start_date' and 'end_date'
>
> To get a list of backups run, I just total all entity values.
> The snag here is that if a TSM client has it
> resourceutilisation set to >1 I will get duplicate listings
> for any day during the backup period as it will list objects
> processed on each client and not  just the client.
>
> Does anyone know if there is a better way to do this to get a
> list of total monthly backups by client and not object.
>
>
>
> TIA
>
>
> Toni
>