1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above 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 notice will disappear after you have made at least 3 posts.

Duration of last night's backups

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

  1. redplumptomato

    redplumptomato ADSM.ORG 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 ADSM.ORG Senior Member

    Joined:
    May 18, 2006
    Messages:
    223
    Likes Received:
    9
  4. BrianV

    BrianV ADSM.ORG 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 ADSM.ORG Member

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

Share This Page