Back to source list
Official
Premium
Azure
The CloudQuery Azure source plugin extracts information from many of the supported services by Microsoft Azure and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v16.1.0
Type
Source
Platforms
Date Published
Price per 1M rows
Starting from $17
monthly free quota
1M rows
- azure_advisor_recommendation_metadata
- azure_advisor_recommendations
- azure_advisor_suppressions
- azure_analysisservices_servers
- azure_apimanagement_service
- azure_appcomplianceautomation_reports
- azure_appconfiguration_configuration_stores
- azure_applicationinsights_components
- azure_applicationinsights_web_tests
- azure_appservice_certificate_orders
- azure_appservice_certificates
- azure_appservice_deleted_web_apps
- azure_appservice_domains
- azure_appservice_environments
- azure_appservice_plans
- azure_appservice_recommendations
- azure_appservice_resource_health_metadata
- azure_appservice_static_sites
- azure_appservice_top_level_domains
- azure_appservice_web_apps
- azure_appservice_web_app_auth_settings
- azure_appservice_web_app_configurations
- azure_appservice_web_app_vnet_connections
- azure_authorization_classic_administrators
- azure_authorization_provider_operations_metadata
- azure_authorization_role_assignments
- azure_authorization_role_definitions
- azure_automation_account
- azure_azurearcdata_postgres_instances
- azure_azurearcdata_sql_managed_instances
- azure_azurearcdata_sql_server_instances
- azure_batch_account
- azure_billing_accounts
- azure_billing_enrollment_accounts
- azure_billing_periods
- azure_botservice_bots
- azure_cdn_edge_nodes
- azure_cdn_managed_rule_sets
- azure_cdn_profiles
- azure_cdn_endpoints
- azure_cdn_rule_sets
- azure_cdn_security_policies
- azure_cognitiveservices_accounts
- azure_cognitiveservices_account_skus
- azure_cognitiveservices_account_usages
- azure_cognitiveservices_account_models
- azure_cognitiveservices_account_deployments
- azure_cognitiveservices_account_private_endpoint_connections
- azure_cognitiveservices_account_private_link_resources
- azure_cognitiveservices_commitment_plans
- azure_cognitiveservices_deleted_accounts
- azure_cognitiveservices_resource_skus
- azure_compute_availability_sets
- azure_compute_capacity_reservation_groups
- azure_compute_capacity_reservations
- azure_compute_cloud_services
- azure_compute_disk_accesses
- azure_compute_disk_encryption_sets
- azure_compute_disks
- azure_compute_galleries
- azure_compute_gallery_images
- azure_compute_gallery_image_versions
- azure_compute_images
- azure_compute_restore_point_collections
- azure_compute_skus
- azure_compute_snapshots
- azure_compute_ssh_public_keys
- azure_compute_virtual_machines
- azure_compute_virtual_machine_extensions
- azure_compute_virtual_machine_patch_assessments
- azure_compute_virtual_machine_software_inventories
- azure_compute_virtual_machine_scale_sets
- azure_compute_virtual_machine_scale_set_vms
- azure_compute_virtual_machine_scale_set_network_interfaces
- azure_confidentialledger_ledgers
- azure_confidentialledger_operations
- azure_confluent_marketplace_agreements
- azure_connectedvmware_clusters
- azure_connectedvmware_datastores
- azure_connectedvmware_hosts
- azure_connectedvmware_resource_pools
- azure_connectedvmware_v_centers
- azure_connectedvmware_virtual_machines
- azure_connectedvmware_virtual_machine_templates
- azure_connectedvmware_virtual_networks
- azure_consumption_billing_account_balances
- azure_consumption_billing_account_budgets
- azure_consumption_billing_account_charges
- azure_consumption_billing_account_events
- azure_consumption_billing_account_legacy_usage_details
- azure_consumption_billing_account_lots
- azure_consumption_billing_account_marketplaces
- azure_consumption_billing_account_modern_usage_details
- azure_consumption_billing_account_reservation_recommendations
- azure_consumption_billing_account_tags
- azure_consumption_billing_profile_reservation_details
- azure_consumption_billing_profile_reservation_recommendations
- azure_consumption_billing_profile_reservation_summaries
- azure_consumption_billing_profile_reservation_transactions
- azure_consumption_subscription_budgets
- azure_consumption_subscription_legacy_usage_details
- azure_consumption_subscription_marketplaces
- azure_consumption_subscription_price_sheets
- azure_consumption_subscription_reservation_recommendations
- azure_consumption_subscription_tags
- azure_containerapps_connected_environments
- azure_containerapps_connected_environment_certificates
- azure_containerapps_connected_environment_dapr_components
- azure_containerapps_connected_environment_storages
- azure_containerapps_container_apps
- azure_containerapps_container_app_auth_configs
- azure_containerapps_container_app_detector_revisions
- container_app_diagnostics_detectors
- azure_containerapps_container_app_revisions
- azure_containerapps_container_app_revision_replicas
- container_app_source_controls
- azure_containerapps_jobs
- azure_containerapps_job_executions
- azure_containerapps_managed_environments
- azure_containerapps_managed_certificates
- azure_containerapps_managed_environment_certificates
- azure_containerapps_managed_environment_detectors
- azure_containerapps_managed_environment_storages
- azure_containerapps_managed_environment_usages
- azure_containerapps_operations
- azure_containerinstance_container_groups
- azure_containerregistry_registries
- azure_containerservice_managed_clusters
- azure_containerservice_managed_cluster_upgrade_profiles
- azure_containerservice_snapshots
- azure_cosmos_cassandra_clusters
- azure_cosmos_database_accounts
- azure_cosmos_mongo_db_databases
- azure_cosmos_sql_databases
- azure_cosmos_locations
- azure_cosmos_restorable_database_accounts
- azure_costmanagement_views
- azure_costmanagement_view_queries
- azure_customerinsights_hubs
- azure_dashboard_grafana
- azure_databox_jobs
- azure_databricks_access_connectors
- azure_databricks_operations
- azure_databricks_workspaces
- azure_databricks_outbound_network_dependencies_endpoints
- azure_databricks_private_endpoint_connections
- azure_databricks_private_link_resources
- azure_databricks_virtual_network_peerings
- azure_datacatalog_catalogs
- azure_datadog_marketplace_agreements
- azure_datadog_monitors
- azure_datafactory_factories
- azure_datalakeanalytics_accounts
- azure_datalakestore_accounts
- azure_datamigration_services
- azure_datashare_accounts
- azure_desktopvirtualization_host_pools
- azure_devhub_workflow
- azure_devops_pipeline_template_definitions
- azure_devtestlabs_global_schedules
- azure_devtestlabs_labs
- azure_devtestlabs_lab_artifact_sources
- azure_devtestlabs_lab_artifact_source_arm_templates
- azure_devtestlabs_lab_artifact_source_artifact
- azure_devtestlabs_lab_custom_images
- azure_devtestlabs_lab_environments
- azure_devtestlabs_lab_formulas
- azure_devtestlabs_lab_galery_images
- azure_devtestlabs_lab_notification_channels
- azure_devtestlabs_lab_schedules
- azure_devtestlabs_lab_users
- azure_devtestlabs_lab_user_disks
- azure_devtestlabs_lab_user_secrets
- azure_devtestlabs_lab_virtual_machines
- azure_devtestlabs_lab_virtual_machine_schedules
- azure_devtestlabs_lab_virtual_networks
- azure_dnsresolver_dns_forwarding_rulesets
- azure_dnsresolver_dns_resolvers
- azure_dns_zones
- azure_dns_record_sets
- azure_elastic_monitors
- azure_engagementfabric_accounts
- azure_eventgrid_topic_types
- azure_eventhub_clusters
- azure_eventhub_namespaces
- azure_eventhub_namespace_network_rule_sets
- azure_frontdoor_front_doors
- azure_frontdoor_managed_rule_sets
- azure_frontdoor_network_experiment_profiles
- azure_hanaonazure_sap_monitors
- azure_hdinsight_clusters
- azure_healthbot_bots
- azure_healthcareapis_services
- azure_hybridcompute_private_link_scopes
- azure_hybriddatamanager_data_managers
- azure_keyvault_keyvaults
- azure_keyvault_certificates
- azure_keyvault_certificate_policies
- azure_keyvault_keys
- azure_keyvault_key_rotation_policies
- azure_keyvault_secrets
- azure_keyvault_managed_hsms
- azure_kusto_clusters
- azure_labservices_lab_plans
- azure_labservices_lab_plan_images
- azure_labservices_labs
- azure_labservices_lab_schedules
- azure_labservices_lab_usages
- azure_labservices_lab_users
- azure_labservices_lab_virtual_machines
- azure_labservices_operations
- azure_labservices_skus
- azure_logic_integration_accounts
- azure_logic_integration_account_agreements
- azure_logic_integration_account_assemblies
- azure_logic_integration_account_certificates
- azure_logic_integration_account_maps
- azure_logic_integration_account_partners
- azure_logic_integration_account_schemas
- azure_logic_integration_account_sessions
- azure_logic_workflows
- azure_logic_workflow_runs
- azure_logic_workflow_run_actions
- azure_logic_workflow_run_action_request_histories
- azure_logic_workflow_triggers
- azure_logic_workflow_trigger_histories
- azure_logic_workflow_versions
- azure_machinelearning_operations
- azure_machinelearning_registries
- azure_machinelearning_registry_code_containers
- azure_machinelearning_registry_code_versions
- azure_machinelearning_registry_component_containers
- azure_machinelearning_registry_component_versions
- azure_machinelearning_registry_data_containers
- azure_machinelearning_registry_data_versions
- azure_machinelearning_registry_environment_containers
- azure_machinelearning_registry_environment_versions
- azure_machinelearning_registry_model_containers
- azure_machinelearning_registry_model_versions
- azure_machinelearning_workspaces
- azure_machinelearning_batch_endpoints
- azure_machinelearning_batch_deployments
- azure_machinelearning_component_containers
- azure_machinelearning_component_versions
- azure_machinelearning_computes
- azure_machinelearning_data_containers
- azure_machinelearning_data_versions
- azure_machinelearning_datastores
- azure_machinelearning_environment_containers
- azure_machinelearning_environment_versions
- azure_machinelearning_featureset_containers
- azure_machinelearning_featureset_versions
- azure_machinelearning_features
- azure_machinelearning_featurestore_entity_containers
- azure_machinelearning_featurestore_entity_versions
- azure_machinelearning_jobs
- azure_machinelearning_managed_network_setting_rules
- azure_machinelearning_marketplace_subscriptions
- azure_machinelearning_model_containers
- azure_machinelearning_model_versions
- azure_machinelearning_online_endpoints
- azure_machinelearning_online_deployments
- azure_machinelearning_private_endpoint_connections
- azure_machinelearning_private_link_resources
- azure_machinelearning_quotas
- azure_machinelearning_schedules
- azure_machinelearning_serverless_endpoints
- azure_machinelearning_usages
- azure_machinelearning_virtual_machine_sizes
- azure_machinelearning_workspace_connections
- azure_machinelearning_workspace_features
- azure_maintenance_configurations
- azure_maintenance_public_maintenance_configurations
- azure_managedapplications_applications
- azure_managementgroups_entities
- azure_managementgroups_management_groups
- azure_mariadb_servers
- azure_mariadb_server_configurations
- azure_marketplace_private_store
- azure_mediaservices_media_services
- azure_mediaservices_account_filters
- azure_mediaservices_assets
- azure_mediaservices_asset_filters
- azure_mediaservices_asset_tracks
- azure_mediaservices_content_key_policies
- azure_mediaservices_live_events
- azure_mediaservices_live_event_outputs
- azure_mediaservices_private_endpoint_connections
- azure_mediaservices_private_link_resources
- azure_mediaservices_streaming_endpoints
- azure_mediaservices_streaming_locators
- azure_mediaservices_streaming_policies
- azure_mediaservices_transforms
- azure_mediaservices_jobs
- azure_monitor_action_groups
- azure_monitor_activity_log_alerts
- azure_monitor_autoscale_settings
- azure_monitor_log_profiles
- azure_monitor_metric_alerts
- azure_monitor_private_link_scopes
- azure_monitor_resources
- azure_monitor_diagnostic_settings
- azure_monitor_scheduled_query_rules
- azure_monitor_subscription_diagnostic_settings
- azure_monitor_tenant_activity_log_alerts
- azure_monitor_tenant_activity_logs
- azure_mysqlflexibleservers_servers
- azure_mysqlflexibleservers_server_configurations
- azure_mysqlflexibleservers_server_firewall_rules
- azure_mysql_servers
- azure_mysql_server_configurations
- azure_mysql_server_databases
- azure_netappfiles_accounts
- azure_netappfiles_account_backup_policies
- azure_netappfiles_account_backup_vaults
- azure_netappfiles_account_backup_vault_backups
- azure_netappfiles_account_pools
- azure_netappfiles_account_pool_volumes
- azure_netappfiles_account_pool_volume_subvolumes
- azure_netappfiles_account_pool_volume_snapshots
- azure_netappfiles_account_pool_volume_quota_rules
- azure_netappfiles_account_snapshot_policies
- azure_netappfiles_account_snapshot_policy_associated_volumes
- azure_netappfiles_account_volume_groups
- azure_network_application_gateways
- azure_network_application_security_groups
- azure_network_azure_firewall_fqdn_tags
- azure_network_azure_firewalls
- azure_network_bastion_hosts
- azure_network_bgp_service_communities
- azure_network_custom_ip_prefixes
- azure_network_ddos_protection_plans
- azure_network_dscp_configuration
- azure_network_express_route_circuits
- azure_network_express_route_circuit_authorizations
- azure_network_express_route_circuit_peerings
- azure_network_express_route_gateways
- azure_network_express_route_ports
- azure_network_express_route_ports_locations
- azure_network_express_route_service_providers
- azure_network_firewall_policies
- azure_networkfunction_azure_traffic_collectors_by_subscription
- azure_network_interfaces
- azure_network_interface_ip_configurations
- azure_network_ip_allocations
- azure_network_ip_groups
- azure_network_load_balancers
- azure_network_nat_gateways
- azure_network_private_endpoints
- azure_network_private_link_services
- azure_network_profiles
- azure_network_public_ip_addresses
- azure_network_public_ip_prefixes
- azure_network_route_filters
- azure_network_route_tables
- azure_network_security_groups
- azure_network_security_partner_providers
- azure_network_service_endpoint_policies
- azure_network_subscription_network_manager_connections
- azure_network_virtual_appliances
- azure_network_virtual_hubs
- azure_network_virtual_network_gateway_connections
- azure_network_virtual_network_gateways
- azure_network_virtual_networks
- azure_network_virtual_network_subnets
- azure_network_virtual_network_taps
- azure_network_virtual_routers
- azure_network_virtual_wans
- azure_network_vpn_gateways
- azure_network_vpn_server_configurations
- azure_network_vpn_sites
- azure_network_watchers
- azure_network_watcher_flow_logs
- azure_network_web_application_firewall_policies
- azure_nginx_deployments
- azure_notificationhubs_namespaces
- azure_operationalinsights_clusters
- azure_operationalinsights_workspaces
- azure_peering_service_countries
- azure_peering_service_locations
- azure_peering_service_providers
- azure_policy_assignments
- azure_policy_data_policy_manifests
- azure_policy_definitions
- azure_policy_exemptions
- azure_policyinsights_attestations
- azure_policyinsights_policy_events
- azure_policyinsights_policy_states
- azure_policyinsights_policy_tracked_resources
- azure_policy_set_definitions
- azure_portal_list_tenant_configuration_violations
- azure_portal_tenant_configurations
- azure_postgresqlflexibleservers_servers
- azure_postgresqlflexibleservers_server_configurations
- azure_postgresqlflexibleservers_server_firewall_rules
- azure_postgresqlhsc_server_groups
- azure_postgresql_servers
- azure_postgresql_server_configurations
- azure_postgresql_server_firewall_rules
- azure_postgresql_databases
- azure_powerbidedicated_capacities
- azure_privatedns_private_zones
- azure_privatedns_private_zone_record_sets
- azure_privatedns_private_zone_virtual_network_links
- azure_providerhub_provider_registrations
- azure_purview_accounts
- azure_purview_account_keys
- azure_purview_account_private_endpoint_connections
- azure_purview_account_private_link_resources
- azure_purview_operations
- azure_quota_quotas
- azure_quota_usages
- azure_recoveryservices_operations
- azure_recoveryservices_vaults
- azure_recoveryservices_backup_engines
- azure_recoveryservices_backup_jobs
- azure_recoveryservices_backup_policies
- azure_recoveryservices_backup_protected_items
- azure_recoveryservices_backup_protection_containers
- azure_recoveryservices_backup_protection_intents
- azure_recoveryservices_backup_usage_summaries
- azure_recoveryservices_deleted_protection_containers
- azure_recoveryservices_private_link_resources
- azure_recoveryservices_replication_alert_settings
- azure_recoveryservices_replication_events
- azure_recoveryservices_replication_fabrics
- azure_recoveryservices_replication_logical_networks
- azure_recoveryservices_replication_protection_containers
- azure_recoveryservices_replication_protectable_items
- azure_recoveryservices_replication_jobs
- azure_recoveryservices_replication_migration_items
- azure_recoveryservices_replication_network_mappings
- azure_recoveryservices_replication_networks
- azure_recoveryservices_replication_policies
- azure_recoveryservices_replication_protected_items
- azure_recoveryservices_replication_protection_ctnr_mappings
- azure_recoveryservices_replication_protection_intents
- azure_recoveryservices_replication_recovery_plans
- azure_recoveryservices_replication_recovery_service_providers
- azure_recoveryservices_replication_storage_classif_mappings
- azure_recoveryservices_replication_storage_classifications
- azure_recoveryservices_replication_vault_settings
- azure_recoveryservices_replication_vcenters
- azure_recoveryservices_vault_replication_usages
- azure_recoveryservices_vault_usages
- azure_redhatopenshift_open_shift_clusters
- azure_redis_caches
- azure_relay_namespaces
- azure_reservations_reservation
- azure_reservations_reservation_order
- azure_resourcehealth_availability_statuses
- azure_resourcehealth_emerging_issues
- azure_resourcehealth_events
- azure_resourcehealth_event_impacted_resources
- azure_resourcehealth_security_advisory_impacted_resources
- azure_resources_links
- azure_resources_providers
- azure_resources_resource_groups
- azure_resources_resources
- azure_role_management_policy_assignments
- azure_saas_resources
- azure_search_services
- azure_security_adaptive_application_controls
- azure_security_alerts
- azure_security_alerts_suppression_rules
- azure_security_allowed_connections
- azure_security_applications
- azure_security_assessments
- azure_security_assessments_metadata
- azure_security_automations
- azure_security_auto_provisioning_settings
- azure_security_connectors
- azure_security_contacts
- azure_security_discovered_security_solutions
- azure_security_external_security_solutions
- azure_security_governance_rule
- azure_security_jit_network_access_policies
- azure_security_locations
- azure_security_pricings
- azure_security_regulatory_compliance_standards
- azure_security_regulatory_compliance_controls
- azure_security_regulatory_compliance_assessments
- azure_security_secure_score_control_definitions
- azure_security_secure_score_controls
- azure_security_secure_scores
- azure_security_settings
- azure_security_solutions
- azure_security_sub_assessments
- azure_security_tasks
- azure_security_topology
- azure_security_workspace_settings
- azure_servicebus_namespaces
- azure_servicebus_namespace_topics
- azure_servicebus_namespace_topic_authorization_rules
- azure_servicebus_namespace_topic_rule_access_keys
- azure_servicefabric_clusters
- azure_servicefabric_cluster_applications
- azure_servicefabric_cluster_application_services
- azure_servicefabric_cluster_application_types
- azure_servicefabricmanaged_clusters
- azure_servicefabricmanaged_cluster_node_types
- azure_servicefabricmanaged_cluster_node_type_skus
- azure_servicefabricmanaged_cluster_applications
- azure_servicefabricmanaged_cluster_application_services
- azure_servicefabricmanaged_cluster_application_types
- azure_sql_instance_pools
- azure_sql_managed_instances
- azure_sql_managed_instance_encryption_protectors
- azure_sql_managed_instance_vulnerability_assessments
- azure_sql_servers
- azure_sql_server_vulnerability_assessments
- azure_sql_server_blob_auditing_policies
- azure_sql_server_admins
- azure_sql_server_encryption_protectors
- azure_sql_server_databases
- azure_sql_server_database_blob_auditing_policies
- azure_sql_transparent_data_encryptions
- azure_sql_server_database_threat_protections
- azure_sql_server_database_vulnerability_assessments
- azure_sql_server_database_vulnerability_assessment_scans
- azure_sql_server_database_long_term_retention_policies
- azure_sql_server_virtual_network_rules
- azure_sql_server_security_alert_policies
- azure_sql_server_advanced_threat_protection_settings
- azure_sql_server_firewall_rules
- azure_sql_virtual_clusters
- azure_sqlvirtualmachine_groups
- azure_sqlvirtualmachine_sql_virtual_machines
- azure_storage_accounts
- azure_storage_tables
- azure_storage_containers
- azure_storage_blob_services
- azure_storage_file_shares
- azure_storage_queues
- azure_storage_queue_acl
- azure_storage_queue_services
- azure_storage_account_keys
- azure_storage_management_policies
- azure_storagecache_caches
- azure_storagemover_operations
- azure_storagemover_storagemovers
- azure_storagemover_agents
- azure_storagemover_endpoints
- azure_storagemover_projects
- azure_storagemover_job_definitions
- azure_storagemover_job_runs
- azure_storagesync_services
- azure_storagesync_service_private_endpoint_connections
- azure_storagesync_service_private_link_resources
- azure_storagesync_service_registered_servers
- azure_storagesync_service_sync_groups
- azure_storagesync_service_sync_group_server_endpoints
- azure_streamanalytics_streaming_jobs
- azure_subscription_subscriptions
- azure_subscription_subscription_locations
- azure_subscription_tenants
- azure_support_services
- azure_support_tickets
- azure_synapse_private_link_hubs
- azure_synapse_workspaces
- azure_synapse_sql_pools
- azure_synapse_sql_pool_usages
- azure_synapse_sql_pool_blob_auditing_policies
- azure_synapse_sql_pool_geo_backup_policies
- azure_synapse_sql_pool_operations
- azure_synapse_sql_pool_replication_links
- azure_synapse_sql_pool_restore_points
- azure_synapse_sql_pool_schemas
- azure_synapse_sql_pool_schema_tables
- azure_synapse_sql_pool_schema_table_columns
- azure_synapse_sql_pool_security_alert_policies
- azure_synapse_sql_pool_current_sensitivity_labels
- azure_synapse_sql_pool_recommended_sensitivity_labels
- azure_synapse_sql_pool_transparent_data_encryptions
- azure_synapse_ip_firewall_rules
- azure_synapse_keys
- azure_synapse_restorable_dropped_sql_pools
- azure_trafficmanager_profiles
- azure_windowsiot_services
- azure_workloads_monitors
Azure Compute Virtual Machine Patch Assessments
The azure_compute_virtual_machine_patch_assessments table shows data for Azure Compute Virtual Machine Patch Assessments.
This will begin patch assessments on available virtual machines and can take long to complete.
Not available for all VMs. More at https://learn.microsoft.com/en-us/azure/virtual-machines/automatic-vm-guest-patching#requirements-for-enabling-automatic-vm-guest-patching
Primary Keys #
| Name | Type |
|---|---|
| assessment_activity_id | utf8 |
Columns #
| Name | Type |
|---|---|
| assessment_activity_id | utf8 |
| available_patches | json |
| _cq_id | uuid |
| _cq_parent_id | uuid |
| critical_and_security_patch_count | int64 |
| error | json |
| other_patch_count | int64 |
| reboot_pending | bool |
| start_date_time | timestamp[us, tz=UTC] |
| status | utf8 |
| subscription_id | utf8 |
Relations
This table depends on:
Azure Compute Virtual Machines