TSM select for total data transferred by node and date

[Spidzior]

I've been trying to crack that one up for the past hour, but I give up.

I need to create a report for customer with total data transferred in November for all their nodes.

Thank in advance for any help.

 

[LED888]

Not sure if this is what you are looking for.

NOTE: Need to adjust the start and stop time for the time frame that you need.

- TSM version 6.X
SERVER1> SELECT CAST(FLOAT(SUM(bytes))/1024/1024/1024 AS DEC(8,2)) AS "Backed up data in GB" FROm summary WHERE activity='ARCHIVE' AND start_time >{'2007-06-01 00:00:00'} AND start_time <{'2007-07-01 00:00:00'}

- TSM version 5.X
SERVER1> SELECT CAST(FLOAT(SUM(bytes))/1024/1024/1024 AS DEC(8,2)) AS "Backed up data in GB" FROm summary WHERE activity='BACKUP' AND start_time >{ts '2007-06-01 00:00:00'} AND start_time <{ts '2007-07-01 00:00:00'}

Example of out put:

Backed up data in GB
--------------------
38829.70

Good Luck,
Sias

 

[marclant]

Plenty of other good examples here too: http://thobias.org/tsm/sql/