Last User Login Date/Time

Answers

• 

  

  0

  Sign in to vote

  The login time of a user is not logged in the database.  Without some sort of custom auditing, the only place to look would be in the iis logs.  If the user has the Outlook client, there is usually an informational event logged each time the client is initialized, but there is nothing that occurs on the client if the user only uses the web client.

  • Proposed as answer by Andrii ButenkoMVP, Moderator Thursday, August 13, 2009 6:15 AM
  • Marked as answer by Donna EdwardsMVP Friday, April 1, 2011 3:01 AM

  Thursday, August 13, 2009 5:55 AM
• 

  

  0

  Sign in to vote

  Hi,

  
  

  It is not possible to retrieve the information from within the MS CRM database but it is possible using IIS Logging.

  Have a read of this excellent post by David Jennaway titled "CRM Usage Reporting Unleashed". This will allow you to view user login details. Please find URL below.

  http://blogs.msdn.com/crm/archive/2009/04/08/crm-usage-reporting-unleashed.aspx

  
  

  Hassan.

  
  

  ---

  Hassan Hussain | http://hassanhussain.wordpress.com/

  • Proposed as answer by Hassan Hussain Thursday, August 13, 2009 9:15 AM
  • Marked as answer by Donna EdwardsMVP Friday, April 1, 2011 3:01 AM

  Thursday, August 13, 2009 9:15 AM
• 

  

  0

  Sign in to vote

  In CRM 2011 it is possible to get the last login date of a CRM user with a simple SQL query, look at

  http://www.resultondemand.nl/support/blog/post/How-to-get-the-last-login-date-and-time-of-a-CRM-user-(MSCRM-2011).aspx

  • Marked as answer by Donna EdwardsMVP Friday, April 1, 2011 3:01 AM

  Tuesday, March 29, 2011 10:32 AM