topic How to find when was the last time a user logged in to Azure Databricks? in Administration & Architecture

How to find when was the last time a user logged in to Azure Databricks?

schluckie — Sat, 25 Oct 2025 11:49:32 GMT

Hi,

I am asked to prepare a report on Azure Databricks usage in our company. Most metadata I need, like a list of users, workspaces, users rights on workspaces etc. I already have, but I do not know how to determine when the last time was a user logged in to an Azure Databricks workspace. Any suggestions would be highly appreciated.

Re: How to find when was the last time a user logged in to Azure Databricks?

Mailendiran — Sat, 25 Oct 2025 12:53:11 GMT

I'm not sure, but have you tried checking in system catalog tables ?

Re: How to find when was the last time a user logged in to Azure Databricks?

ncf5031 — Mon, 27 Oct 2025 10:14:27 GMT

Hi @schluckie you can check using a query like the one below and just change the ip address to match your conventions, or remove it entirely.

SELECT event_time, user_identity.email, source_ip_address, action_name, response.status_code FROM system.access.audit WHERE action_name IN ('login', 'logout', 'createToken', 'deleteToken') AND (response.status_code >= 400 OR source_ip_address NOT LIKE 'xx.%') AND event_date >= current_date() - INTERVAL 7 DAYS ORDER BY event_time DESC