turbot/digitalocean
steampipe plugin install digitalocean

Table: digitalocean_account - Query DigitalOcean Accounts using SQL

DigitalOcean is a Cloud Infrastructure Provider that offers scalable compute platforms with add-on storage, security, and monitoring capabilities. Users can create, automate, manage, and scale cloud applications efficiently on DigitalOcean. The account resource in DigitalOcean provides information about the user's account.

Table Usage Guide

The digitalocean_account table provides insights into the user accounts in DigitalOcean. As a cloud engineer or system administrator, you can explore account-specific details through this table, such as account status, droplet limit, email, and more. Utilize it to manage and monitor your DigitalOcean accounts effectively and efficiently.

Examples

Account information

Explore your DigitalOcean account details to better understand your account settings and configurations. This can be beneficial when managing your resources or when you need to verify your account information.

select
*
from
digitalocean_account;
select
*
from
digitalocean_account;

Check current status of your account

Explore the current status of your DigitalOcean account to understand any potential issues or updates. This could be useful for troubleshooting or maintaining account health.

select
status,
status_message
from
digitalocean_account;
select
status,
status_message
from
digitalocean_account;

Check usage of limits in your account

Analyze the utilization of your account's resources to understand how close you are to hitting your limits. This is useful for efficient resource management and avoiding potential disruptions due to exceeding limits.

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;
select
(
select
count(urn)
from
digitalocean_droplet
) as droplet_count,
droplet_limit,
round(
100.0 * (
select
count(urn)
from
digitalocean_droplet
) / droplet_limit,
1
) as droplet_usage_percent,
(
select
count(urn)
from
digitalocean_volume
) as volume_count,
volume_limit,
round(
100.0 * (
select
count(urn)
from
digitalocean_volume
) / volume_limit,
1
) as volume_usage_percent,
(
select
count(urn)
from
digitalocean_floating_ip
) as floating_ip_count,
floating_ip_limit,
round(
100.0 * (
select
count(urn)
from
digitalocean_floating_ip
) / floating_ip_limit,
1
) as floating_ip_usage_percent
from
digitalocean_account;

Schema for digitalocean_account

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
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.