Core Modules

Snippets

10

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

Select
--   AU.Username,
   U.FirstName,
   U.LastName,
   AM.loweredEmail as Email,
switchoffset(CAST(AM.LastLoginDate as datetimeoffset),'-04:00') as LastLogin 
  
 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') order by LastLoginDate desc

Comments

There are currently no comments, be the first to post one!

Post Comment

Only registered users may post comments.