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