search

turbot / steampipe-plugin-net

Use SQL to instantly query DNS records, certificates and other network information. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/net
Apache License 2.0
23 stars 5 forks source link

Table `net_dns_record` not listing correct results for consecutive queries when used filter for `type` column. Fixes #21 #22

Closed LalitLab closed 2 years ago

LalitLab commented 2 years ago

Example query results

Results ```sql select * from net_dns_record where domain = 'turbot.com' and type = 'A'; +------------+------+--------------+--------+----------+--------+-----+---------------------------+ | domain | type | ip | target | priority | value | ttl | _ctx | +------------+------+--------------+--------+----------+--------+-----+---------------------------+ | turbot.com | A | 54.182.0.62 | | | | 60 | {"connection_name":"net"} | | turbot.com | A | 54.182.0.126 | | | | 60 | {"connection_name":"net"} | | turbot.com | A | 54.182.0.125 | | | | 60 | {"connection_name":"net"} | | turbot.com | A | 54.182.0.32 | | | | 60 | {"connection_name":"net"} | +------------+------+--------------+--------+----------+--------+-----+---------------------------+ Time: 487.420352ms > select * from net_dns_record where domain = 'turbot.com' and type = 'NS'; +------------+------+--------+--------------------------+----------+--------+--------+--------------> | domain | type | ip | target | priority | value | ttl | _ctx > +------------+------+--------+--------------------------+----------+--------+--------+--------------> | turbot.com | NS | | ns-2039.awsdns-62.co.uk. | | | 172800 | {"connection_> | turbot.com | NS | | ns-287.awsdns-35.com. | | | 172800 | {"connection_> | turbot.com | NS | | ns-1312.awsdns-36.org. | | | 172800 | {"connection_> | turbot.com | NS | | ns-517.awsdns-00.net. | | | 172800 | {"connection_> +------------+------+--------+--------------------------+----------+--------+--------+------------- ```
cbruno10 commented 2 years ago

These changes were released as part of https://github.com/turbot/steampipe-plugin-net/pull/28, closing this PR.