turbot / steampipe-plugin-azure

Use SQL to instantly query Azure resources across regions and subscriptions. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/azure
Apache License 2.0
37 stars 17 forks source link

Add table `azure_api_management_backend`. Closes #644 #689

Closed madhushreeray30 closed 7 months ago

madhushreeray30 commented 10 months ago

Integration test logs

Logs ``` Add passing integration test logs here ```

Example query results

Results ```sql select * from azure_api_management_backend [ { "_ctx": { "connection_name": "azure" }, "akas": [ "azure:///subscriptions/d46d7416-2222-3333-bbb5-111111111111/resourceGroups/DefaultResourceGroup-WEU/providers/Microsoft.ApiManagement/service/mrtest/backends/mrtestbackend", "azure:///subscriptions/d46d7416-2222-3333-bbb5-111111111111/resourcegroups/defaultresourcegroup-weu/providers/microsoft.apimanagement/service/mrtest/backends/mrtestbackend" ], "backend_id": "mrtestbackend", "cloud_environment": "AzurePublicCloud", "credentials": { "authorization": { "parameter": "username:password", "scheme": "Basic" }, "header": {}, "query": {} }, "description": "This is the test backend", "id": "/subscriptions/d46d7416-2222-3333-bbb5-111111111111/resourceGroups/DefaultResourceGroup-WEU/providers/Microsoft.ApiManagement/service/mrtest/backends/mrtestbackend", "name": "mrtestbackend", "properties": null, "protocol": "http", "proxy": null, "resource_group": "defaultresourcegroup-weu", "resource_id": null, "service_name": "mrtest", "subscription_id": "d46d7416-2222-3333-bbb5-111111111111", "title": "mrtestbackend", "tls": { "validateCertificateChain": true, "validateCertificateName": true }, "type": "Microsoft.ApiManagement/service/backends", "url": "https://api.sampleproductservice.com/v1/products" } ] ``` ```sql select * from azure_api_management_backend where backend_id='mrtestbackend' and service_name = 'mrtest' and resource_group = 'defaultresourcegroup-weu' [ { "_ctx": { "connection_name": "azure" }, "akas": [ "azure:///subscriptions/d46d7416-2222-3333-bbb5-111111111111/resourceGroups/defaultresourcegroup-weu/providers/Microsoft.ApiManagement/service/mrtest/backends/mrtestbackend", "azure:///subscriptions/d46d7416-2222-3333-bbb5-111111111111/resourcegroups/defaultresourcegroup-weu/providers/microsoft.apimanagement/service/mrtest/backends/mrtestbackend" ], "backend_id": "mrtestbackend", "cloud_environment": "AzurePublicCloud", "credentials": { "authorization": { "parameter": "username:password", "scheme": "Basic" }, "header": {}, "query": {} }, "description": "This is the test backend", "id": "/subscriptions/d46d7416-2222-3333-bbb5-111111111111/resourceGroups/defaultresourcegroup-weu/providers/Microsoft.ApiManagement/service/mrtest/backends/mrtestbackend", "name": "mrtestbackend", "properties": null, "protocol": "http", "proxy": null, "resource_group": "defaultresourcegroup-weu", "resource_id": null, "service_name": "mrtest", "subscription_id": "d46d7416-2222-3333-bbb5-111111111111", "title": "mrtestbackend", "tls": { "validateCertificateChain": true, "validateCertificateName": true }, "type": "Microsoft.ApiManagement/service/backends", "url": "https://api.sampleproductservice.com/v1/products" } ] ```