search

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
34 stars 15 forks source link

`azure_postgresql_flexible_server` does not appear to provide `fullyQualifiedDomainName` #753

Closed atfurman closed 1 month ago

atfurman commented 2 months ago

Describe the bug I am attempting to inventory VM and database resources in Azure using steampipe. One of the desired fields is FQDN, but this does not appear to be available in steampipe despite being trivially accessible with az postgres flexible-server list

Steampipe version (steampipe -v) Steampipe v0.23.0-alpha.7

Plugin version (steampipe plugin list) +----------------------------------------------+---------+-------------+ | Installed | Version | Connections | +----------------------------------------------+---------+-------------+ | hub.steampipe.io/plugins/turbot/azure@latest | 0.56.0 | azure | | hub.steampipe.io/plugins/turbot/net@latest | 0.12.0 | net | +----------------------------------------------+---------+-------------+

To reproduce

steampipe query "select * from azure_postgresql_flexible_server"

Expected behavior It would be ideal to be able to get the FQDN from steampipe for databases.

Additional context Add any other context about the problem here.

atfurman commented 2 months ago

It appears to be possible to derive the FQDN, which is the approach I have taken as a workaround:

    case
        when db.region like '%usgov%' then db.name || '.postgres.database.usgovcloudapi.net'
        else db.name || '.postgres.database.azure.com'
    end as inv_dns_name,

It would be nice to be able to query this directly however.