You can use Audit logs to fetch this data
Query:
%sql
SELECT DISTINCT userIdentity.email, sourceIPAddress
FROM audit_logs
WHERE serviceName = "accounts" AND actionName LIKE "%login%"
Please find below the docs to analyse the Audit logs
https://docs.databricks.com/administration-guide/account-settings/audit-logs.html#analyze-audit-logs
Using audit logs, lot of information can be found out
