Even if we have data available as mentioned in the screen the query below does not sho

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

azure_storage_account > virtual_network_rules does not work about steampipe-plugin-azure HOT 4 CLOSED

turbot commented on June 19, 2024

azure_storage_account > virtual_network_rules does not work

from steampipe-plugin-azure.

Comments (4)

rajlearner17 commented on June 19, 2024

FYI
This works

select name from azure_storage_account
+----------------+
| name |
+----------------+
| anothertesting |
+----------------+

from steampipe-plugin-azure.

Subhajit97 commented on June 19, 2024

@rajmohanty17 I am not able to reproduce the above issue. The above mentioned query is working for me.
I am using the following configuration

> steampipe --version
steampipe version 0.3.3

> steampipe plugin list
+-----------------------------------------------------+---------+-----------------+
| NAME                                                | VERSION | CONNECTIONS     |
+-----------------------------------------------------+---------+-----------------+
| hub.steampipe.io/plugins/turbot/azure@latest        | 0.3.1   | azure           |
+-----------------------------------------------------+---------+-----------------+

I have created the resource with following configuration

> select jsonb_pretty(virtual_network_rules) from azure_storage_account
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| jsonb_pretty                                                                                                                                                       |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| [                                                                                                                                                                  |
|     {                                                                                                                                                              |
|         "id": "/subscriptions/********-****-****-****-************/resourcegroups/turbot_rg/providers/Microsoft.Network/virtualnetworks/test-net/subnets/default", |
|         "state": "Succeeded",                                                                                                                                      |
|         "action": "Allow"                                                                                                                                          |
|     }                                                                                                                                                              |
| ]                                                                                                                                                                  |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+
>
>
> select jsonb_pretty(network_ip_rules) from azure_storage_account
+------------------------------------+
| jsonb_pretty                       |
+------------------------------------+
| [                                  |
|     {                              |
|         "value": "182.71.32.0/20", |
|         "action": "Allow"          |
|     }                              |
| ]                                  |
+------------------------------------+
>

Can you please try with the latest plugin?

from steampipe-plugin-azure.