How to get the user information like location, machine name or client IP, application name or source etc., when accessing and querying Azure SQL using Logs?

Question

Trace the user information when executes sql queries on Azure SQL

Answer 1

@Veera Ganesh - Welcome to Microsoft Q&A and thanks for reaching out to us.

You can use Azure Monitor Logs. Azure Monitor Logs provides a way to collect, analyze, and query log data from various sources, including Azure SQL.

To get user information, you can use the sys.fn_get_audit_file function to query the audit logs.

This query retrieves information about successful SELECT statements executed on the server, including the client IP, application name, and server and database principal names.

The audit logs contain information about all the events that occur on the server, including successful and failed login attempts, and the IP address of the client machine.

Hope this helps. and please feel free to reach out if you have any further questions.

---

Please don't forget to "Accept as Answer" and click "Yes" if the above response is helpful, so it can be beneficial to the community.