Display Current Login User

NSHAIK2
New Contributor

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

2 ACCEPTED SOLUTIONS

mathieu_cartel
New Contributor II

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.

View solution in original post

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

View solution in original post

4 REPLIES 4

mathieu_cartel
New Contributor II

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.

Hi mathieu_Cartel,

 

Thank you much for the reply .

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

Thanks

Hi ,

Just Additional question I want to display the User email Id as well how can i fetch that in this view.

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