See the solution below in explanation.
Explanation:
Step 1: Write the KQL Query
* Open Azure Data Explorer:
* Navigate to Azure Data Explorer and sign in with your credentials.
* Access the Securitylogs Database:
* Open the Securitylogs database.
* Write the Query:
* Use the following KQL query tocount the number of inbound requests for each source IP address:
InboundBrowsing
| where Timestamp between (datetime(2021-10-01) .. datetime(2021-12-31))
| summarize NumberOfRequests = count() by SourceIP
| project SourceIP, NumberOfRequests
Step 2: Export the Query Results
* Run the Query:
* Execute the query in Azure Data Explorer.
* Export the Results:
* Once the query results are displayed, click on the Export button.
* Choose the export format (e.g., CSV) and specify the export path as C:\Samples.
By following these steps, you will have successfully written a KQL query to count the number of inbound requests for each source IP address during the last three months of 2021 and exported the results to C:\Samples