#AzureMonitor Logs – Have you noticed the Export button?

Earlier this week, Anders and I were working with exporting data from Log Analytics to a CSV file. Previously, this has always been done with the API. But nowadays we have an Export button to direct export the result from the current query. On the Export drop down menu we also have the options to export to PowerBI.

From the Export menu we can choose CSV format direct. In the screenshot you can see there is a option to export all columns or displayed columns. Displayed columns are the ones you project in the query. All columns is, in this example, all column in the VMConnect table. We can then easily massage and format the data in Excel if needed. Very quick compared to writing a script exporting the data

clip_image002

clip_image004

clip_image006


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s