Forum Stats

  • 3,759,045 Users
  • 2,251,494 Discussions
  • 7,870,477 Comments

Discussions

Hyperion User Last Login

Hello_Kitty
Hello_Kitty Member Posts: 10 Red Ribbon
edited Jun 9, 2020 3:58PM in Hyperion Query and Reporting

I was using EAS to generate the log entry of logged users into table called SERVERLOGDETAIL, but I don't know where to find this file. Does anyone know where I can find it?

Thanks in advance for any help.

Answers

  • Harishkumar Y-Oracle
    Harishkumar Y-Oracle Member Posts: 112 Employee
    edited Jun 9, 2020 3:58PM

    In EAS Console generate Log Charts for Server (or Application) and select “Logged Users” as filter and refresh the chart.
    This will upload the log entries into a table called SERVERLOGDETAIL in EAS relational database scheme.
     
    Then execute below SELECT statement against the SERVERLOGDETAIL table,

    SELECT username as “User Name”, MAX(entrydate) AS “Last Login Date”
    FROM serverlogdetail where username is not null
    GROUP BY username;

    This will provide last login detail of users.

    Also, please refer #