Web Reports - How to obtain last login date

1

How can I determine the last login date for all of my Web Reports user accounts, so that I can clean up the innactive ones?

We’re using v. 10.0.10.46

2

I don’t think we expose it in the user interface, but you could query it at the SQL level

SELECT TOP (1000) [UserID]
      ,[LoginName]
      ,[DisplayName]
      ,[IsADUser]
      ,[ADGuid]
      ,[LastLoginTime]
      ,[LdapID]
      ,[DatabaseId]
  FROM [BESReporting].[dbo].[USER_NAMES]