Skip to main content

vw_software_inventories

Creates, updates, deletes, gets or lists a vw_software_inventories resource.

Overview​

Namevw_software_inventories
TypeView
Idazure.security.vw_software_inventories

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.deviceId') as "device_id",
JSON_EXTRACT(properties, '$.osPlatform') as "os_platform",
JSON_EXTRACT(properties, '$.vendor') as "vendor",
JSON_EXTRACT(properties, '$.softwareName') as "software_name",
JSON_EXTRACT(properties, '$.version') as "version",
JSON_EXTRACT(properties, '$.endOfSupportStatus') as "end_of_support_status",
JSON_EXTRACT(properties, '$.endOfSupportDate') as "end_of_support_date",
JSON_EXTRACT(properties, '$.numberOfKnownVulnerabilities') as "number_of_known_vulnerabilities",
JSON_EXTRACT(properties, '$.firstSeenAt') as "first_seen_at",
subscriptionId,
resourceGroupName,
resourceNamespace,
resourceType,
resourceName,
softwareName
FROM azure.security.software_inventories
WHERE subscriptionId = 'replace-me';