turbot/digitalocean

steampipe plugin install digitaloceansteampipe plugin install digitalocean

Table: digitalocean_droplet

A Droplet is a DigitalOcean virtual machine.

Examples

List all droplets

select
*
from
digitalocean_droplet;

Get a droplet by ID

select
*
from
digitalocean_droplet
where
id = 227211874;

Droplets by region_slug

select
region_slug,
count(id),
sum(size_gigabytes) as size_gigabytes
from
digitalocean_droplet
group by
region_slug
order by
region_slug;

Droplets that do not have backups enabled

select
name,
region_slug,
features
from
digitalocean_droplet
where
not features ? 'backups';

Droplet network addresses

select
name,
region_slug,
private_ipv4,
public_ipv4,
public_ipv6
from
digitalocean_droplet;

Largest droplets

select
name,
region_slug,
size_gigabytes
from
digitalocean_droplet
order by
size_gigabytes desc
limit
10;

Oldest droplets

select
name,
region_slug,
created_at
from
digitalocean_droplet
order by
created_at
limit
10;

Droplets with tag "production"

select
name,
region_slug,
tags
from
digitalocean_droplet
where
tags ? 'production';

.inspect digitalocean_droplet

A Droplet is a DigitalOcean virtual machine.

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
backup_idsjsonbAn array of backup IDs of any backups that have been taken of the Droplet instance.
created_attimestamp without time zoneTime when the Droplet was created.
diskbigintThe size of the Droplet's disk in gigabytes.
featuresjsonbAn array of features enabled on this Droplet.
idbigintA unique identifier for each Droplet instance.
imagejsonbInformation about the base image used to create the Droplet instance.
kerneljsonbThe current kernel. This will initially be set to the kernel of the base image when the Droplet is created.
lockedbooleanA boolean value indicating whether the Droplet has been locked, preventing actions by users.
memorybigintMemory of the Droplet in megabytes.
nametextThe human-readable name set for the Droplet instance.
networksjsonbThe details of the network that are configured for the Droplet instance. This is an object that contains keys for IPv4 and IPv6. The value of each of these is an array that contains objects describing an individual IP resource allocated to the Droplet. These will define attributes like the IP address, netmask, and gateway of the specific network depending on the type of network it is.
next_backup_window_endtextEnd time of the window during which the backup will start.
next_backup_window_starttextStart time of the window during which the backup will start.
private_ipv4inetPrivate IPv4 address of the Droplet.
public_ipv4inetPublic IPv4 address of the Droplet.
public_ipv6inetPublic IPv6 address of the Droplet.
regionjsonbInformation about region that the Droplet instance is deployed in.
region_slugtextThe unique slug identifier for the region the Droplet is deployed in.
sizejsonbInformation about the size of the Droplet. Note: Due to resize operations, the disk column is more accurate than the disk field in this size data.
size_slugtextThe unique slug identifier for the size of this Droplet.
snapshot_idsjsonbAn array of snapshot IDs of any snapshots created from the Droplet instance.
statustextA status string indicating the state of the Droplet instance. This may be "new", "active", "off", or "archive".
tagsjsonbA map of tags for the resource.
tags_srcjsonbAn array of tags the Droplet has been tagged with.
titletextTitle of the resource.
urntextThe uniform resource name (URN) for the Droplet.
vcpusbigintThe number of virtual CPUs.
volume_idsjsonbA flat array including the unique identifier for each Block Storage volume attached to the Droplet.
vpc_uuidtextA string specifying the UUID of the VPC to which the Droplet is assigned.