DNN User Login report SQL script for DNN Reports Module

Here's a great sql script to use for the DotNetNuke Reports Module:

Select
  AU.Username,
  U.FirstName,
  U.LastName,
  AM.loweredEmail,
  AM.CreateDate,
  AM.LastLoginDate
from
  aspnet_Membership as AM with (nolock)
  join aspnet_Users as AU with (nolock) on AM.UserID = AU.UserID
  join Users as U  with (nolock) on U.UserName = AU.Username
where
  AM.ApplicationID = (select ApplicationID from dbo.aspnet_Applications where ApplicationName = 'DotNetNuke')