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

Update steampipe-plugin-sdk to v1.6.1. Closes #5 #7

Closed bigdatasourav closed 3 years ago

bigdatasourav commented 3 years ago

Example query results

Results ``` > select * from net_dns_record where domain = 'steampipe.io' +--------------+------+-------------+--------------------------+----------+----------------------------------------------------------------------+-------+ | domain | type | ip | target | priority | value | ttl | +--------------+------+-------------+--------------------------+----------+----------------------------------------------------------------------+-------+ | steampipe.io | A | 76.76.21.21 | | | | 300 | | steampipe.io | NS | | ns-128.awsdns-16.com. | | | 86040 | | steampipe.io | NS | | ns-1628.awsdns-11.co.uk. | | | 86040 | | steampipe.io | NS | | ns-600.awsdns-11.net. | | | 86040 | | steampipe.io | NS | | ns-1455.awsdns-53.org. | | | 86040 | | steampipe.io | SOA | | ns-128.awsdns-16.com. | | | 718 | | steampipe.io | TXT | | | | google-site-verification=x7vWU3IdwfXfrFlbwng7KCkDNmbKz76Dy64WYF-raqk | 118 | | steampipe.io | TXT | | | | google-site-verification=uTwnG5qxY5EM5HtQOJCcX35m_Fw5Kcl4_009S2p6MqI | 118 | | steampipe.io | TXT | | | | google-site-verification=XPbl-B2BBUirby0xThttDdApUvUwZo5KgwwBKlDeo88 | 118 | +--------------+------+-------------+--------------------------+----------+----------------------------------------------------------------------+-------+ > select * from net_dns_record where domain = 'turbot.com' +------------+------+----------------+--------------------------+----------+----------------------------------------------------------------------------------------------------------------+--------+ | domain | type | ip | target | priority | value | ttl | +------------+------+----------------+--------------------------+----------+----------------------------------------------------------------------------------------------------------------+--------+ | turbot.com | A | 54.230.237.127 | | | | 60 | | turbot.com | A | 54.230.237.82 | | | | 60 | | turbot.com | A | 54.230.237.107 | | | | 60 | | turbot.com | A | 54.230.237.31 | | | | 60 | | turbot.com | MX | | alt2.aspmx.l.google.com. | 5 | | 56 | | turbot.com | MX | | alt1.aspmx.l.google.com. | 5 | | 56 | | turbot.com | MX | | alt3.aspmx.l.google.com. | 10 | | 56 | | turbot.com | MX | | aspmx.l.google.com. | 1 | | 56 | | turbot.com | MX | | alt4.aspmx.l.google.com. | 10 | | 56 | | turbot.com | NS | | ns-287.awsdns-35.com. | | | 172556 | | turbot.com | NS | | ns-517.awsdns-00.net. | | | 172556 | | turbot.com | NS | | ns-1312.awsdns-36.org. | | | 172556 | | turbot.com | NS | | ns-2039.awsdns-62.co.uk. | | | 172556 | | turbot.com | SOA | | ns-1312.awsdns-36.org. | | | 656 | | turbot.com | TXT | | | | stripe-verification=d8f9a051e72757a108fa405dc91a3ef2cf77378ecd55b9b0dd62589750a28dcf | 56 | | turbot.com | TXT | | | | v=spf1 include:_spf.google.com include:mail.zendesk.com include:servers.mcsv.net include:aspmx.pardot.com -all | 56 | | turbot.com | TXT | | | | pardot740973=676d95fcfc6b0c5bf757bb2f7a1bacd98a222c6c971456fa5caafa1d10e22e22 | 56 | | turbot.com | TXT | | | | d1c86u3wds7nbx.cloudfront.net | 56 | | turbot.com | TXT | | | | google-site-verification=099vd35a8sI1qTT7kZ9EW8PMGzDrx9VFy9AVDp_vehs | 56 | +------------+------+----------------+--------------------------+----------+----------------------------------------------------------------------------------------------------------------+--------+ > select * from net_dns_record where domain = 'turbot.com' and type = 'A' +------------+------+----------------+--------+----------+--------+-----+ | domain | type | ip | target | priority | value | ttl | +------------+------+----------------+--------+----------+--------+-----+ | turbot.com | A | 54.230.237.82 | | | | 60 | | turbot.com | A | 54.230.237.127 | | | | 60 | | turbot.com | A | 54.230.237.31 | | | | 60 | | turbot.com | A | 54.230.237.107 | | | | 60 | +------------+------+----------------+--------+----------+--------+-----+ ```
misraved commented 3 years ago 
select domain, common_name, not_after from net_certificate where domain = 'steampipe.io'
+--------------+--------------+---------------------+
| domain       | common_name  | not_after           |
+--------------+--------------+---------------------+
| steampipe.io | steampipe.io | 2021-11-26 20:09:54 |
+--------------+--------------+---------------------+