Table: urlscan_task - Query Urlscan Tasks using SQL

Urlscan Tasks in is a service that allows you to execute and manage scan tasks across your applications and infrastructure. It provides a centralized way to set up and manage tasks for various resources, including websites, web applications, and more. Urlscan Tasks helps you stay informed about the health and security of your resources and take appropriate actions when predefined conditions are met.

Table Usage Guide

The urlscan_task table provides insights into tasks within Urlscan. As a security analyst, explore task-specific details through this table, including task status, results, and associated metadata. Utilize it to uncover information about tasks, such as those related to specific URLs, the status of each task, and the verification of scan results.

Important Notes

You must specify the scan in the where clause to query this table.

Examples

Get task information

Explore detailed information about a specific task, such as its status, duration, and associated metadata. This is useful for tracking the progress and outcome of individual tasks, enabling efficient monitoring and management.

select
  *
from
  urlscan_task
where
  scan = '54c78f69-5294-4a17-8ae0-a71943954e09';

select
  *
from
  urlscan_task
where
  scan = '54c78f69-5294-4a17-8ae0-a71943954e09';

Schema for urlscan_task

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
dom_url	text		DOM URL for the task.
method	text		Method for the task, e.g. automatic.
report_url	text		URL where the report is available.
scan	text	=	ID of the scan result.
screenshot_url	text		URL for a screenshot of the page.
source	text		Source that triggered the task.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
time	text		Time when the task was run.
url	text		URL of the task.
user_agent	text		User agent used for the task.
uuid	text		UUID of the task.
visibility	text		Visibility of the task, e.g. public.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- urlscan

You can pass the configuration to the command with the --config argument:

steampipe_export_urlscan --config '<your_config>' urlscan_task