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
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.

  • NSHAIK2's avatar
    NSHAIK2
    New Contributor
    7 months ago

    Hi mathieu_Cartel,

     

    Thank you much for the reply .

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

    Thanks

  • 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