Forum Discussion

NSHAIK2's avatar
NSHAIK2
New Contributor
7 months ago

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
Application Properties
  • mathieu_cartel's avatar
    mathieu_cartel
    7 months ago

    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's avatar
    mathieu_cartel
    7 months ago

    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

NSHAIK2's avatar
NSHAIK2
New Contributor

Hi ,

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

mathieu_cartel's avatar
mathieu_cartel
New Contributor II
7 months ago

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