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

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

NSHAIK2's avatar
NSHAIK2
New Contributor
7 months ago

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