✨ Export common metrics from App Insights to Blob Storage

[AttackOnMorty]

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

Depends on

• ✨ Data export for prod App Insights #689

Pain

We did the investigation on what common metrics to track in #688.

We need to export these fields in #688 (comment) to Azure Blob Storage.

Suggested Solution

Tasks

Preview Give feedback

1. Export data
2. Document the corresponding fields in Blob Storage

Acceptance Criteria

• Meets Definition of Done
• Data is exported to Blob Storage
• Have a note on the fields in Blob Storage

Thanks!

[AttackOnMorty]

Below are the important fields in App Insights tables (with corresponding Blob Storage fields in brackets).

pageViews

Data about each website view with browser information.

• timestamp (TimeGenerated)
• name (Name)
• url (SophieBot DOESN'T have this field. See note below.)
• user_AccountId (UserAccountId)

Note: For SophieBot, we can skip the report for this table. Because SophieBot is not a web application. It doesn't have url field.

exceptions

Exceptions thrown by the application runtime, captures both server side and client-side (browsers) exceptions.

• timestamp (TimeGenerated)
• problemId (ProblemId)
• type (Type)

requests

Requests received by your application. For example, a separate request record is logged for each HTTP request that your web app receives.

• timestamp (TimeGenerated)
• name (Name)
• url (Url)
• success (Success)
• responseCode (ResultCode)
• duration (DurationMs)

dependencies

Calls from the application to other components (including external components) recorded via TrackDependency() - for example, calls to REST API, database or a file system.

• Fields are same as in requests table.

performanceCounters

Performance measurements from the compute resources supporting the application, for example, Windows performance counters.

• timestamp (TimeGenerated)
• name (Name)
• value (Value)