SQL to Monitor Application Logins

When an implementation of Oracle E-Business Suite goes live you might want to monitor the use of the system to see if, for example, users logged in. We had this requirement.

Find the below SQL I created for your reference, as always change it where needed.

SELECT
    FUSER.USER_NAME
    , PER.FULL_NAME
    , PER.EMPLOYEE_NUMBER
    , FLO.START_TIME
FROM
    APPLSYS.FND_LOGINS FLO
    , APPLSYS.FND_USER FUSER
    , APPS.PER_PEOPLE_F PER
WHERE
    FLO.USER_ID = FUSER.USER_ID
    AND FUSER.EMPLOYEE_ID = PER.PERSON_ID
    AND FLO.TERMINAL_ID IS NULL
ORDER BY
    FLO.START_TIME DESC