How to find out the users who accessed Databricks and from which location

Mohit_m — Mon, 13 Dec 2021 09:21:24 GMT

Re: How to find out the users who accessed Databricks and from which location

Mohit_m — Mon, 13 Dec 2021 09:22:51 GMT

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

Using audit logs, lot of information can be found out