ASPState, getting sessions accessed in last 20 mins.

Discussion in 'ASP .Net' started by Ronnie R, Jan 4, 2010.

  1. Ronnie R

    Ronnie R Guest

    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
     
    Ronnie R, Jan 4, 2010
    #1
    1. Advertising

  2. =?Utf-8?B?Um9ubmllIFI=?= <> wrote in
    news::

    >
    > 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! |
    *******************************************
     
    Gregory A. Beamer, Jan 4, 2010
    #2
    1. Advertising

  3. Ronnie R

    Ronnie R Guest

    Thanks Gregory, your answer appreciated

    "Gregory A. Beamer" wrote:

    > =?Utf-8?B?Um9ubmllIFI=?= <> wrote in
    > news::
    >
    > >
    > > 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, Jan 5, 2010
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bryan Ax
    Replies:
    0
    Views:
    627
    Bryan Ax
    Jun 26, 2003
  2. Hannes Heckner
    Replies:
    4
    Views:
    8,038
  3. Rob R. Ainscough

    User last accessed?

    Rob R. Ainscough, Jun 1, 2006, in forum: ASP .Net
    Replies:
    1
    Views:
    335
    Jeff Dillon
    Jun 1, 2006
  4. Roedy Green

    Date last Accessed vs Date Modified

    Roedy Green, Feb 21, 2008, in forum: Java
    Replies:
    1
    Views:
    1,529
    Nigel Wade
    Feb 22, 2008
  5. DamienS
    Replies:
    8
    Views:
    831
    DamienS
    Apr 27, 2009
Loading...

Share This Page