Data Protection Software

 View Only
  • 1.  Show TMS report in gigabytes rather than megabytes. 

    Posted Wed January 24, 2018 11:12 AM

    In TMS I run a daily report that shows how much data has been backedup. The results are shown in megabytes, but I would prefer the result to be in gigabytes. How do I make the change?



  • 2.  RE: Show TMS report in gigabytes rather than megabytes.

    Posted Sun February 04, 2018 09:16 PM

    Hello George,

    Can you please post the command, or script whatever you are using to get the result on MB. and moreover which version you are using as of now.

    Thanks

    Prem



  • 3.  RE: Show TMS report in gigabytes rather than megabytes.

    Posted Tue February 06, 2018 04:00 AM

    Hi, do you want select to return in Giga or Tera, are you using TSM what version?



  • 4.  RE: Show TMS report in gigabytes rather than megabytes.

    IBM Champion
    Posted Tue February 06, 2018 04:22 AM

    Hi,

    Try the following command to report on all activity in the last 24 hours, in GB.

    SELECT activity, cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as "GB" FROM summary WHERE activity<>'TAPE MOUNT' AND activity<>'EXPIRATION' AND start_time >{'2011-09-21 00:00:00'} AND start_time <{'2011-09-22 00:00:00'} GROUP BY activity

    Another option is to use Operations Centre, which can be configured to email you you a daily report in HTML format showing the daily ingest and a lot of other useful information.

    Regards

    Darren

     

    Darren Sanders

    Principal Consultant

    Celerity Ltd

    http://www.celerity-uk.com