Hi All,
I am preparing a weekly report for User login frequency.
The data is fetched from a cloud DB table which is getting enriched (picking data) from login_audit.csv. The intention of the report is to fetch all active users, and the entitlement mapped to these users. Following query is used to fetch the data and we have a requirement to add the last login details to this query.
SELECT USER_NAME, FIL_UNIQUE_ID, GROUP_NAME, IS_ACTIVE, LAST_LOGIN FROM UAGR_USER_GROUP_MAPPING
Discussion posts and replies are publicly visible
Could you give me more details? How is the database populated? There is an app on the market called User Activity Tracker that works that way.