1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Duration of last night's backups

Discussion in 'Scripting' started by redplumptomato, Oct 4, 2012.

  1. redplumptomato

    redplumptomato New Member

    Joined:
    Aug 21, 2012
    Messages:
    69
    Likes Received:
    0
    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.  
  3. rowl

    rowl Member

    Joined:
    May 18, 2006
    Messages:
    219
    Likes Received:
    8
  4. BrianV

    BrianV New Member

    Joined:
    Dec 13, 2011
    Messages:
    83
    Likes Received:
    3
    Location:
    USA
    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
     
    redplumptomato likes this.
  5. redplumptomato

    redplumptomato New Member

    Joined:
    Aug 21, 2012
    Messages:
    69
    Likes Received:
    0
    Excellent!!
     

Share This Page