Skip to main content
Known Participant
Jan 20, 2025 12:33 PM UTC
Question

Unable to fetch last login detail of user a weekly reporting

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 

    1 reply

    davidj137213
    Brainy
    Jan 20, 2025 3:25 PM UTC

    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.