«

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

=?Utf-8?B?Um9ubmllIFI=?= <> wrote in
news:46E7B34C-7997-430A-B251-:

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

Thanks Gregory, your answer appreciated

"Gregory A. Beamer" wrote:

> =?Utf-8?B?Um9ubmllIFI=?= <> wrote in
> news:46E7B34C-7997-430A-B251-:
>
> >
> > 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! |
> *******************************************
> .
>