Closed Priyanka-Chatterjee-2000 closed 3 weeks ago
Hi @Priyanka-Chatterjee-2000, The table azure_frontdoor
is returning the data as expected.
> select * from azure_frontdoor;
+-----------------+-------------------------------------------------------------------------------------------------------------------------------------------+--------------------+------------------------------+-----------------------------+---------------+------------>
| name | id | provisioning_state | type | cname | enabled_state | friendly_na>
+-----------------+-------------------------------------------------------------------------------------------------------------------------------------------+--------------------+------------------------------+-----------------------------+---------------+------------>
| turbottest76782 | /subscriptions/************************************/resourcegroups/turbottest76782/providers/Microsoft.Network/frontdoors/turbottest76782 | Succeeded | Microsoft.Network/frontdoors | turbottest76782.azurefd.net | Enabled | >
+-----------------+-------------------------------------------------------------------------------------------------------------------------------------------+--------------------+------------------------------+-----------------------------+---------------+------------>
The command az afd profile list
stands for the resource Front Door and CDN profiles
. Currently, the table returns the data for Azure CDN Standard from Microsoft (classic)
Not the standard
one.
Please update the issue as per your requirements.
Thanks!
@ParthaI need the details of the standard frontdoor but in table azure_frontdoor we get only classic ones details. Shall we have a new table to query standard frontdoor information?
@Priyanka-Chatterjee-2000, I believe this will be a separate table. Terraform treats it as a separate resource:
Also, there are two separate CLI commands to list the resources.
az network front-door list
az afd profile list
Thanks!
Description: I am experiencing an issue with the Steampipe Azure plugin where Azure Front Door resources are not being listed as expected. Despite having created an Azure Front Door resource, the azure_frontdoor table returns an empty result set.
Steps to Reproduce:
Create an Azure Front Door resource using the Azure CLI or Azure Portal. Verify the creation of the resource using az afd profile list:
Attempt to list the Azure Front Door resources using Steampipe:
Expected Behavior: The Azure Front Door resource should be listed in the query result.
Actual Behavior: The query returns an empty result set.
Additional Information:
az network front-door list
returns an empty result.