Helping others get things done using Kusto Query Language (KQL).
Identify unsupported software and the devices they are installed on.
[Read more…] about KQL query breakdown: Devices with End of Support (EOS) software installed
Use KQL to generate a report of disk free space (both percentage free and GB free) for Intune devices.
[Read more…] about KQL Query Breakdown: Show disk free space by Intune device
Use KQL to get a list of your device models and counts from Intune.
To get a list of all of the various device models you have registered in Intune, AND how many of each of those models you have, there is a KQL query for that.
[Read more…] about KQL Query Breakdown: Intune Device Models and CountsStart getting hands on with KQL using Azure Data Explorer’s free cluster offering.
OK, you’ve answered the question What is KQL?, read the primer, understand you need to know KQL (especially if you are working with Microsoft services) and want to start dabbling. While you can start working with KQL queries directly against live data sources such as Azure Log Analytics, Application Insights, or Microsoft Defender, where you can you start working with a data sandbox and cultivating your KQL skills?
[Read more…] about Getting started with KQL using Azure Data Explorer
KQL is the query language used by Azure Data Explorer (ADX) and a number of other Microsoft Azure services built on top of ADX, such as Log Analytics and Application Insights, as well as other Microsoft services such as Microsoft Defender. It enables users to perform complex data analysis tasks and extract valuable insights from large data sets. KQL is designed to be user-friendly, easy to learn, and efficient for data querying.
[Read more…] about Kusto Query Language (KQL): a primer