User Login Report

Hi,

we have received a request from the customer who needs a report listing all users who have not accessed Oracle Fusion for more than one month.

We have written the following query:

SELECT fu.username, TO_CHAR(fs.last_connect, 'YYYY-MM-DD HH24:MI:SS') AS last_login_date FROM per_users fu LEFT JOIN(SELECT user_name, MAX(last_connect) AS last_connect FROM fnd_sessions WHERE user_name NOT LIKE 'FUSION_APPS%' GROUP BY user_name) fs ON fu.username = fs.user_name WHERE fu.username NOT LIKE 'FUSION_APPS%' ORDER BY 2 desc nulls last

However, we noticed that the fnd_sessions table only tracks data for the last week. How can we fulfill the customer's request and retrieve the list of users whose last login date is older than SYSDATE - 30?