Skip to main content
Newcomer
May 28, 2024 12:47 PM UTC
Solved

Display Current Login User

Hi All,

I would like to create the Dashboard for the Adim which should display all the Current login users Details in the applications.

Kindly help to achieve this development.

 

Thanks

OneStream Employee
May 28, 2024 1:27 PM UTC

Hi NSHAIK2 

You can create a dashboard data adapter that runs the query below against the Framework database:

SELECT
[UserName]
,[AppName]
,[LogonTime]
,[LastActivityTime]
FROM [UserLogonActivity] where LogonStatus = 0 order by Logontime desc

This will return all users currently connected.

4 replies

OneStream Employee
May 28, 2024 1:27 PM UTC

Hi NSHAIK2 

You can create a dashboard data adapter that runs the query below against the Framework database:

SELECT
[UserName]
,[AppName]
,[LogonTime]
,[LastActivityTime]
FROM [UserLogonActivity] where LogonStatus = 0 order by Logontime desc

This will return all users currently connected.

NSHAIK2Author
Newcomer
May 28, 2024 1:49 PM UTC

Hi mathieu_Cartel,

 

Thank you much for the reply .

It worked I was not aware the table name that helped me.

Thanks