Table: shodan_account_profile - Query Shodan Account Profiles using SQL

A Shodan Account Profile is a user account on Shodan, a search engine for internet-connected devices. The profile includes information about the user, such as their display name, email, and credit balance. The profile also indicates whether the user is a member of the Shodan platform.

Table Usage Guide

The shodan_account_profile table provides insights into user profiles within Shodan. As a cybersecurity analyst, you can explore profile-specific details through this table, including display name, email, and credit balance. Use this table to uncover information about the users, such as their membership status and the number of query credits they have available.

Examples

List the scans

Explore your Shodan account profile to gain insights into the details of your scans. This could be useful in identifying potential security vulnerabilities and understanding areas for improvement.

select
  *
from
  shodan_account_profile;

select
  *
from
  shodan_account_profile;

Schema for shodan_account_profile

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created	timestamp with time zone		When the account was created.
credits	bigint		Export credits for this account.
display_name	text		Account name.
member	boolean		True if the account is a member of Shodan.
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)" -- shodan

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

steampipe_export_shodan --config '<your_config>' shodan_account_profile