turbot/digitalocean

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

Table: digitalocean_tag

Examples

Tags by name

select
name,
resource_count
from
digitalocean_tag
order by
name;

Resource counts by tag

select
name,
coalesce((resources -> 'databases' -> 'count') :: int, 0) as database_count,
coalesce((resources -> 'droplets' -> 'count') :: int, 0) as droplet_count,
coalesce((resources -> 'images' -> 'count') :: int, 0) as image_count,
coalesce((resources -> 'volumes' -> 'count') :: int, 0) as volume_count,
coalesce((resources -> 'volume_snapshots' -> 'count') :: int, 0) as volume_snapshot_count
from
digitalocean_tag;

.inspect digitalocean_tag

A tag is a label that can be applied to a resource (currently Droplets, Images, Volumes, Volume Snapshots, and Database clusters) in order to better organize or facilitate the lookups and actions on it.

NameTypeDescription
nametextThe name of the tag. Tags may contain letters, numbers, colons, dashes, and underscores. There is a limit of 255 characters per tag.
resource_countbigintThe number of resources with this tag.
resourcesjsonbAn embedded object containing key value pairs of resource type and resource statistics. It also includes a count of the total number of resources tagged with the current tag as well as a last_tagged_uri attribute set to the last resource tagged with the current tag.