Management report - for usage
1 vote
Good day Devolutions
Could you please create an activity report / dashboard for management?
Where they could see how much the Devolutions platform is being used - per user and per user group?
Currently we are exporting activity logs, and then adjusting the data through excel. The idea is that we show total actions per user and group (Opened session, viewed password, Entry edited, etc)
We have multiple use cases for this report
to show the usage of RDM platform by our supporting partners and internal users
to show how many RDM entries our automation script has edited (by pulling data directly from SNOW and HALO ITSM platforms)
All Comments (7)
Hello,
Thank you for your suggestion. Could you elaborate a bit more on your use case and what you would like to see in that report? Currently, it is possible to filter the activity logs by users, which allows you to see what has been done by one or many users and view all operations. Would you like to see the number of operations instead of the operations themselves? For example, would you like to see that your user Bob has made 30 views of passwords, created 10 new entries, and deleted 2 entries? Is this what you would like to find in such a report/dashboard? Am I understanding correctly?
Best regards,
François Dubois
Yes, exactly. that what you described.
A summary of the usage, for the management to see how much the platform is actually been used.
If there could be a section which also shows how many connections were established via Devolutions Gateway, that would also be very handy.
Hello,
Thank you for your answer. I understand your needs then. We will have internal discussions and see what can be done to meet those needs. We will post back here once we have an update.
Best regards,
François Dubois
Hi Francois,
Would it also be possible to include some trends and statistics?
Such as Maximum concurrent sessions that were established through the gateway?
Historical statistics based on date/time connections were established? Like per day/week/month?
How many users are active or inactive (did they login in the last 180/90/60/30/15 days)?
What client user logged in with, version of the client, and the OS of the workstation?
Hello Dave,
Thank you for the additional feedback, we will add these suggestions to our internal discussions.
Have a good day!
Maxime Morin
try this against MSSQL DB
WITH LatestConnections AS (
SELECT
Username,
StartDateTime,
ROW_NUMBER() OVER (PARTITION BY Username ORDER BY StartDateTime DESC) AS rn
FROM [CyberRDM].[dbo].[ConnectionLog]
)
SELECT
Username,
StartDateTime
FROM
LatestConnections
WHERE
rn = 1
ORDER BY
StartDateTime DESC;
Thanks christian, but we need a self-service report for the management team.