Is there any way to get the User's logout time in SharePoint 2010 ?

Question

We have a web application which contains several sub sites. And we want to generate a report which has to give the user’s login and logout time for the each sub site. We need to generate a report  (as displayed below)

User                         module                                                       Date                    login                   log out 

Domain/admin1         http://sharepoint:1111/RoutingRules/          03/18/2013         10:30                  10:45

Domain/admin1         http://sharepoint:1111/Knowledge/              03/18/2013         10:45                  10:55

Domain/admin2         http://sharepoint:1111/RoutingRules/          03/18/2013         10:55                  11:15

Trails:

1. We have tried with the SharePoint content database WSS_UsageApplications (or WSS_Logging) "RequestUsage" view but I could not find the realted columns. Ex :- "Duration" in the view RequestUsage -- time for the front-end Web server to process the request
2. While working on this issue we have found below observations in the forums. “There is no direct way to determine user logout event because there are many possible scenarios when user may go way from your site without clicking on logout button and his authentication cookies will be expired, so technically he will be logged out but without particular event.”

Queries:-

1. Is duration useful to know the log out time? Or any other field or table is there to know the log out time?
2. Any other third party tool available to achieve our requirement ?
3. Please provide us to appropriate solution to achieve our requirement.

---

Regards, Deepak Koduri

Answer 1

Its not available out of the box, however it is provided by third party tool, refer to the following post

http://blog.muhimbi.com/2011/06/reporting-site-collection-level-user.html

---

--Cheers

Answer 2

hello

there is no direct way to determine user logout event (because there are many possible scenarios when user may go way from your site without clicking on logout button - and his authentication cookies will be expired, so technically he will be logged out but without particular event). Check this forum thread: I need to log out of the application when user closes the browser of a sharepoint 2007 internet website . It contains some useful info about this question.

Determining of login event is possible - however it depends on authentication type you use: FBA or NTLM. If you use FBA - you need to customize standard ASP.Net Login control and handle its LoggedIn event. If you use NTLM authentication - try to use http modules and handle AuthenticateRequest event of web application. Hope it will give you the direction.