Forum Discussion

NSHAIK2's avatar
NSHAIK2
New Contributor
2 years ago
Solved

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
    2 years 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
    2 years 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

4 Replies

  • mathieu_cartel's avatar
    mathieu_cartel
    Icon for OneStream Employee rankOneStream Employee
    2 years 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
      2 years 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
      2 years 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
        Icon for OneStream Employee rankOneStream Employee
        2 years 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