Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ASPState, getting sessions accessed in last 20 mins.

0 views
Skip to first unread message

Ronnie R

unread,
Jan 4, 2010, 12:36:01 PM1/4/10
to
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


Gregory A. Beamer

unread,
Jan 4, 2010, 1:28:28 PM1/4/10
to
=?Utf-8?B?Um9ubmllIFI=?= <Ron...@discussions.microsoft.com> wrote in
news:46E7B34C-7997-430A...@microsoft.com:

>
> Any thoughts people?

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! |
*******************************************

Ronnie R

unread,
Jan 5, 2010, 4:58:05 AM1/5/10
to
Thanks Gregory, your answer appreciated

"Gregory A. Beamer" wrote:

> .
>

0 new messages