Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Feb 2007
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default SQL for sessions running during a specific time frame

    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. #2
    Senior Member
    Join Date
    Dec 2007
    Posts
    330
    Thanks
    1
    Thanked 19 Times in 19 Posts

    Default

    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.

  3. #3
    Member
    Join Date
    May 2012
    Posts
    32
    Thanks
    5
    Thanked 2 Times in 2 Posts

    Default

    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

Similar Threads

  1. Replies: 0
    Last Post: 08-22-2011, 08:39 AM
  2. Replies: 3
    Last Post: 03-07-2011, 03:27 PM
  3. SQL Query for client specific "point-in-time" data
    By kidquick10 in forum Scripting
    Replies: 2
    Last Post: 07-14-2008, 02:58 PM
  4. Need to query actlog from a specific time frame
    By PierCed_3 in forum TSM Reporting & Monitoring
    Replies: 16
    Last Post: 01-17-2008, 08:55 PM
  5. SQL query on specific file from specific node
    By rbowen in forum Scripting
    Replies: 2
    Last Post: 08-21-2006, 11:37 AM

Posting Permissions

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