KQL Search

Query Details

Upcomming End of Support software used

Upcomming EOS Software

Query

DeviceTvmSoftwareInventory
| where EndOfSupportStatus == "Upcoming EOS Version"
| project DeviceName, OSPlatform, OSArchitecture, SoftwareVendor, 
SoftwareName, SoftwareVersion, EndOfSupportDate

About this query

Upcomming End of Support software used

Defender XDR

Explanation

This query is designed to identify software on devices that is nearing its end of support. It looks at the inventory of software on devices and filters for software versions that have an "Upcoming End of Support" status. The query then selects and displays specific details about this software, including:

  • The name of the device where the software is installed (DeviceName)
  • The operating system platform of the device (OSPlatform)
  • The architecture of the operating system (e.g., 32-bit or 64-bit) (OSArchitecture)
  • The vendor of the software (SoftwareVendor)
  • The name of the software (SoftwareName)
  • The version of the software (SoftwareVersion)
  • The date when the software will no longer be supported (EndOfSupportDate)

In simple terms, this query helps you find and review software that will soon lose support, so you can plan for updates or replacements.

Details

Bert-Jan Pals profile picture

Bert-Jan Pals

Released: December 1, 2024

Tables

DeviceTvmSoftwareInventory

Keywords

DeviceNameOSPlatformArchitectureSoftwareVendorVersionEndOfSupportDate

Operators

|==project

Actions

GitHub