Hi ,

I need to create an OTBI report to fetch details of all users who logged into Oracle CRM on a particular day. Unfortunately, I couldn't find any suitable subject area or standard report for this requirement.

Does anyone know how I can achieve this, or if there’s a specific subject area (like audit or security reports) that I should use? I’m looking for details such as:

• User Name
• Login Time
• Logout Time
• IP Address
• Session Duration

Any guidance or example queries would be highly appreciated!

Thanks in advance!