Jira Service Management Support

The data collected from Azure is assembled and imported into Assets. The Object Schema Tree looks like this in Assets:

Available selectors

Below you can see a list of available selectors. The selectors are sorted alphabetically. Too see a table of available attributes for each selector, select its name.

Some selectors depend on other selectors. For example:

when dealing with TAGS, the system doesn't retrieve every tag. It only collects tags associated with the resources being imported, based on the enabled selectors.
if you configure an import to include CONTAINER_ENVIRONMENT_VARIABLE, you need also to configure the CONTAINER_INSTANCE selector, otherwise you won't receive any container environment variables.

For details about the selector dependency, see the Required selectors column. If no selector is specified, there is no dependency.

Name	Description	Required selectors
APP_SERVICE	Get all App Services
APP_SERVICE_PLAN	Get all App Service Plans
AUTHORIZATION_RULE	Get all Authorization Rules
AUTOMATIC_TUNING	Get all Automatic Tuning
AUTOMATIC_TUNING_OPTION	Get all Automatic Tuning Options
AVAILABILITY_SET	Get all Availability Set
CERTIFICATE	Get all Certificates
CLIENT_SECRET	Gets Client Secrets for Enterprise Applications	ENTERPRISE_APPLICATIONS
CONTAINER_ENVIRONMENT_VARIABLE	Get Container Environment Variables for Container Instances	CONTAINER_INSTANCE
CONTAINER_GROUP	Get all Container Groups
CONTAINER_INSTANCE	Gets Container Instances for Container Groups	CONTAINER_GROUP
CONTAINER_REGISTRY	Get all Container Registries
CONTAINER_VOLUME_MOUNT	Gets Container Volume Mounts for Container Instances	CONTAINER_INSTANCE
DEVICE	Get all Devices
DISK	Get all Disks
ENCRYPTION_STATUS	Get all Encryption Statuses
ENTERPRISE_APPLICATION	Get all Enterprise Applications
EXTENSION	Get Extensions for Virtual Machine Scale Sets and Virtual Machines	VIRTUAL_MACHINE_SCALE_SET VIRTUAL_MACHINE
FIREWALL_RULE	Gets Firewall Rules for SQL Servers and Redis Caches	SQL_SERVER REDIS_CACHE
GROUP	Get all Groups
INBOUND_NAT_POOL	Get Inbound Nat Pools for Virtual Machine Scale Sets	VIRTUAL_MACHINE_SCALE_SET
IP_CONFIGURATION	Get all IP Configurations
LOAD_BALANCER	Get all Load Balancers
LOCK	Get all Locks
MANAGED_DEVICE	Get all Managed Devices
NETWORK_INTERFACE	Get all Network Interfaces
NETWORK_PEERING	Get all Network Peering
NETWORK_SECURITY_GROUP	Get all Network Security Groups
PUBLIC_IP_ADDRESS	Get all Public IP Addresses
QUEUE	Get all Queues
REDIS_CACHE	Get all Redis Cache
REGION	Get Regions for Resource Groups, Virtual Machines, Virtual Networks, Public IP Addresses, Load Balancers, Network Peerings, Route Tables, Disks, Snapshots, Storage Accounts, Virtual Network Gateways, VNG Connections, SQL Servers, SQL Databases, Threat Detection Policies, Firewall Rules, Service Endpoints, Availability Sets, App Service Plans, App Services, Certificates, Redis Cache, Virtual Machine Scale Sets	RESOURCE_GROUPS VIRTUAL_MACHINES VIRTUAL_NETWORKS PUBLIC_IP_ADDRESSES LOAD_BALANCERS NETWORK_PEERINGS ROUTE_TABLES DISKS SNAPSHOTS STORAGE_ACCOUNTS VIRTUAL_NETWORK_GATEWAYS VNG_CONNECTIONS SQL_SERVERS SQL_DATABASES THREAT_DETECTION_POLICIES FIREWALL_RULES SERVICE_ENDPOINTS AVAILABILITY_SETS APP_SERVICE_PLANS APP_SERVICES CERTIFICATES REDIS_CACHE VIRTUAL_MACHINE_SCALE_SETS
REPLICATION_LINK	Get all Replication Link
RESOURCE_GROUP	Get all Resource Groups
ROUTE	Get all Routes
ROUTE_TABLE	Get all Route Tables
SECURITY_RULE	Get all Security Rules
SERVICE_BUS	Get all Service Buses
SERVICE_ENDPOINT	Get all Service Endpoints
SNAPSHOT	Get all Snapshots
SQL_DATABASE	Get all SQL Databases
SQL_SERVER	Get all SQL Servers
STORAGE_ACCOUNT	Get all Storage Accounts
SUBNET	Get all Subnets
SUBSCRIPTION	Get all Subscription
TAG	Get Tags for all imported objects	Requires any other selectors
THREAT_DETECTION_POLICY	Get all Threat Detection Policies
TOPIC	Get all Topics
USER	Get all Users
VIRTUAL_MACHINE	Get all Virtual Machines
VIRTUAL_MACHINE_SCALE_SET	Get all Virtual Machine Scale Sets
VIRTUAL_NETWORK	Get all Virtual Networks
VIRTUAL_NETWORK_GATEWAY	Get all Virtual Network Gateways
VM_SCALE_SET_DATA_DISK	Gets VM Scale Set Data Disks for Virtual Machine Scale Sets	VIRTUAL_MACHINE_SCALE_SET
VM_SCALE_SET_OS_IMAGE	Gets VM Scale Set OS Images for Virtual Machine Scale Sets	VIRTUAL_MACHINE_SCALE_SET
VNG_CONNECTION	Get all VNG Connections

Below you can find selector details. The tables are listed in the same order as in Jira Service Management after a successful import.

Resource Group

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Region	Object - Region	Reference to the Region	"Name" = ${Region}
Subscription	Object - Subscription	Reference to the Subscription	"Id" = ${Subscription}
Tags	Object - Tag	List of Tag references assigned	"Id" IN (${Tags${0}})
Lock	Object - Lock	Reference to the associated Lock	"Reference Id" = ${Lock}

Subscription

Attribute	Default Type	Description
Status	STATUS	The status
Id	TEXT	The id
Name	TEXT	The name
Location Placement	TEXT	The location placement id
Quota	TEXT	The quota id
Spending Limit	TEXT	The spending limit

Tag

Attribute	Default Type	Description
Id	TEXT	The id
Name	TEXT	The name
Tag Name	TEXT	The tag name
Value	TEXT	The value

Region

Attribute	Default Type	Default Identifier	Unique	Description	AQL
Name	TEXT			The name
Description	TEXT			The description

Lock

Attribute	Default Type	Description
Id	TEXT	The id
Name	TEXT	The name
Lock Level	TEXT	The lock level
Notes	TEXT	The notes
Reference Id	TEXT	The id of the locked resource

Extension

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	Object reference to associated Subscription	"Id" = ${Subscription}
Publisher	TEXT	The publisher name
Version	TEXT	The version name
Type Name	TEXT	The type name

User

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	Object reference to associated Subscription	"Id" = ${Subscription}
Account enabled	BOOLEAN	Whether the user account is enabled or disable
User created date	DATE_TIME	When the user was created
User Type	TEXT	The user type
First name	TEXT	The given name
Last name	TEXT	The user’s surname (family name or last name)
Principal Name	TEXT	The user principle name (UPN)
Mail	TEXT	The users primary email address
Mail Nickname	TEXT	The users email alias
Sign in name	TEXT	The user principle name (UPN). (Yes, currently we duplicate the UPN here instead of using the signOnName property. Whether these can possibly be different is not evident from the API documentation)
Location	TEXT	The users usage location
Company name	TEXT	The users company name
Job title	TEXT	The users job title
Department	TEXT	The department in which the user works
Office	TEXT	The office location in the users place of business
Street address	TEXT	The street address of the users place of business
Country	TEXT	The users country/region of residence.
Postal code	TEXT	The postal code for the users postal address
Telephone number	TEXT	The primary telephone number for the users place of business
Mobile	TEXT	The users primary mobile number
Manager	Object - User	Object reference to the users manager	"Id" = ${Manager}

Group

Attribute	Default Type	Description	AQL
Id	TEXT	The group id
Name	TEXT	The group name
Type	TEXT	The group type
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Description	TEXT	The group description
Security enabled	BOOLEAN	Whether the group can be used for permissions/security
Mail enabled	BOOLEAN	Whether the group has mail enabled
Mail	TEXT	The primary email address for the group
Mail Nickname	TEXT	The groups email alias
Users	Object - User	Object references to the users in the group	"Id" IN (${Users${0}})
Enterprise Applications	Object - Enterprise Application	Reference to Enterprise Application objects that are members of this group	"Name" IN (${Enterprise Applications${0}})
Groups	Object - Group	Object references to the list of groups that are members of this group	"Id" IN (${Groups${0}})

Enterprise Application

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	The object reference to the associated Subscription	"Id" = ${Subscription}
Application Id	TEXT	The application id
Homepage	URL	The sign on URL
Client Secrets	Object - Client Secret	An object reference to the associated client secrets	"Id" IN (${Client Secrets${0}})

Client Secret

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	The object reference to the associated Subscription	"Id" = ${Subscription}
Start Date	DATE_TIME	When the secret became/becomes valid
End Date	DATE_TIME	When the secret expires

Virtual Machine

Attribute	Default Type	Description	AQL
Status	STATUS	The status
Id	TEXT	The Id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the VM belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the VM belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object references to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to an associated Lock	"Reference Id" = ${Lock}
Size	TEXT	The size of the Virtual Machine
VM Id	TEXT	The Virtual Machines unique id
Computer Name	TEXT	The name of the Virtual Machine
Provisioning	TEXT	The Virtual Machines provisioning state
Boot Diagnostics Enabled	BOOLEAN	Whether boot diagnostics are enabled
Boot Diagnostics Storage Uri	TEXT	The storage blob endpoint URI if boot diagnostics is enabled
Managed Disk Enabled	BOOLEAN	Whether managed disks are used for the Virtual Machines disks
Managed Service Identity Enabled	BOOLEAN	Whether managed service identity is enabled
Managed Service Identity Type	TEXT	The managed service identity type
License Type	TEXT	The licence type
Admin Username	TEXT	The Virtual Machines administrator username
Hostname	TEXT	The host OS name of the virtual machine
Time Zone	TEXT	The Virtual Machines time zone
Agent Version	TEXT	The Virtual Machines agent version
Disable Password Authentication	BOOLEAN	Whether password authentication is enabled or disabled
Provision VM Agent	BOOLEAN	Whether virtual machine agent is provisioned on the Virtual Machine
Enable Automatic Updates	BOOLEAN	Whether automatic updates are enabled or disabled
Public IP Address	Object - Public IP Address	Object reference to the Virtual Machines Public IP Address	"Id" = ${Public IP Address}
OS Disk Caching Type	TEXT	The OS Disk Caching Type
OS Type	TEXT	The OS Type
OS Disk	Object - Disk	The Objec	"Id" = ${OS Disk}
Data Disks	Object - Disk	Object references to the Virtual Machines Data Disks	"Id" IN (${Data Disks${0}})
Extension	Object - Extension	Object reference to the Virtual Machines Exetnsion	"Id" IN (${Extension${0}})

Virtual Machine Scale Set

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the VMSS belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the VMSS belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object references to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Capacity	INTEGER	The number of virtual machine instances in the VMSS
Overprovision	BOOLEAN	Whether Overprovisioning is enabled or disabled
Virtual Machine Eviction Policy	TEXT	The VMSS eviction policy
Virtual Machine Priority	TEXT	The VMSS priority type
Computer Name Prefix	TEXT	The VMSS computer name prefix
Boot Diagnostics Enabled	BOOLEAN	Whether boot diagnostics are enabled or disabled
Boot Diagnostics Storage Uri	TEXT	The storage blob endpoint URI if boot diagnostics is enabled for the VMSS
Managed Disk Enabled	BOOLEAN	Whether managed disk is used for the VMSS disks
Managed Service Identity Enabled	BOOLEAN	Whether managed service identity is enabled or disabled
Single Placement Group Enabled	BOOLEAN	Bug. Not used. This value is actually Managed Service Identity attribute
Managed Service Identity	TEXT	Whether managed service identity is enabled or disabled
SKU	TEXTAREA	The SKU of the Virtual Machines in the VMSS
Managed OS Disk Storage Account Type	TEXT	The storage account type of the OS managed disk, null if based on unmanaged disk
OS Disk Name	TEXT	The name of the OS disk of Virtual Machines in the VMSS
OS Disk Caching Type	TEXT	The OS disk caching type
OS Type	TEXT	The OS if the Virtual machines in the VMSS
OS Disk Image Location	TEXT	The virtual hard disk URI
OS Disk Create Option	TEXT	How the Virtual Machines in the VMSS should be created
Upgrade Mode	TEXT	The upgrade mode
Image Reference	Object - VM Scale Set OS Image	Object reference toe the associated Image Reference	"Id" IN (${Image Reference${0}})
Data Disks	Object - VM Scale Set Data Disk	Object references to the associated Data Disks	"Id" IN (${Data Disks${0}})
Extension	Object - Extension	Object reference to the VMSS extension	"Id" IN (${Extension${0}})
Vhd Containers	TEXTAREA	The container urls used to store operating system disks
Primary Network	Object - Virtual Network	Object reference to the VMSS Primary Network	"Id" IN (${Primary Network${0}})
Accelerated Networking Enabled	BOOLEAN	Whether accelerated networking is enabled or disabled
IP Forwarding Enabled	BOOLEAN	Whether IP forwarding is enabled or disabled
Network Interfaces	Object - Network Interface	Object references to associated Network Interfaces	"Id" IN (${Network Interfaces${0}})
Network Security Group	Object - Network Security Group	Object references to associated Network Security Groups	"Id" IN (${Network Security Group${0}})
Public IP Addresses	Object - Public IP Address	Object references to the VMSS Public IP Addresses	"Id" IN (${Public IP Addresses${0}})
Primary Internal Load Balancer	Object - Load Balancer	Object reference to VMSS Primary Internal Load Balancer	"Id" IN (${Primary Internal Load Balancer${0}})
Primary Internet Facing LoadBalancer	Object - Load Balancer	Object reference to the VMSS Primary Internet Facing LoadBalancer	"Id" IN (${Primary Internet Facing LoadBalancer${0}})
Primary Internet Facing LoadBalancer Inbound Nat Pools	Object - Inbound Nat Pool	Object references to VMSS Primary Internet Facing LoadBalancer Inbound Nat Pools	"Id" IN (${Primary Internet Facing LoadBalancer Inbound Nat Pools${0}})
Primary Internal LoadBalancer Inbound Nat Pools	Object - Inbound Nat Pool	Object references to VMSS Primary Internal LoadBalancer Inbound Nat Pools	"Id" IN (${Primary Internal LoadBalancer Inbound Nat Pools${0}})
Backend Internal Loadbalancer Virtual Machines	Object - Virtual Machine	Object references to VMSS Backend Internal Loadbalancer Virtual Machines	"Id" IN (${Backend Internal Loadbalancer Virtual Machines${0}})
Backend Internet facing Loadbalancer Virtual Machines	Object - Virtual Machine	Object references to VMSS Backend Internet facing Loadbalancer Virtual machines	"Id" IN (${Backend Internet facing Loadbalancer Virtual Machines${0}})

VM Scale Set Data Disk

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Data Disk Create Option	TEXT	The data disk create option
Storage Type	TEXT	The storage account type for the managed disk
Caching Type	TEXT	The caching requirements
Data Disk Lun	INTEGER	The logical unity number (LUN) of the data disk
Disk Size in GB	INTEGER	The size of the disk
Write Accelerator Enabled	BOOLEAN	Whether the disk has write accelerator enabled or disabled

VM Scale Set OS Image

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Offer	TEXT	The offer of the platform image or marketplace image
SKU	TEXT	The SKU
Publisher	TEXT	The publisher
Version	TEXT	The version of the platform image or marketplace image

Disk

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Disk belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Disk belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Creation Method	TEXT	The creation method
OS Type	TEXT	The type of the Operating System on the disk
Size	INTEGER	The disk size in GB
Virtual Machine	Object - Virtual Machine	Object reference to the Virtual Machine the Disk belongs to	"Id" = ${Virtual Machine}
SKU Type	TEXT	The disk SKU
Source Type	TEXT	The type of the source from which the disk was created
Snapshot	Object - Snapshot	Object reference to the associated Snapshot	"Id" = ${Snapshot}

Snapshot

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Snapshot belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Snapshot belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Creation Method	TEXT	The creation method
OS Type	TEXT	The OS type
Size	INTEGER	The size in GB
SKU Type	TEXT	The SKU type
Source Type	TEXT	The source type
Disk	Object - Disk	Object reference to the associated Disk	"Id" = ${Disk}

Availability set

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Availability set belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Availability set belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
SKU Type	TEXT	The SKU type
Fault domains	INTEGER	The fault domain count
Update domains	INTEGER	The update domain count
Virtual Machines	Object - Virtual Machine	Object references to the associated Virtual Machines	"Id" IN (${Virtual Machines${0}})

Redis Cache

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Redis Cache belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Redis Cache belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Provisioning	TEXT	The provisioning state
Premium Enabled	BOOLEAN	Whether the Redis Cache instance has Premium Sku
Shared Count	INTEGER	The shard count (attribute name has a typo)
Redis Version	TEXT	The Redis version
Redis Configurations	TEXTAREA	The Redis configuration
Hostname	TEXT	The hostname
Port	INTEGER	The port
Minimum TLS Version	TEXT	The minimum TLS version that clients require to use
Using Non-SSL Port	BOOLEAN	Whether the Redis Cache is using a Non-SSL Port
SSL Port	INTEGER	The SSL Port
Subnet	Object - Subnet	Object reference to the Subnet the Redis Cache belongs to	"Id" IN (${Subnet${0}})
Firewall Rules	Object - Firewall Rule	Object references to associated Firewall Rules	"Id" IN (${Firewall Rules${0}})
SKU	TEXTAREA	The SKU
Linked Servers	Object - Redis Cache	Object references to associated Linked Servers	"Id" IN (${Linked Servers${0}})
Patch Schedules	TEXTAREA	The patch schedules

Storage Account

Attribute	Default Type	Description	AQL
Type	TEXT	The type
SKU Type	TEXT	The SKU type
Creation Time	DATE_TIME	The creation time
last Geo Failover	DATE_TIME	When the most recent instance of a failover to the secondary location occurred.
Primary Account Status	STATUS	The primary account status
Secondary Account Status	STATUS	The secondary account status
Provisioning	STATUS	The provisioning state
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Storage Account belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Storage Account belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Access Tier	TEXT	The access tier used for billing
Access from Azure Services	BOOLEAN	Whether the Storage Account can be accessed from applications running on Azure
Read Log Entries from any Network	BOOLEAN	Whether storage log entries can be read from any network
Read Metrics from any Network	BOOLEAN	Whether storage metrics can be read from any network.
Access allowed from all networks	BOOLEAN	Whether authenticated applications from any network is allowed to access the storage account (true), or if only applications from whitelisted networks can access the storage account (false).
Custom Domain	TEXT	The user assigned custom domain assigned to this Storage Account
Encryption Key Source	TEXT	The source of the key used for encryption
End Points	TEXTAREA	The URLs that are used to perform a retrieval of a public blob, queue, or table object.
IP Addresses with access	TEXTAREA	A list of IP addresses that have access to the Storage Account
Subnets with access	Object - Subnet	Object references to Subnets that have access to the Storage Account	"Id" IN (${Subnet${0}})

Encryption Status

Attribute	Default Type	Description	AQL
Name	TEXT	The name
enabled	BOOLEAN	Whether encryption is enabled for the service.
last enabled	DATE_TIME	Rough estimate of when the encryption was last enabled. Null if disabled.
Storage Account	Object - Storage Account	Object reference to the Storage Account the Encryption Status is associated with.	"Id" = ${Storage Account}

Virtual Network

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Virtual Network belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Virtual Network belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Address Spaces	TEXT	List of address spaces associated with this Virtual Network, in the CIDR notation
DNS Server	TEXT	List of DNS server IP addresses associated with this Virtual Network
Subnets	Object - Subnet	Object references to the Subnets associated with this network	"Reference Id" IN (${Subnet${0}})

Subnet

Attribute	Default Type	Description	AQL
Name	TEXT	The name
Id	TEXT	The id
Address Prefix	TEXT	The address space prefix, in CIDR notation
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Virtual Network	Object - Virtual Network	Object reference to the Virtual Network the Subnet belongs to	"Id" = ${Virtual Network}
Network Security Group	Object - Network Security Group	Object Reference to the associated Network Security Group	"Id" = ${Network Security Group}
Route Table	Object - Route Table	Object Reference to the associated Route Table	"Id" = ${Route Table}

Service Endpoint

Attribute	Default Type	Description	AQL
Type	TEXT	The type
Subnet	Object - Subnet	Object reference to the associated Subnet	"Name" = ${Subnet}
Regions	Object - Region	Object references to the associated Regions	"Name" IN (${Regions${0}})
Subscription	Object - Subscription	Object references to the associated Subscription	"Id" = ${Subscription}

Network Peering

Attribute	Default Type	Description	AQL
Status	STATUS	The status
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Network Peering belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Network Peering belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Virtual Network	Object - Virtual Network	Object reference to the associated Virtual Network	"Id" = ${Virtual Network}
Remote Virtual Network	Object - Virtual Network	Object reference to the associated Remote Virtual Network	"Id" = ${Remote Virtual Network}
Gateway Use	TEXT	The type of gateway use enabled for this network
Access between Networks	BOOLEAN	Whether the peering enables IP addresses within the peered networks to be accessible from both networks
Same Subscription	BOOLEAN	Whether the peered networks are in the same subscription
Traffic Forwarding from Remote Network allowed	BOOLEAN	Whether traffic forwarding from the remote network is allowed into this network

Virtual Network Gateway

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Virtual Network Gateway belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Virtual Network Gateway belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Gateway Type	TEXT	The gateway type
VPN Type	TEXT	The type of this Virtual Network Gateway
IP Configurations	Object - IP Configuration	Object reference to associated IP configurations	"Name" IN (${IP Configurations${0}})
Active Active	BOOLEAN	activeActive flag
BGP Enabled	BOOLEAN	Whether BGP is enabled or disabled
BGP ASN	TEXT	The BGP speakers ASN
Peer Weight	INTEGER	The weight added to routes learned from the Virtual Network Gateways BGP speaker.
BGP Peering Address	TEXT	The Virtual Network Gateways BGP peering address and BGP identifier
SKU Name	TEXT	The Virtual Network Gateways SKU name
SKU Tier	TEXT	The Virtual Network Gateways SKU tier
SKU Capacity	INTEGER	The Virtual Network Gateways SKU Capacity

VNG Connection

Attribute	Default Type	Description	AQL
Connection Status	STATUS	The connection status
Provisioning	TEXT	The provisioning state
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the VNG Connection belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the VNG Connection belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Connection Type	TEXT	The connection type
Authorization Key	TEXT	The authorization key
Source Network Gateway	Object - Virtual Network Gateway	Object reference to the source Network Gateway	"Id" = ${Source Network Gateway}
Destination Network Gateway	Object - Virtual Network Gateway	Object reference to the destination Network Gateway	"Id" = ${Destination Network Gateway}
Egress Bytes Transferred	INTEGER	The egress bytes transferred in this connection
Ingress Bytes Transferred	INTEGER	The ingress bytes transferred in this connection
BGP Enabled	BOOLEAN	Whether BGP is enabled or disabled
Routing Weight	INTEGER	The routing weight
Shared Key	TEXT	The IPSec shared key
Use Policy Based Traffic Selectors	BOOLEAN	Whether policy-based traffic selectors are enabled or disabled

Load Balancer

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Load Balancer belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Load Balancer belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
SKU Type	TEXT	The SKU

Network Security Group

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Network Security Group belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Network Security Group belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}

Security Rule

Attribute	Default Type	Description	AQL
Priority	INTEGER	The priority number of this rule based on which this rule will be applied relative to the priority numbers of any other rules specified for the network security group
Name	TEXT	The name
Direction	TEXT	The direction of the network traffic the Security Rule applies to
Protocol	TEXT	The network protocol the Security Rule applies to
Access	TEXT	The type of access the rule enforces
Description	TEXT	The description
Source Address Prefix	TEXT	The list of source address prefixes the Security Rule applies to, expressed using the CIDR notation
Source Port Range	TEXT	The source port range that the Security Rule applies to
Destination Address Prefix	TEXT	The destination address prefix the Security Rule applies to, expressed using the CIDR notation
Destination Port Range	TEXT	The destination port range that the Security Rule applies to
Network Security Groups	Object - Network Security Group	Object references to the associated Network Security Groups	"Id" IN (${Network Security Group${0}})

Firewall Rule

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Firewall Rule belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Firewall Rule belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Start IP Address	TEXT	The start IP address
End IP Address	TEXT	The end IP address

Route Table

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Route Table belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Route Table belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}

Route

Attribute	Default Type	Description	AQL
Name	TEXT	The name
Destination Address Prefix	TEXT	The destination address prefix expressed using the CIDR notation to which the Route applies
Next Hop Type	TEXT	The type of the next hop
Next Hop IP Address	TEXT	The IP address of the next hop
Route Table	Object - Route Table	Object reference to the associated Route Table	"Id" IN (${Route Table${0}})

Network Interface

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Network Interface belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Network Interface belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
DNS Name	TEXT	The internal DNS name assigned to this Network Interface
Domain Suffix	TEXT	The internal domain name suffix
FQDN	TEXT	The fully qualified domain name of this Network Interface
DNS Server	TEXT	List of IP addresses of this Network Interfaces DNS servers, separated by ;
Accelerated Networking Enabled	BOOLEAN	Whether accelerated networking is enabled or disabled
IP Forwarding Enabled	BOOLEAN	Whether IP forwarding is enabled or disabled
MAC Address	TEXT	The MAC Address
Primary Private IP	TEXT	The private IP address allocated to this Network Interfaces primary IP configuration
Primary Private IP Allocation Method	TEXT	The private IP allocation method of this Network Interfaces primary IP configuration
Virtual Machine	Object - Virtual Machine	Object reference to the associated Virtual Machine	"Id" = ${Virtual Machine}
Virtual Network	Object - Virtual Network	Object reference to the associated Virtual Network	"Id" = ${Virtual Network}
Network Security Group	Object - Network Security Group	Object reference to the associated Network Security Group	"Id" = ${Network Security Group}

IP Configuration

Attribute	Default Type	Description	AQL
Name	TEXT	The name
Primary Private IP	TEXT	The private IP address
Primary	BOOLEAN	Whether this is the primary IP configuration
IP Allocation Method	TEXT	The private IP address allocation method
IP Address Version	TEXT	The private IP address version
Public IP Address	Object - Public IP Address	Object reference to the associated Public IP Address	"Id" = ${Public IP Address}
Network Interface	Object - Network Interface	Object reference to the associated Network Interface	"Id" = ${Network Interface}
Virtual Network	Object - Virtual Network	Object reference to the associated Virtual Network	"Id" = ${Virtual Network}
Subnet	Object - Subnet	Object reference to the associated Subnet	"Name" = ${Subnet}

Public IP Address

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Public IP Address belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Public IP Address belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
FQDN	TEXT	The assigned fully qualified domain name
Idle Timeout	INTEGER	The idle connection timeout setting in minutes
IP Address	TEXT	The assigned ip address
IP Address Version	TEXT	The IP version of the public IP address
IP Allocation Method	TEXT	The IP address allocation method
Leaf Domain	TEXT	The assigned leaf domain label
Reverse FQDN	TEXT	The assigned reverse fully qualified domain name
SKU Type	TEXT	The public IP address SKU
Network Interface	Object - Network Interface	Object reference to the associated Network Interface	"Id" = ${Network Interface}

Inbound Nat Pool

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Protocol	TEXT	The protocol used by the Inbound Nat Pool
Backend Port	INTEGER	The port used for internal connection on the endpoint
Frontend Port Range Start	INTEGER	The first number in the range of external ports that will be used to provide Inbound Nat
Frontend Port Range End	INTEGER	The last port number in the range of external ports that will be used to provide Inbound Nat

Sql Server

Attribute	Default Type	Description	AQL
Status	TEXT	The state of the server
FQDN	TEXT	The fully qualified domain name
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the SQL Server belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the SQL Server belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Version	TEXT	The SQL Server version
Sql Databases	Object - Sql Database	Object references to SQL Databases on this SQL Server	"Id" IN (${Sql Databases${0}})
Managed Service Identity	BOOLEAN	Whether managed service identity is enabled or disabled
Automatic Tuning	Object - Automatic Tuning	Object reference to the associated Automatic Tuning	"Id" = ${Automatic Tuning}
Sql Firewall Rules	Object - Firewall Rule	Object references to the associated Firewall Rules	"Id" IN (${Sql Firewall Rules${0}})

Sql Database

Attribute	Default Type	Description	AQL
Status	TEXT	The status
Database Id	TEXT	The id of the SQL Database
Geo Id	TEXT	An MD5 hash of the database name and SQL Server name
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Sql Database belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Sql Database belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Creation Time	DATE_TIME	The creation date
Earliest Restore Date	DATE_TIME	The recover period start date from which recovery is available
Collation	TEXT	The collation
Edition	TEXT	The edition
Service Level	TEXT	The service level objective
Secondary Location	Object - Region	Object reference to the default secondary location Region	"Description" = ${Secondary Location}
Data Warehouse	BOOLEAN	Whether this Sql Database is an SQL Warehouse
Size	INTEGER	The max size in GB
Transparent Data Encryption State	STATUS	The status of the Transparent Data Encryption
Replication Role	TEXT	The name of the role for the last Replication Link
Automatic Tuning	Object - Automatic Tuning	Object reference to the associated Automatic Tuning	"Id" = ${Automatic Tuning}
Threat Detection Policy	Object - Threat Detection Policy	Object reference to the associated Threat Detection Policy	"Id" = ${Threat Detection Policy}
Replication Links	Object - Replication Link	Object references to the associated Replication Links	"Id" IN (${Replication Links${0}})

Threat Detection Policy

Attribute	Default Type	Description	AQL
Status	STATUS	The state of the Threat Detection Policy
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Threat Detection Policy belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Threat Detection Policy belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Disabled Alerts	TEXTAREA	The semicolon-separate list of alerts that are disabled
EMail Account Admins	BOOLEAN	Whether the alert is sent to the account administrators
EMail Addresses	TEXTAREA	The semicolon-separated list of email addresses to which the alert is sent
Default Security Alert Policy	BOOLEAN	Whether the Threat Detection Policy is using the default server policy
Retention Days	INTEGER	The number of days to keep in the Threat Detection Policy audit logs
Storage Account Access Key	TEXTAREA	The identifier key of the Threat Detection Policy audit storage account
Storage Endpoint	TEXTAREA	The blob storage endpoint
Storage Endpoint	TEXTAREA	Duplicate attribute

Replication Link

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Replication Link belongs to	"Name" = ${Resource Group}
Subscription	Object - Subscription	The object reference to the associated Subscription	"Id" = ${Subscription}
Lock	Object - Lock	The object reference to the associated Lock	"Reference Id" = ${Lock}
Termination Allowed	BOOLEAN	The legacy value indicating whether termination is allowed
Replication State	STATUS	The replication state
Replication Mode	TEXT	The replication mode
Start Time	DATE_TIME	The start time
Percent Complete	INTEGER	The percentage of the seeding completed
Replication Databases	Object - Sql Database	Object references to the associated Replication Databases	"Geo Id" IN (${Replication Databases${0}})

Automatic Tuning

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Actual State	TEXT	The actual state
Desired State	TEXT	The desired state
Automatic Tuning Options	Object - Automatic Tuning Option	Object reference to the associated Automatic Tuning Options	"Id" IN (${Automatic Tuning Options${0}})
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}

Automatic Tuning Option

Attribute	Default Type	Description
Id	TEXT	The id
Name	TEXT	The name
Actual State	TEXT	The actual state
Desired State	TEXT	The desired state

App Service plan

Attribute	Default Type	Description	AQL
Status	STATUS	The status
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the App Service plan belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the App Service plan belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Capacity	INTEGER	The maximum number of instances that can be assigned
Max Instances	INTEGER	The maximum number of instances that can be assigned
Number of WebApps	INTEGER	The number of web apps assigned to this App Service plan
Per Site scaling	BOOLEAN	Whether apps assigned to this App Service plan can be independently scaled
Pricing Tier	TEXT	The pricing tier
Operating System	TEXT	The operating system the web app is running on

App Service

Attribute	Default Type	Description	AQL
Status	TEXT	The status
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the App Service belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the App Service belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Default Hostname	TEXT	The default hostname of the web app
enabled	BOOLEAN	Whether the site is enabled or disabled
App Service plan	Object - App Service plan	Object reference to the associated App Service plan	"Id" = ${App Service plan}
SCM Type	TEXT	The SCM configuration for the web app
SCM stopped	BOOLEAN	Whether to stop SCM (KUDU) site when the web app is stopped
Operating System	TEXT	The operating system the web app is running on
Platform Architecture	TEXT	The architecture of the platform
Repository Sitename	TEXT	The name of the repository site
Usage State	TEXT	The state indicating whether the web app has exceeded its quota usage
Site Availability State	TEXT	The management information availability state for the weba pp
FTPS State	TEXT	The state of FTP FTPS service
Client Affinity enabled	BOOLEAN	Whether client affinity is enabled or disabled for load balancing http requests for multiple instances of the web app
Client Certificate enabled	BOOLEAN	Whether the client certificate is enabled or disabled
Host Names disabled	BOOLEAN	Whether public hostnames are enabled or disabled for the web app
Outbound IP Addresses	TEXTAREA	List of IP addresses that this web app uses for outbound connections
Container size	INTEGER	The size of a function container
Default Container	BOOLEAN	Whether the site is a default container
Default Documents	TEXTAREA	The default documents
Java Container	TEXTAREA	The Java container
Dot Net Framework Version	TEXTAREA	The .NET framework version
PHP Version	TEXTAREA	The version of PHP
Python Version	TEXTAREA	The version of Python
Node Version	TEXTAREA	The version of NodeJS
Java Version	TEXTAREA	The version of Java
Java Container Version	TEXTAREA	The Java container version
Remote Debugging Version	TEXTAREA	The remote debugging version
Linux FX Version	TEXTAREA	The Linux app framework version if this is a Linux web app
Remote Debugging enabled	BOOLEAN	Whether remote debugging is enabled or disabled
Web Sockets enabled	BOOLEAN	Whether web sockets are enabled or disabled
Always On	BOOLEAN	Whether the web app is always on
HTTPS only	BOOLEAN	Whether the web app is configured to accept only HTTPS requests
HTTP 20 enabled	BOOLEAN	Whether to allow clients to connect over http2.0
Local MySql enabled	BOOLEAN	Whether local MySQL is enabled or disabled

Certificate

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Certificate belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Certificate belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Valid	BOOLEAN	Whether the certificate is valid or invalid
Friendly Name	TEXT	The friendly name
Subject Name	TEXT	The subject name
Site Name	TEXT	The app name
Host Names	TEXTAREA	The host names the Certificate applies to
Self Link	TEXT	The self link
Issuer	TEXT	The Certificate issuer
Issue Date	DATE_TIME	The issue date
Expiration Date	DATE_TIME	The expiration date
Thumbprint	TEXT	The Thumbprint
Public Key Hash	TEXT	The public key hash

Device

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Trust Type	TEXT	Type of trust for the joined device.
Profile Type	TEXT	The profile type of the device.
Device Version	INTEGER	The Device version
MDM App Id	TEXT	Application identifier used to register device into MDM.
System Labels	TEXTAREA	Labels applied to the device by the system.
Physical Ids	TEXTAREA	The physical ids
Operating System	TEXT	The type of operating system on the device.
Operating System Version	TEXT	The version of the operating system on the device.
Account enabled	BOOLEAN	Whether the account is enabled or disabled
Compliant	BOOLEAN	True if the device complies with Mobile Device Management (MDM) policies.
MDM managed	BOOLEAN	True if the device is managed by a Mobile Device Management (MDM) app.
On Premises sync enabled	BOOLEAN	True if this object is synced from an on-premises directory.
Approximate last sign in	DATE_TIME	The approximation of the last sign in time in UTC
Compliance expiration	DATE_TIME	The time when the device is no longer deemed compliant.
On Premises last sync	DATE_TIME	The last time at which the object was synced with the on-premises directory.
Groups	Object - Group	The groups that the device is a member of.	"Id" IN (${Groups${0}})
Registered Owners	Object - User	The users that cloud joined the device or registered their personal device.	"Id" IN (${Registered Owners${0}})
Registered Users	Object - User	Registered users of the device.	"Id" IN (${Registered Users${0}})

Managed Device

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Managed Device Name	TEXT	Automatically generated name to identify a device. Can be overwritten to a user friendly name.
Device Category	TEXT	Device category.
Owner Type	TEXT	Ownership of the device.
Model	TEXT	Model of the device.
Manufacturer	TEXT	Manufacturer of the device.
Serial Number	TEXT	Serialnumber of the device.
Phone Number	TEXT	Phone number of the device.
IMEI	TEXT	IMEI of the device.
MEID	TEXT	MEID of the device.
Wi-Fi MAC Address	TEXT	Wi-Fi MAC.
Subscriber Carrier	TEXT	Subscriber Carrier.
Operating System	TEXT	The type of operating system on the device.
Operating System Version	TEXT	The version of the operating system on the device.
Jail Broken	TEXT	Whether the device is jail broken or rooted.
Last sync	DATE_TIME	The date and time that the device last completed a successful sync with Intune.
Enrolled	DATE_TIME	Enrollment time of the device.
EAS activation	DATE_TIME	Exchange ActivationSync activation time of the device.
Exchange last successful sync	DATE_TIME	Last time the device contacted Exchange.
Compliance Grace Period Expiration	DATE_TIME	The DateTime when device compliance grace period expires.
Management Agent	TEXT	Management channel of the device.
Device Enrollment Type	TEXT	Enrollment type of the device.
Activation Lock Bypass Code	TEXT	Code that allows the Activation Lock on a device to be bypassed.
EMail Addresses	TEXT	Email(s) for the user associated with the device.
Device Registration State	TEXT	Device registration state.
Exchange Access State	TEXT	The Access State of the device in Exchange.
Exchange Access State Reason	TEXT	The reason for the device's access state in Exchange.
Android security patch level	TEXT	Android security patch level.
Partner Reported Health State	TEXT	Indicates the threat state of a device when a Mobile Threat Defense partner is in use by the account and device.
Remote Assistance Session Url	URL	Url that allows a Remote Assistance session to be established with the device.
Remote Assistance Session Error Detail	TEXT	An error string that identifies issues when creating Remote Assistance session objects.
EAS activated	BOOLEAN	Whether the device is Exchange ActiveSync activated.
AD registered	BOOLEAN	Whether the device is Microsoft Entra ID registered.
Supervised	BOOLEAN	Device supervised status.
Encrypted	BOOLEAN	Device encryption status.
Total Storage space	INTEGER	Total Storage of the device.
Free Storage space	INTEGER	Free Storage of the device.
User	Object - User	The user associated with the device.	"Id" = ${User}
Device	Object - Device	The Microsoft Entra ID device.	"Id" = ${Device}

Service Bus

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Service Bus belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Service Bus belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Creation Time	DATE_TIME	When the namespace was created
Update Time	DATE_TIME	When the namespace was last updated
FQDN	TEXT	Fully qualified domain name of the Service Bus namespace
DNS Name	TEXT	The relative DNS name of the Service Bus namespace
Authorization Rules	Object - Authorization Rule	The Authorization Rules that belongs to the Service Bus.	"Id" IN (${Authorization Rules${0}})
Topics	Object - Topic	The Topics that belongs to the Service Bus.	"Id" IN (${Topics${0}})
Queue	Object - Queue	The Queue that belongs to the Service Bus.	"Id" IN (${Queues${0}})

Authorization Rule

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Rights	TEXT	The rights associated with the Authorization Rule

Topic

Attribute	Default Type	Description	AQL
Status	STATUS	The current state of the Topic
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Creation Time	DATE_TIME	The exact time the Topic was created
Update Time	DATE_TIME	The exact time the Topic was updated
Access Time	DATE_TIME	The last time a message was sent, or the last time there was a receive request to this Topic
Max size	INTEGER	The maximum size of memory allocated for the Topic in megabytes
Current size	INTEGER	The current size of the Topic in megabytes
Batched Operations	BOOLEAN	Whether server-side batched operations are enabled or disabled
Express	BOOLEAN	Whether express entities are enabled or disabled
Partitioning	BOOLEAN	Whether the Topic is to be partitioned across multiple message brokers
Duplicate Detection	BOOLEAN	Whether duplicate detection is required
Delete on idle duration	INTEGER	The idle duration after which the Topic is automatically deleted in minutes
Default message TTL duration	TEXT	The duration after which the message expires, starting from when the message is sent to the Topic
Duplicate message detection history duration	TEXT	The duration of the duplicate detection history
Active message count	INTEGER	Number of active messages in the Topic
Transfer message count	INTEGER	Number of messages transferred to another Topic or Subscription
Dead letter message count	INTEGER	The number of messages in the dead-letter Topic
Transfer dead letter message count	INTEGER	The number of messages transferred into dead letters
Scheduled message count	INTEGER	The number of messages sent to the Topic that are yet to be released for consumption
Subscription count	INTEGER	The number of subscriptions for this Topic

Queue

Attribute	Default Type	Description	AQL
Status	STATUS	The current state of the Queue
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Creation Time	DATE_TIME	The exact time the Queue was created
Update Time	DATE_TIME	The exact time the Queue was updated
Access Time	DATE_TIME	The last time a message was sent, or the last time there was a receieverequest to this Queue
Max size	INTEGER	The maximum size of memory allocated for the Queue in megabytes
Current size	INTEGER	The current size of the Queue in megabytes
Batched Operations	BOOLEAN	Whether server-side batched operations are enabled or disabled
Express	BOOLEAN	Whether express entities are enabled or disabled
Partitioning	BOOLEAN	Whether the Queue is to be partitioned across multiple message brokers
Duplicate Detection	BOOLEAN	Whether the Queue required duplicate detection
Delete on idle duration	INTEGER	The idle duration after which the Queue is automatically deleted in minutes
Default message TTL duration	TEXT	The duration after which the message expires, starting from when the message is sent to the Queue
Duplicate message detection history duration	TEXT	The duration of the duplicate detection history
Active message count	INTEGER	Number of active messages in the Queue
Transfer message count	INTEGER	Number of messages transferred to another Queue, Topic, or Subscription
Dead letter message count	INTEGER	The number of messages in the dead-letter Queue
Transfer dead letter message count	INTEGER	The number of messages transferred into dead letters
Scheduled message count	INTEGER	The number of messages sent to the Queue that are yet to be released for consumption
Message count	INTEGER	The number of messages in the Queue
Max delivery count before dead lettering message	INTEGER	The maximum number of a message delivery before marking it as dead-lettered
Lock duration	INTEGER	The duration of peek-lock. which is the amount of time that the message is locked for other receivers, in seconds
Dead lettering enabled for expired messages	BOOLEAN	Whether the Queue has dead letter support when a message expires
Session	BOOLEAN	Whether sessions are supported

Container Registry

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Container Registry belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Container Registry belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
SKU Name	TEXT	The SKU of the Container Registry
SKU Tier	TEXT	The SKU tier of the SKU of the Container Registry
Creation Time	DATE	The creation date
Login Server Url	URL	The URL that can be used to log into the container registry
Admin User enabled	BOOLEAN	Whether the admin user is enabled or disabled
Storage Account	Object - Storage Account	The storage account associated with the container registry.	"Id" = ${Storage Account}

Container Group

Attribute	Default Type	Description	AQL
State	TEXT	The state of the Container Group
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Resource Group	Object - Resource Group	Object reference to the Resource Group the Container Group belongs to	"Name" = ${Resource Group}
Region	Object - Region	Object reference to the Region the Container Group belongs to	"Name" = ${Region}
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Tags	Object - Tag	Object References to the associated Tags	"Id" IN (${Tags${0}})
Lock	Object - Lock	Object reference to the associated Lock	"Reference Id" = ${Lock}
Provisioning	TEXT	The provisioning state
DNS Prefix	TEXT	The DNS prefix specified at creation time
FQDN	TEXT	The fully qualified domain name
IP Address	TEXT	The IP address
IP Address Public	BOOLEAN	Whether or not the IP address is public
OS Type	TEXT	The base level OS type required by the containers in the group
External TCP Ports	TEXT	The publicly exposed TCP ports
External UDP Ports	TEXT	The publicly exposed UDP ports
Volumes	TEXTAREA	The volumes
Image Registry Servers	TEXTAREA	The Docker image registry server by which the container group is created from
Container Instances	Object - Container Instance	The Container Instances that belongs to the Container Group.	"Id" IN (${Container Instances${0}})

Container Instance

Attribute	Default Type	Description	AQL
State	TEXT	The current Container Instance state
Previous State	TEXT	The previous Container Instance state
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Image	TEXT	The name of the image used to create the Container Instance
Commands	TEXTAREA	The commands to execute within the Container Instance in exec form
External TCP Ports	TEXT	The publicly exposed TCP ports
External UDP Ports	TEXT	The publicly exposed UDP ports
Restart Count	INTEGER	The number of times that the container instance has been restarted
MAX CPU Value	DOUBLE	The CPU limit of the Container Instance
Max Memory	DOUBLE	The memory limit of the Container Instance in GB
Environment Variables	Object - Environment Variable	The Environment Variables that belongs to the Container Instance.	"Id" IN (${Environment Variables${0}})
Volume Mounts	Object - Volume Mount	The Volume Mounts that belongs to the Container Instance.	"Id" IN (${Volume Mounts${0}})

Environment Variable

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Value	TEXT	The value
Secure Value	TEXT	The secure value

Volume Mount

Attribute	Default Type	Description	AQL
Id	TEXT	The id
Name	TEXT	The name
Type	TEXT	The type
Subscription	Object - Subscription	Object reference to the associated Subscription	"Id" = ${Subscription}
Mount Path	TEXT	The path within the container where the Volume Mount should be mounted
Read Only	BOOLEAN	Whether or not the Volume Mount is read-only

Page

Viewport

Confluence

Versions

Azure data imported into Assets

Assets - Azure Integration

On this page

Related content

Still need help?