turbot/digitalocean

steampipe plugin install digitaloceansteampipe plugin install digitalocean

Table: digitalocean_action

Actions are records of events that have occurred on the resources in your DigitalOcean account. These can be things like rebooting a Action, or transferring an image to a new region.

Examples

List Actions

select
*
from
digitalocean_action;

Get an action by ID

select
*
from
digitalocean_action
where
id = 1101196049;

Droplets created today

select
d.name,
d.private_ipv4,
a.resource_type,
a.type,
a.id as action_id
from
digitalocean_action as a,
digitalocean_droplet as d
where
a.resource_id = d.id
and a.type = 'create'
and a.resource_type = 'droplet'
and a.started_at > now() - interval '24 hours';

Resources deleted in the last 3 days

select
*
from
digitalocean_action
where
type = 'destroy'
and a.started_at > now() - interval '3 days';

Creations by resource type in the last week

select
resource_type,
count(*)
from
digitalocean_action
where
type = 'create'
and started_at > now() - interval '1 week'
group by
resource_type
order by
count;

.inspect digitalocean_action

Actions are records of events that have occurred on the resources in your account. These can be things like rebooting a Action, or transferring an image to a new region.

NameTypeDescription
completed_attimestamp without time zoneTime when the action was completed.
idbigintA unique numeric ID that can be used to identify and reference an action.
region_slugtextThe region where the action occurred.
resource_idbigintA unique identifier for the resource that the action is associated with.
resource_typetextThe type of resource that the action is associated with.
started_attimestamp without time zoneTime when when the action was initiated.
statustextThe current status of the action. This can be "in-progress", "completed", or "errored".
typetextThis is the type of action that the object represents. For example, this could be "transfer" to represent the state of an image transfer action.