Telemetry - OfficeDev/microsoft-teams-apps-newemployeeonboarding GitHub Wiki

New employee onboarding app logs telemetry to Azure Application Insights. You can go to the Application Insights blade of the Azure App Service to view basic telemetry about your services, such as requests, failures, and dependency errors, custom events, traces.

App integrates with Application Insights to gather bot activity analytics, as described here.

App logs a few kinds of events:

Events logs keeps the track of application events and also logs the user activities like:

• Total and Unique Users per month.

• Number of introduction submitted per week/month.

• Number of introduction approved per week/month.

• Average number of introduction posted to Teams channel.

• Number of feedback shared per week/month.

• Number of learning plan notification card sent per week/month.

• Number of pair up notification card sent per week/month.

• Average Response Time

  Exceptions` logs keeps the records of exceptions tracked in the application.

Application Insights queries:

• This query gives total number of unique users of bot.

customEvents
| extend User = tostring(customDimensions.userId)
| summarize dcount(User)

- This query gives total number of introduction submitted per week/month.

customEvents | project name, timestamp | where name contains "Introduction submitted" and (timestamp >= datetime('<>') and timestamp <= datetime('<>')) | summarize count() by name

• This query gives total number of introduction approved per week/month.

customEvents
| project name, timestamp
| where name contains"Introduction approved by manager"and (timestamp >= datetime('<<Start date time>>') and timestamp <= datetime('<<End date time>>'))
| summarizecount() by name

- This query gives total number of introduction posted to Teams channel.

customEvents | project name, timestamp | where name contains "Introduction posted to Teams" and (timestamp >= datetime('<>') and timestamp <= datetime('<>')) | summarize count() by name

• This query gives total number of feedback shared per week/month.

customEvents
| project name, timestamp
| where name contains "Feedback submitted" and (timestamp >= datetime('<<Start date time>>') and timestamp <= datetime('<<End date time>>'))
| summarize count() by name

- This query gives total number of learning plan notification card sent per week/month.

customEvents | project name, timestamp | where name contains "Sending notification to the specified conversation id" and (timestamp >= datetime('<>') and timestamp <= datetime('<>')) | summarize count() by name

• This query gives total number of pair up notification card sent per week/month.

customEvents
| project name, timestamp
| where name contains "Pair-up notification sent" and (timestamp >= datetime('<<Start date time>>') and timestamp <= datetime('<<End date time>>'))
| summarize count() by name

- This query gives average response time of requests.

requests | summarize avg(duration)