Devolutions ForumDevolutions Forum

Accessing the date of last logins of all the users on our RDM platform

Accessing the date of last logins of all the users on our RDM platform

0 vote

avatar
ricunhaneves

Hello
We are looking for a feuture that allows us to get a log were its possible to see the dates of the last logins of all the users in the RDM

We are using the Remote Desktop Manager, Version 2022.3.29.0 and the Data source is Microsoft SQL Server.

Thank you

All Comments (2)

avatar
David Hervieux

Hello
It's not possible to get the last login in RDM with SQL Server. This is only possible with Devolutions Server and Password Hub. Perhaps you can get the last login directly in the SQL Server database?

https://stackoverflow.com/questions/47905406/sql-server-2016-how-to-get-last-logged-in-date-for-user

Regards

David Hervieux

avatar
Kyle Weber

I have the same need. I was not able to get login information from the SQL server, but I was able to create a SQL query that shows me the date of all user's last activity within RDM.

SELECT us.Name
	  ,ua.FullName
	  ,up.Department
	  ,ua.CreationDate
      ,MAX(cl.[StartDateTime]) as 'LastActivityDate'
  FROM [RemoteDeskopManager_Infrastructure].[dbo].[ConnectionLog] cl
  right join [RemoteDeskopManager_Infrastructure].[dbo].[UserSecurity] us
   on cl.Username = us.Name
  left join [RemoteDeskopManager_Infrastructure].[dbo].[UserProfile] up
   on us.ID = up.UserID
  left join [RemoteDeskopManager_Infrastructure].[dbo].[UserAccount] ua
   on us.id = ua.id
  WHERE us.UserType = 0
  group by us.Name,ua.FullName,up.Department,ua.CreationDate
  order by MAX([StartDateTime]) DESC