steampipe plugin install urlscan

Table: urlscan_asn - Query Urlscan ASN using SQL

An Autonomous System Number (ASN) is a unique identifier assigned to an Autonomous System (AS). ASNs are used by the Border Gateway Protocol (BGP) for routing traffic across the internet. In Urlscan, ASNs provide insights into the network routing prefixes and the networks they belong to.

Table Usage Guide

The urlscan_asn table provides insights into Autonomous System Numbers (ASNs) within Urlscan. As a network engineer, explore ASN-specific details through this table, including the network routing prefixes and the networks they belong to. Utilize it to uncover information about ASNs, such as their associated networks, and the verification of routing prefixes.

Important Notes

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

Examples

List ASNs

Explore the Autonomous System Numbers (ASNs) related to a specific web scan. This is useful for identifying the networks involved in the scanned web activity, contributing to enhanced cybersecurity measures.

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

Schema for urlscan_asn

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
asntextThe ASN.
countrytextCountry where the IP address was found.
datetimestamp with time zoneDate when the ASN was created.
descriptiontextDescription of the ASN.
ipinetIP address in the ASN.
nametextName of the ASN.
registrartextRegistar for the ASN.
routecidrRoute / CIDR for the ASN.
scantext=ID of the scan result.

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_asn