Rule 3 - Mapping of Azure Resource Types to CMDB CI Classes

Rule Synopsis

These are the rule/s that determine the target CMDB CI Tables/Classes used by CI Sync for each Azure Resource Type.

The target CI Table/CI Class is used by CI Sync for two purposes:

To search for an existing CIs during a CI Update Operation.
To write new CIs during a CI Insert Operation.

Rule Details and Default

The default table mappings for Primary/Parent Resource Types are shown below.

Primary/Parent Resource Types	Default Target Class/Classes
General
Datacentres	cmdb_ci_azure_datacenter
Subscriptions	cmdb_ci_azure_subscription
Resource Groups	cmdb_ci_resource_group
Databases
CosmosDb for MongoDb	cmdb_ci_cloud_database
Database for MySQL	cmdb_ci_cloud_database
Database for PostgreSQL	cmdb_ci_cloud_database
SQL Server	cmdb_ci_db_mssql_server
SQL Server User Databases	cmdb_ci_db_mssql_database
SQL Server System Databases	cmdb_ci_db_mssql_database
SQL Server Elastic Pools	cmdb_ci_mssql_cluster
Networking
DNS Zones	cmdb_ci_dns_zone
Express Route Circuits	cmdb_ci_ni_logical_path
Express Route Gateway	cmdb_ci_virtual_pvt_gateway
Firewall	cmdb_ci_cmp_resource
Frontdoors	cmdb_ci_cloud_load_balancer
Load Balancers	cmdb_ci_cloud_load_balancer
Local Network Gateways	cmdb_ci_vpc_gateway_connection
NAT Gateways	cmdb_ci_nat_gateway
Network Security Group	cmdb_ci_compute_security_group
P2S VPN Gateways	cmdb_ci_virtual_pvt_gateway
Private DNS Zones	cmdb_ci_dns_zone
Private End Points	cmdb_ci_endpoint_vnic
Public IP Address	cmdb_ci_cloud_public_ipaddress
Virtual Hubs	cmdb_ci_cmp_resource
Virtual Networks	cmdb_ci_network
Virtual Network Gateways	cmdb_ci_virtual_pvt_gateway
Virtual WANs	cmdb_ci_network
VPN Gateways	cmdb_ci_virtual_pvt_gateway
Compute
Disks	cmdb_ci_diskcmdb_ci_disk
Images	cmdb_ci_os_template
Snapshots	cmdb_ci_storage_vol_snapshot
Arc Machines	cmdb_ci_cloud_system_management_agent
Virtual Machines (i.e. VM Instances)	cmdb_ci_vm_instance
Virtual Machine Scale Set	cmdb_ci_instance_scale_set
Storage
Storage Accounts	cmdb_ci_cloud_storage_account
Web
App Service	cmdb_ci_web_site
App Service Plan	cmdb_ci_cloud_webserver
CDN Profiles	cmdb_ci_cloud_webserver
Containers
Container Instances	cmdb_ci_docker_engine
Container Registries	cmdb_ci_container_repository
Kubernetes Services	cmdb_ci_cloud_appserver
Integration
Logic Apps	cmdb_ci_cmp_resource
Event Hubs	cmdb_ci_cmp_resource
Security
Application Gateways	cmdb_ci_cloud_load_balancer
Key Vaults	cmdb_ci_cmp_resource
DevOps
API Management Services	cmdb_ci_azure_api_mgmt
AI + Machine Learning
Cognitive Services	cmdb_ci_function_ai
Management and Governance
Recovery Services Vaults	cmdb_ci_cloud_storage_account

The default table mappings for Secondary/Child Records are shown below.

Secondary/Child Records	Default Target Class
Tags	cmdb_key_value
Databases (for PostgreSQL Databases)	cmdb_ci_postgresql_schema
Databases (for MySQL Databases)	cmdb_ci_db_mysql_catalog
A-Records (for DNS Zones)	cmdb_ci_dns_name
CNAME-Records (for DNS Zones)	cmdb_ci_dns_alias
Subnets (for Virtual Networks)	cmdb_ci_cloud_subnet
Network Interfaces (for Virtual Machines)	cmdb_ci_nic
Endpoints (for Storage Accounts)	cmdb_ci_endpoint_http
Endpoints (for CDN Profiles)	cmdb_ci_endpoint_http
Containers (for Container Instances)	cmdb_ci_docker_container
Backend IP Addresses (for Application Gateways)	cmdb_ci_cloud_ip_address
Routing Rules (for Application Gateways)	cmdb_ci_lb_service

Override Options

Context

Customers may consider changing these mappings to target different CMDB CI Tables/Classes shown above. This can often be required when existing CIs are already present in the CMDB (in Classes different to those shown below) and CI Sync is expected to correlate to the existing CIs.

Options

The target CI Class can be amended per Azure Resource Type.
The target Related List/Child Record table can be amended per Azure Resource Type.

Overriding via Connection Settings

Not Available - Requires a Custom Data Sync Rule (and therefore a Syncfish Support Plan to modify the default behaviour)

Additional Information

N/A