Jun 18 2020
11:57 AM
- last edited on
Apr 08 2022
10:29 AM
by
TechCommunityAP
Jun 18 2020
11:57 AM
- last edited on
Apr 08 2022
10:29 AM
by
TechCommunityAP
Good afternoon,
Just starting to get my feet wet on loganalytics queries I can run this query:
Jun 18 2020 11:00 PM
@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
Jun 19 2020 11:53 AM
@JK_UK Thank you for your help!!