Query Details

Visualise the outdated Operating Systems used to connect to your cloud environment

Visualization Outdated OS Used

Query

CloudAppEvents
| where UserAgentTags contains "Outdated operating system"
| summarize count() by OSPlatform
| render piechart with(title="Outdated Operating Systems Used")

About this query

Visualise the outdated Operating Systems used to connect to your cloud environment

Defender XDR

Sentinel

CloudAppEvents
| where UserAgentTags contains "Outdated operating system"
| summarize count() by OSPlatform
| render piechart with(title="Outdated Operating Systems Used")

Explanation

This query is designed to identify and visualize the outdated operating systems that are being used to connect to your cloud environment. Here's a simple breakdown of what each part of the query does:

  1. Data Source: The query pulls data from the CloudAppEvents table, which contains records of events related to cloud applications.

  2. Filter: It filters the data to only include events where the UserAgentTags field indicates the use of an "Outdated operating system". This means it is specifically looking for connections made using operating systems that are no longer up-to-date.

  3. Summarize: The query then groups the filtered data by the OSPlatform field, which represents the type of operating system. It counts the number of occurrences for each operating system.

  4. Visualize: Finally, it creates a pie chart to visually represent the distribution of these outdated operating systems. The pie chart is titled "Outdated Operating Systems Used".

Both the Defender XDR and Sentinel queries perform the same function, using the same logic and structure, to provide a visual summary of outdated operating systems accessing your cloud environment.

Details

Bert-Jan Pals profile picture

Bert-Jan Pals

Released: December 1, 2024

Tables

CloudAppEvents

Keywords

CloudAppEventsOSPlatformUserAgentTags

Operators

wherecontainssummarizebyrenderwith

Actions

GitHub