Permissions required to update LogAnalytics AzureDiagnostics table output

Copper Contributor

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' and Category contains 'Errors'
And I get some good valuable data.  There are a bunch of default columns that are output. However there is also the 'columns filter' option where I can choose more / less columns in my result set from Azurediagnostics.  But I can't save my selections.  It always resets to the default column values when I rerun the query.
 
Can you provide the permissions I require to update this option?  Thank you for your time. You have been very helpful so far.
2 Replies

 

@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