Azure log analytics and Azure AD Sign-in logs

Question

I have imported Azure AD Sign-in logs to LogAnalytics workspace. I like to create a web portal where user input some data like user name, Date and time. Based on the user data the web portal should retrieve data from Azure Log Analytics and present it in table format on the web portal. Any suggestions how can I achieve this? I can run queries on Azur LogAnalytics to retrieve the data but I like to do the same from a web portal.

In simple words, I like to use a Front end for user input(User name and Date filed) run a log analytics query to retrieve data based on user input data and then present the query result in table format. I've attached a picture to explain what I'm trying to achieve:

Attached PIC

You'd better providing some screenshots, then people can easily understand / resolve the issue. — Ivan Yang
Have you tried to request the API GET https://graph.microsoft.com/v1.0/auditLogs/signIns to get the data? — Pamela Peng

KrishnaG-MSFT KrishnaG-MSFT · Accepted Answer · 2020-08-12T15:21:14

Sharing for the benefit of broader audience - Related question is being responded and followed-up here in Microsoft Q&A platform.

In other words, one way to accomplish your requirement is by creating a light weighted Azure Web App / Azure Function App for web portal which basically would be a single-page web application that queries Log Analytics Get Query API and displays the query results on the page.

Related references:

Azure log analytics and Azure AD Sign-in logs

1 Answers