05-28-2024 08:47 AM
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
Solved! Go to Solution.
05-28-2024 09:27 AM
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.
05-28-2024 10:07 AM
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
05-28-2024 09:27 AM
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.
05-28-2024 09:49 AM
Hi mathieu_Cartel,
Thank you much for the reply .
It worked I was not aware the table name that helped me.
Thanks
05-28-2024 09:59 AM
Hi ,
Just Additional question I want to display the User email Id as well how can i fetch that in this view.
05-28-2024 10:07 AM
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