SQL for sessions running during a specific time frame

[ebaracco]

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.

 

[tsm_dude]

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.

 

[dbias1601]

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