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.

SQL for sessions running during a specific time frame

Discussion in 'Scripting' started by ebaracco, May 23, 2013.

  1. ebaracco

    ebaracco ADSM.ORG Member

    Joined:
    Feb 6, 2007
    Messages:
    5
    Likes Received:
    0
    I need a select statement that can give me a list of sessios (output should look like q sess) but for a specific date and time range. i.e.: today between 9:00am and 10:00am.
     
  2.  
  3. tsm_dude

    tsm_dude ADSM.ORG Senior Member

    Joined:
    Dec 12, 2007
    Messages:
    334
    Likes Received:
    21
    Use TSM ORT or another reporting tool such as TSM manager. The sessions information will no longer be in the sessions table, so you could query the summary table also.
     
  4. dbias1601

    dbias1601 ADSM.ORG Member

    Joined:
    May 29, 2012
    Messages:
    32
    Likes Received:
    2
    Something like this?

    select entity,activity,bytes,successful from summary where start_time>=current_timestamp-7 hour and end_time<current_timestamp-6 hour and activity in ('ARCHIVE','BACKUP','RESTORE') order by entity
     

Share This Page