SOLVED

Azure Activity Log

Copper Contributor

Hi, we are exporting all Activity Logs (from all subscriptions) to a separate storage account. There they are stored as json files. How can I query the files for special events with powershell? Are there any apps in the store for this? Can I query it with OMS ?

1 Reply
best response confirmed by Stanislav Zhelyazkov (MVP)
Solution
Hi You can configure you Azure Activity Logs to be send directly to Log Analytics (part of OMS). From there using the new query language you can perform many functions to get the data you want. You can find more here: https://docs.microsoft.com/en-us/azure/log-analytics/log-analytics-activity If you want to use Storage accounts and PowerShell for this you will need to create some custom powershell scripts that pull the data from the storage account. This won't be an easy task and will require a lot of engineering. I suggest to use Log Analytics
1 best response

Accepted Solutions
best response confirmed by Stanislav Zhelyazkov (MVP)
Solution
Hi You can configure you Azure Activity Logs to be send directly to Log Analytics (part of OMS). From there using the new query language you can perform many functions to get the data you want. You can find more here: https://docs.microsoft.com/en-us/azure/log-analytics/log-analytics-activity If you want to use Storage accounts and PowerShell for this you will need to create some custom powershell scripts that pull the data from the storage account. This won't be an easy task and will require a lot of engineering. I suggest to use Log Analytics

View solution in original post