how to get admin user login ip

[ruchitanat3fed]

how we get admin user ip adress from admin_user_session table from db in magento 2?

[Manish Mittal]

@ruchitanat3fed 

Where do you want to fetch it?

SELECT * FROM admin_user_session WHERE `user_id` = 4

On the Admin sidebar, go to System > Actions Logs > Report.

There you can find all logs related to admin

For more:

https://docs.magento.com/user-guide/system/action-log-report.html