Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Aug 2012
    Posts
    69
    Thanks
    24
    Thanked 0 Times in 0 Posts

    Default Duration of last night's backups

    Hi all,

    I'm wondering if someone out there can assist.

    I'd like to run a query which shows me to total duration of all backups that ran last night.

    something that would show:

    Total Schedules: Total Backup Size Total Backup Duration


    I'm using EMC's DPA and surprised that it doesn't have this feature (or, i just can't find it.)

    So, doing this via script would be nice.

  2. #2
    Member
    Join Date
    May 2006
    Posts
    198
    Thanks
    3
    Thanked 6 Times in 5 Posts

    Default

    You might want to check out http://www.lascon.co.uk/tsm-sql-queries.php for some good examples. I have found that site very helpful for getting info out of TSM.

    -Rowl

  3. #3
    Member
    Join Date
    Dec 2011
    Location
    USA
    Posts
    82
    Thanks
    5
    Thanked 3 Times in 3 Posts

    Default

    Use this to get total backup size:

    SELECT activity, cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as "GB" FROM summary WHERE activity<>'TAPEMOUNT' AND activity<>'EXPIRATION' AND end_time>current_timestamp-24 hours GROUP BY activity

  4. The Following User Says Thank You to BrianV For This Useful Post:

    redplumptomato (10-26-2012)

  5. #4
    Member
    Join Date
    Aug 2012
    Posts
    69
    Thanks
    24
    Thanked 0 Times in 0 Posts

    Default

    Excellent!!

Similar Threads

  1. duration=No
    By Jcage in forum Backup / Archive Discussion
    Replies: 14
    Last Post: 04-28-2011, 12:45 PM
  2. Know The Duration Of Many Backups/Archives
    By JohnnyK in forum TSM Server
    Replies: 1
    Last Post: 04-22-2011, 01:53 PM
  3. Is it possible to restrict duration of remote site backups?
    By bedac in forum Backup / Archive Discussion
    Replies: 3
    Last Post: 02-23-2011, 04:28 AM
  4. I had all of my backups fail the other night
    By theconqueror in forum Backup / Archive Discussion
    Replies: 5
    Last Post: 08-06-2008, 04:56 PM
  5. Replies: 2
    Last Post: 02-15-2005, 04:20 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •