Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
azure_instance_metadata
Azure instance metadata.
Column | Type | Description |
---|---|---|
location | text | Azure Region the VM is running in |
name | text | Name of the VM |
offer | text | Offer information for the VM image (Azure image gallery VMs only) |
os_type | text | Linux or Windows |
placement_group_id | text | Placement group for the VM scale set |
platform_fault_domain | text | Fault domain the VM is running in |
platform_update_domain | text | Update domain the VM is running in |
publisher | text | Publisher of the VM image |
resource_group_name | text | Resource group for the VM |
sku | text | SKU for the VM image |
subscription_id | text | Azure subscription for the VM |
version | text | Version of the VM image |
vm_id | text | Unique identifier for the VM |
vm_scale_set_name | text | VM scale set name |
vm_size | text | VM size |
zone | text | Availability zone of the VM |
See in which Azure location a VM is located
SELECT location FROM azure_instance_metadata;