Forum Discussion
Permissions required to update LogAnalytics AzureDiagnostics table output
Good afternoon, Just starting to get my feet wet on loganalytics queries I can run this query: AzureDiagnostics | where LogicalServerName_s contains 'server1' and Resource contains 'database1' a...
MarkSteben Use project to choose the columns you want, for instance:
AzureDiagnostics
| where LogicalServerName_s contains and server1' and Resource contains 'database1' and Category contains 'Errors'
| project TimeGenerated, Resource, OperationName, LogicalServerName_s, DatabaseName_s
or project-away removes columns
JK_UK Thank you for your help!!