Table: ip2locationio_whois
Get WHOIS domain information about a domain name.
The ip2locationio_whois
table requires the domain
field to be specified in all queries, defining the domain name to lookup.
Examples
Info for a specific domain name
select domain, domain_id, status, create_datefrom ip2locationio_whoiswhere domain = 'google.com';
Nested info for a specific domain name
select domain, domain_id, registrar ->> 'name' as registrar_name, nameserversfrom ip2locationio_whoiswhere domain = 'google.com';
Schema for ip2locationio_whois
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
admin | jsonb | Admin details. | |
billing | jsonb | Billing details. | |
create_date | timestamp with time zone | Domain name creation date. | |
domain | text | = | Domain name to query. |
domain_age | bigint | Domain name age in day(s). | |
domain_id | text | Domain name ID. | |
expire_date | timestamp with time zone | Domain name expiration date. | |
nameservers | jsonb | Name servers. | |
registrant | jsonb | Registrant details. | |
registrar | jsonb | Registrar details. | |
status | text | Domain name status. | |
tech | jsonb | Tech details. | |
update_date | timestamp with time zone | Domain name updated date. | |
whois_server | text | WHOIS server name. |