Hi Divya,

Thank you for reaching out to Okta Community, my name is Vlad.

" is there api which exists which would help me retrieve all the user details such as last login , status , and so on based on the month or datetime - it should retrieve all users logged in ."

• You can use the api/v1/users?limit=25 for list users and you will get about 25 users based on the limit, also you can use pagination in order to show the next 25 users and so on until all of your users are being showed. Keep in mind that if you are using Postman, you need to access the User Collection -> List Users.
• A easier way to retrieve this info is by accessing Admin Dashboard -> Reports -> Reports - Okta Password Health.

"i checked we have filters for last updated and search option but is it possible to get multiple records for the same user as to how many time he logged in to okta"

• You can use the system logs API request with a specific user ID and you can retrieve all the logs by using the following API call: {{url}}/api/v1/logs/?eventType=user.session.start

Docs: https://developer.okta.com/docs/reference/api/system-log/

For more details about the API calls, I strictly suggest to open a case with us

Thank you,

Vlad Tanasa

Technical Support Engineer

Okta Global Customer Care