TSM Server Migration Report

[girreis]

Dear friends,

I wonder how elaborate a SELECT the SUMMARY table to list me as bytes (GB) the migration of a particular filepool process was migrated, and also the time spent (time start and end).

Thank you,
Ramon

 

[marclant]

The info you are looking for is in the summary table. Try this query: http://thobias.org/tsm/sql/#toc85

 

[girreis]

Thanks but I tried and I could not!

Help me?

 

[moon-buddy]

Thanks but I tried and I could not!

Help me?

How did you enter the command? A copy and paste should work.

 

[girreis]

SELECT activity, start_time, end_time, bytes (in GB), ENTITY FROM summary WHERE end_time between '2014-12-16 00:00:00.000000' and '2014-12-17 23:59:59.000000' and ACTIVITY='MIGRATION' and ENTITY='FILEPOOL1'

 

[moon-buddy]

Your syntax is wrong - no start_time

Follow the link marclant gave.