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 thewhere
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_taskwhere scan = '54c78f69-5294-4a17-8ae0-a71943954e09';
select *from urlscan_taskwhere scan = '54c78f69-5294-4a17-8ae0-a71943954e09';
Schema for urlscan_task
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
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. | |
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