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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
asn	text		The ASN.
country	text		Country where the IP address was found.
date	timestamp with time zone		Date when the ASN was created.
description	text		Description of the ASN.
ip	inet		IP address in the ASN.
name	text		Name of the ASN.
registrar	text		Registar for the ASN.
route	cidr		Route / CIDR for the ASN.
scan	text	=	ID of the scan result.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.

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