Display Current Login User

[NSHAIK2]

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

[mathieu_cartel · Accepted solution]

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.

[mathieu_cartel · Accepted solution]

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.

[NSHAIK2]

Hi mathieu_Cartel,

Thank you much for the reply .

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

Thanks

[NSHAIK2]

Hi ,

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

[mathieu_cartel · Accepted solution]

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