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.