ASPState, getting sessions accessed in last 20 mins.

  • Thread starter Thread starter Ronnie R
  • Start date Start date
R

Ronnie R

Hi there,

I've written a query that I'm going to use to see the users that have had
'activity' in the last '20' minutes on my site.

SELECT * from [ASPState].[dbo].[ASPStateTempSessions]
where LockDate > DATEADD(MINUTE, -20, GETDATE())

It appears to do the job, but I'm assuming LockDate is a good column to use.

Any thoughts people? Thanks
 
Thanks Gregory, your answer appreciated

Gregory A. Beamer said:
LockDate should get the last access, so that is as good as any method.

Peace and Grace,

--
Gregory A. Beamer (MVP)

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************
.
Click to expand...
 
Back
Top