private static async Task <DigestResult> ScheduledDigestRun(string query, ILogger log)
{
log.LogInformation($"Executing scheduled daily digest run at: {DateTime.Now}");
string requestId = Guid.NewGuid().ToString();
log.LogInformation($"API request ID is {requestId}");
try
{
using (var httpClient = new HttpClient())
{
httpClient.DefaultRequestHeaders.Add("x-api-key", AiAppKey);
httpClient.DefaultRequestHeaders.Add("x-ms-app", "FunctionTemplate");
httpClient.DefaultRequestHeaders.Add("x-ms-client-request-id", requestId);
string apiPath = $"{AppInsightsApi}/{AiAppId}/query?clientId={requestId}×pan=P1W&query={query}";
using (var httpResponse = await httpClient.GetAsync(apiPath))
{
httpResponse.EnsureSuccessStatusCode();
var resultJson = await httpResponse.Content.ReadAsAsync <JToken>();
DigestResult result = new DigestResult
{
TotalRequests = resultJson.SelectToken("tables[0].rows[0][0]")?.ToObject <long>().ToString("N0"),
FailedRequests = resultJson.SelectToken("tables[0].rows[0][1]")?.ToObject <long>().ToString("N0"),
TotalExceptions = resultJson.SelectToken("tables[0].rows[0][2]")?.ToObject <long>().ToString("N0")
};
return(result);
}
}
}
catch (Exception ex)
{
log.LogError($"[Error]: Client Request ID {requestId}: {ex.Message}");
throw;
}
}
public static async Task Run([TimerTrigger("0 */1 * * * *")] TimerInfo myTimer, ILogger log)
{
log.LogInformation($"C# Timer trigger function executed at: {DateTime.Now}");
string appName = "Azure Serverless Computing Cookbook";
var today = DateTime.Today.ToShortDateString();
DigestResult result = await ScheduledDigestRun(
query : GetQueryString(),
log : log
);
SendGridMessage message = new SendGridMessage();
message.SetFrom(new EmailAddress("*****@*****.**"));
message.AddTo("*****@*****.**");
message.SetSubject($"Your daily Application Insights digest report for {today}");
var msgContent = GetHtmlContentValue("Azure Serverless Computing Cookbook", today, result);
message.AddContent("text/html", msgContent);
var client = new SendGridClient(SendGridAPIKey);
var response = await client.SendEmailAsync(message);
log.LogInformation($"Generating daily report for {today} at {DateTime.Now}");
}
static string GetHtmlContentValue(string appName, string today, DigestResult result)
{
return($@"
<html><body>
<p style='text-align: center;'><strong>{appName} daily telemetry report {today}</strong></p>
<p style='text-align: center;'>The following data shows insights based on telemetry from last 24 hours.</p>
<table align='center' style='width: 95%; max-width: 480px;'><tbody>
<tr>
<td style='min-width: 150px; text-align: left;'><strong>Total requests</strong></td>
<td style='min-width: 100px; text-align: right;'><strong>{result.TotalRequests}</strong></td>
</tr>
<tr>
<td style='min-width: 150px; text-align: left;'><strong>Failed requests</strong></td>
<td style='min-width: 100px; text-align: right;'><strong>{result.FailedRequests}</strong></td>
</tr>
<td style='min-width: 150px; text-align: left;'><strong>Total exceptions</strong></td>
<td style='min-width: 100px; text-align: right;'><strong>{result.TotalExceptions}</strong></td>
</tr>
</tbody></table>
</body></html>
");
}