Implemented

Login activities report on users

Published 7 years ago

Dear Devolutions,

We would like to cleanup our list with users in RDM. I am trying to generate a list of users that are allowed in RDM and last login time. I have tried genereting an overview using the RDM client and using the Devolutions Password Server, but I am not able to generate an usable list.

Using RDM client I don't see any possibility to generate a list of users with their last login time.
Using DPS there is feature Reports with Login History. The strange thing is, generating a report for the last 7 days or last 90 days, gives me different results when sorting from newest to oldest.

Is there any possibility to cleanup the user list in RDM based on last logon time? Is there any possibility to generate a report of users from RDM with their last logon time?

All Comments (2)

Maurice Côté

Published 7 years ago

hello,

We will investigate the issue of different results as this sounds like a bug. We will also evaluate improving the report filtering capabilities, this as a feature request.

In the mean time, we simply have to query the LoginHistory table, something like

SELECT UserName, MAX(CreationDate)
FROM LoginHistory
GROUP BY UserName
ORDER BY Max(CreationDate)
You can contact us at ticket@devolutions.net to get assistance running this.

Best regards,

Maurice

nlgrp_it_security

Published 7 years ago

Hello Maurice,

Thank you for the response. Would be great to have a feature in DPS or RDM to generate such info. Here is hte usable query:

SELECT [ID]
,[FullName]
,[Email]
,[LastLoginDate]
,[CreationDate]
,[CreatedByUserName]
,[CreatedByLoggedUserName]
,[ModifiedDate]
,[ModifiedUserName]
,[ModifiedLoggedUserName]
FROM [DBNAME].[dbo].[UserAccount]