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