Hi Matt I hope I can help with this. It doesn't seem straightforward but one way could be...; select number as sessid,cast(start_time as TIME)as Start,cast(end_time as TIME)as End from summary where activity='BACKUP' AND cast(start_time as DATE)='2002-10-15'
This will give you all backup sessions and their start/end time for the date 10/15/2002, but not those that started, say 23:55 the 14th, end ended on the 15th. You might want to put additional checks on this to get all sessions between a start and end-time on two following days. Now, you would have to count the sessions according to start/end-times. I'm sure someone on the list can find a more precise way to count concurrent sessions within a time period. Rgds. Geirr G. Halvorsen -----Original Message----- From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]] Sent: 16. oktober 2002 13:31 To: [EMAIL PROTECTED] Subject: how many active session? Does anyone know of a way to track the number of active sessions overnight. I know you can schedule re-occurring QUERY SESSIONs and then count them. I want to just get the number of active sessions say every 15, 30 or 60 minutes. I have to find the best place to move some backups but I don't have way of tracking this. Would that TSM MANGER product provide this? Thanks Matt
