How to get the last login date and time of a CRM user (MSCRM 2011)

In Microsoft Dynamics CRM 2011 you can get the last login time of a CRM user by using the below query: 

SELECT

      AuthInfo, O.FriendlyName, SUO.LastAccessTime

FROM

      SystemUserOrganizations SUO

      LEFT JOIN SystemUserAuthentication SUA ON SUO.UserId = SUA.UserId AND LEFT(AuthInfo, 1)='C'

      LEFT JOIN Organization O ON SUO.OrganizationId=O.Id

WHERE

      LastAccessTime IS NOT NULL

ORDER BY SUO.LastAccessTime DESC

The query outputs the systemuser name, the organisation name and the date and time of the last login:

You can finetune the query to your own wishes.