Table: azuredevops_dashboard - Query Azure DevOps Dashboards using SQL

Azure DevOps Dashboards are a customizable interactive signboard that provides real-time information, analytics, and insights. They are a place to find quick answers and information about the work items and builds. Dashboards are customizable and can contain charts, graphs, and lists, among other things.

Table Usage Guide

The azuredevops_dashboard table provides insights into the dashboards within Azure DevOps. As a project manager or team lead, explore dashboard-specific details through this table, including layout, widgets, and associated metadata. Utilize it to uncover information about the dashboards, such as their configuration, the widgets they contain, and their layout.

Examples

Basic info

Discover the segments that are linked to your Azure DevOps dashboard, including the project and group it belongs to, as well as its owner. This can help in managing and organizing your projects more efficiently.

select
  id,
  name,
  dashboard_scope,
  project_id,
  owner_id,
  group_id
from
  azuredevops_dashboard;

select
  id,
  name,
  dashboard_scope,
  project_id,
  owner_id,
  group_id
from
  azuredevops_dashboard;

List dashboards with project scope

Discover the dashboards that are specifically scoped to projects in Azure DevOps. This is useful for assessing the distribution of resources and managing project-specific data.

select
  id,
  name,
  dashboard_scope,
  project_id,
  owner_id,
  group_id
from
  azuredevops_dashboard
where
  dashboard_scope = 'project';

select
  id,
  name,
  dashboard_scope,
  project_id,
  owner_id,
  group_id
from
  azuredevops_dashboard
where
  dashboard_scope = 'project';

List dashboards of a particular project

Discover the segments that belong to a specific project by identifying all associated dashboards. This is beneficial in understanding the structure and distribution of resources within a particular project.

select
  d.id as dashboard_id,
  d.name,
  d.dashboard_scope,
  d.project_id,
  d.owner_id,
  d.group_id
from
  azuredevops_dashboard as d,
  azuredevops_project as p
where
  d.project_id = p.id
  and p.name = 'private_project';

select
  d.id as dashboard_id,
  d.name,
  d.dashboard_scope,
  d.project_id,
  d.owner_id,
  d.group_id
from
  azuredevops_dashboard as d,
  azuredevops_project as p
where
  d.project_id = p.id
  and p.name = 'private_project';

Get owner details of a particular dashboard

Explore the teams associated with a specific Azure DevOps dashboard to understand its ownership and associated project details. This can be useful for auditing purposes or to manage permissions and access controls.

select
  t.id as team_id,
  t.name,
  t.project_id,
  t.project_name
from
  azuredevops_dashboard as d,
  azuredevops_team as t
where
  d.owner_id = t.id
  and d.name = 'test';

select
  t.id as team_id,
  t.name,
  t.project_id,
  t.project_name
from
  azuredevops_dashboard as d,
  azuredevops_team as t
where
  d.owner_id = t.id
  and d.name = 'test';

Schema for azuredevops_dashboard

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
dashboard_scope	text		Entity to which the dashboard is scoped.
description	text		Description of the dashboard.
etag	text		Server defined version tracking value, used for edit collision detection.
group_id	text	=	ID of the group for a dashboard. For team-scoped dashboards, this is the unique identifier for the team associated with the dashboard. For project-scoped dashboards this property is empty.
id	text		ID of the dashboard. Provided by service at creation time.
links	jsonb		The class to represent a collection of REST reference links.
name	text		Name of the Dashboard.
organization	text	=, !=, ~~, ~~, !~~, !~~	The name of the organization.
owner_id	text		ID of the owner for a dashboard. For team-scoped dashboards, this is the unique identifier for the team associated with the dashboard. For project-scoped dashboards, this is the unique identifier for the user identity associated with the dashboard.
position	bigint		Position of the dashboard, within a dashboard group. If unset at creation time, position is decided by the service.
project_id	text	=	ID of the project this dashboard belongs to.
refresh_interval	bigint		Interval for client to automatically refresh the dashboard. Expressed in minutes.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title of the resource.
url	text		URL of the dashboard.
widgets	jsonb		The set of Widgets on the dashboard.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- azuredevops

You can pass the configuration to the command with the --config argument:

steampipe_export_azuredevops --config '<your_config>' azuredevops_dashboard