turbot/urlscan

steampipe plugin install urlscansteampipe plugin install urlscan

Table: urlscan_search

Search scan history from urlscan.io to find scans for a domain. The full urlscan search syntax is supported in the query field.

Note: A query must be provided in all queries to this table.

Examples

List all scans for a given domain and it's subdomains

select
*
from
urlscan_search
where
query = 'domain:steampipe.io'
order by
task_time desc

List all scans for a given URL (no subdomains)

select
*
from
urlscan_search
where
query = 'page.url:steampipe.io'
order by
task_time desc

List all scans for an exact page

select
*
from
urlscan_search
where
query = 'page.url:"https://steampipe.io/downloads"'
order by
task_time desc

Get the last scan for a page

select
*
from
urlscan_search
where
query = 'page.url:"https://steampipe.io/downloads"'
order by
task_time desc
limit 1

List all scans for a domain in the last 7 days

select
*
from
urlscan_search
where
query = 'domain:steampipe.io date:now-7d'
order by
task_time desc

.inspect urlscan_search

NameTypeDescription
idtextID of the scan yielding this search result.
pagejsonbBasic page information.
page_domaintextDomain of the page.
page_ipinetIP address of the page.
page_urltextURL of the page.
querytextThe search query.
resulttextURL to the full scan result data.
statsjsonbBasic statistics for the page.
taskjsonbTask information for the scan.
task_timetimestamp without time zoneTime when the scan was run.
task_urltextURL of the task scan result.
task_visibilitytextVisibility of the task scan.