Blog Post

Azure Database Support Blog
3 MIN READ

AZURE SQL DB AND LOG ANALYTICS BETTER TOGETHER – PART #1

FonsecaSergio's avatar
FonsecaSergio
Icon for Microsoft rankMicrosoft
Aug 08, 2019
As a DBA you may want to query SQL Audit and SQL Diagnostics information. The easiest way to do this is sending to Log analytics that is part of Azure Monitor You can also send this data to Event H...
Updated Jul 01, 2020
Version 4.0
Azure SQL DB
m60freeman's avatar
m60freeman
Copper Contributor
Feb 15, 2023

I have a query that finds errors in some of my Azure SQL Databases:

AzureDiagnostics
| where TimeGenerated > ago(1d)
| where Category == "Errors"
and DatabaseName_s has "<redacted>"
| summarize count(), min(TimeGenerated), max(TimeGenerated)
by error_number_d,Message, LogicalServerName_s, DatabaseName_s, query_hash_s, client_ip_s, application_name_s, session_server_principal_name_s
| sort by max_TimeGenerated desc

 

However, the last 3 columns (client_ip_s, application_name_s, session_server_principal_name_s) do not appear in the output. How can I get that information included?