Ray's Asp.net Blog
Answers and code snippets from ASP.NET projects (Webforms/MVC/Classic ASP)
Pages
(Move to ...)
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
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment