The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
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
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 descThis will return all users currently connected.
This should do it:
SELECT
ula.[UserName]
,u.[email]
,ula.[AppName]
,ula.[LogonTime]
,ula.[LastActivityTime]
FROM [UserLogonActivity] ula
join SecUser su on su.name=ula.UserName
where ula.LogonStatus = 0 order by ula.Logontime desc
mathieu_cartel
OneStream Employee
OneStream EmployeeHi 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.
Hi ,
Just Additional question I want to display the User email Id as well how can i fetch that in this view.
- mathieu_cartel
This should do it:
SELECT
ula.[UserName]
,u.[email]
,ula.[AppName]
,ula.[LogonTime]
,ula.[LastActivityTime]
FROM [UserLogonActivity] ula
join SecUser su on su.name=ula.UserName
where ula.LogonStatus = 0 order by ula.Logontime desc