✨ POC - Export data from Log Analytics to Azure Blob Storage for dev env

[AttackOnMorty]

Cc: @jimmidier @divgul @matt-goldman @piers-sinclair @adamcogan @william-liebenberg

Prerequisite:

• 🐛 Bug - Unable to start SophieBot locally #668

Pain

Investigate how easy to Export data from Log Analytics to Azure Blob Storage. If it's easy, we will directly build Power BI reports from Azure Blob Storage (We were planing to build reports from App Insights)

Tasks

Tasks

Beta Give feedback

1. Request access to Log Analytic workspace
2. Implement
3. Investigate what fields are queried in Workbooks reports

Acceptance Criteria

• Meets Definition of Done
• Can see the custom matrix in Azure Blob Storage
• Know what fields to query in Power BI reports

More Information

Doc: https://learn.microsoft.com/en-us/azure/azure-monitor/logs/logs-data-export?tabs=portal

Thanks!

[AttackOnMorty]

✅ Done - Exported Dev App Insights to the Azure Blob Storage. Data is stored in am-appevents.

Also did some investigation on current Workbooks reports. This can give us some reference on which fields to query for building Power BI reports.

• Usage by Query
• Usage by User

The data source comes from customEvents with name equals LuisResult.

The detailed fields are listed below (The fields in brackets are corresponding fields in Blob Storage):

• timestamp (TimeGenerated)
• name (Name)
• customDimensions.intent (Properties.intent)
• user_AccountId (UserAccountId)

[AttackOnMorty]

Note: SSWSophieBotDev App Insights is moved to log-sswsophiebot workspace.