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.

SQL for sessions running during a specific time frame

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

  1. ebaracco

    ebaracco New 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 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 New 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