turbot/digitalocean

steampipe plugin install digitaloceansteampipe plugin install digitalocean
On This Page
Get Involved

Table: digitalocean_account

Query information about your current account.

Examples

Account information

select
*
from
digitalocean_account;

Check current status of your account

select
status,
status_message
from
digitalocean_account;

Check usage of limits in your account

with droplets as (
select
count(urn)
from
digitalocean_droplet
),
floating_ips as (
select
count(urn)
from
digitalocean_floating_ip
),
volumes as (
select
count(urn)
from
digitalocean_volume
)
select
(
select
count
from
droplets
) as droplet_count,
droplet_limit,
round(
100.0 * (
select
count
from
droplets
) / droplet_limit,
1
) as droplet_usage_percent,
(
select
count
from
volumes
) as volume_count,
volume_limit,
round(
100.0 * (
select
count
from
volumes
) / volume_limit,
1
) as volume_usage_percent,
(
select
count
from
floating_ips
) as floating_ip_count,
floating_ip_limit,
round(
100.0 * (
select
count
from
floating_ips
) / floating_ip_limit,
1
) as floating_ip_usage_percent
from
digitalocean_account;

.inspect digitalocean_account

Retrieve information about your current account.

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
droplet_limitbigintThe total number of Droplets the current user or team may have at one time.
emailtextThe email address used by the current user to register for DigitalOcean.
email_verifiedbooleanIf true, the user has verified their account via email. False otherwise.
floating_ip_limitbigintThe total number of floating IPs the current user or team may have.
statustextThis value is one of "active", "warning" or "locked".
status_messagetextA human-readable message giving more details about the status of the account.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
uuidtextThe unique universal identifier for the current user.
volume_limitbigintThe total number of volumes the current user or team may have.