Inventory of software installed on devices, including their version information and end-of-support status
Table retention
ColdDays
HotDays
TotalInteractiveDays
0
30
30
Schema
Name
Description
Type
DeviceId
Unique identifier for the device in Microsoft Defender for Endpoint
String
DeviceName
Fully qualified domain name (FQDN) of the device
String
EndOfSupportDate
End-of-support (EOS) or end-of-life (EOL) date of the software product
DateTime
EndOfSupportStatus
Indicates the lifecycle stage of the software product relative to its specified end-of-support (EOS) or end-of-life (EOL) date
String
MachineGroup
String
OSArchitecture
Architecture of the operating system running on the machine
String
OSPlatform
Platform of the operating system running on the device. This indicates specific operating systems, including variations within the same family, such as Windows 10 and Windows 7
String
OSVersion
Version of the operating system running on the machine
String
ProductCategory
Category of the software product
String
ProductCodeCpe
The standard Common Platform Enumeration (CPE) name of the software product version
String
SoftwareName
Name of the software product
String
SoftwareTags
Array of tags applied to the software product. Example: AI (present for AI-related software products such as langchain, torch, @anthropic-ai/sdk)