vw_profiles

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

Overview

Name	vw_profiles
Type	View
Id	azure.traffic_manager.vw_profiles

Fields

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

SQL Definition

Sqlite3

SELECT
location as location,
tags as tags,
JSON_EXTRACT(properties, '$.profileStatus') as "profile_status",
JSON_EXTRACT(properties, '$.trafficRoutingMethod') as "traffic_routing_method",
JSON_EXTRACT(properties, '$.dnsConfig') as "dns_config",
JSON_EXTRACT(properties, '$.monitorConfig') as "monitor_config",
JSON_EXTRACT(properties, '$.endpoints') as "endpoints",
JSON_EXTRACT(properties, '$.trafficViewEnrollmentStatus') as "traffic_view_enrollment_status",
JSON_EXTRACT(properties, '$.allowedEndpointRecordTypes') as "allowed_endpoint_record_types",
JSON_EXTRACT(properties, '$.maxReturn') as "max_return",
subscriptionId,
resourceGroupName,
profileName
FROM azure.traffic_manager.profiles
WHERE subscriptionId = 'replace-me';

Postgres

SELECT
location as location,
tags as tags,
json_extract_path_text(properties, '$.profileStatus') as "profile_status",
json_extract_path_text(properties, '$.trafficRoutingMethod') as "traffic_routing_method",
json_extract_path_text(properties, '$.dnsConfig') as "dns_config",
json_extract_path_text(properties, '$.monitorConfig') as "monitor_config",
json_extract_path_text(properties, '$.endpoints') as "endpoints",
json_extract_path_text(properties, '$.trafficViewEnrollmentStatus') as "traffic_view_enrollment_status",
json_extract_path_text(properties, '$.allowedEndpointRecordTypes') as "allowed_endpoint_record_types",
json_extract_path_text(properties, '$.maxReturn') as "max_return",
subscriptionId,
resourceGroupName,
profileName
FROM azure.traffic_manager.profiles
WHERE subscriptionId = 'replace-me';