Ray's Asp.net Blog
Answers and code snippets from ASP.NET projects (Webforms/MVC/Classic ASP)
Pages
Event registration app with QR/Paypal
Home
Tuesday, April 16, 2013
How to get active users in last 10 minutes in ASP.NET membership database?
select top 300 * from dbo.aspnet_Users u
where u.LastActivityDate > DATEADD(minute, -10, GETUTCDATE())
order by u.LastActivityDate desc
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)