steampipe-plugin-azuredevops

README

Azure DevOps Plugin for Steampipe

Use SQL to query projects, groups, builds and more from Azure DevOps.

• Get started →
• Documentation: Table definitions & examples
• Community: Join #steampipe on Slack →
• Get involved: Issues

Quick start

Download and install the latest Azure DevOps plugin:

steampipe plugin install azuredevops

Configure your credentials and config file.

Configure the Organization URL and Personal Access Token in ~/.steampipe/config/azuredevops.spc:

connection "azuredevops" {
  plugin = "azuredevops"
  # Authentication information
  organization_url = "https://dev.azure.com/test"
  personal_access_token = "wf3hahidy7i7fkzmeqr3e6fbjwuspabpo766grp7hl4o65v2"
}

Or through environment variables:

export AZDO_ORG_SERVICE_URL=https://dev.azure.com/test
export AZDO_PERSONAL_ACCESS_TOKEN=wf3hahidy7i7fkzmeqr3e6fbjwuspabpo766grp7hl4o65v2

Run steampipe:

steampipe query

List your Azure DevOps projects:

select
  id,
  name,
  state,
  visibility
from
  azuredevops_project;

+--------------------------------------+-----------------+------------+------------+
| id                                   | name            | state      | visibility |
+--------------------------------------+-----------------+------------+------------+
| bdcdf70b-7757-4253-b36c-33c08ca07dbb | test-1          | wellFormed | private    |
| 9a1f26ce-c715-4ef4-b557-503fdb6be55a | private_project | wellFormed | private    |
+--------------------------------------+-----------------+------------+------------+

Developing

Prerequisites:

• Steampipe
• Golang

Clone:

git clone https://github.com/turbot/steampipe-plugin-azuredevops.git
cd steampipe-plugin-azuredevops

Build, which automatically installs the new version to your ~/.steampipe/plugins directory:

make

Configure the plugin:

cp config/* ~/.steampipe/config
vi ~/.steampipe/config/azuredevops.spc

Try it!

steampipe query
> .inspect azuredevops

Further reading:

• Writing plugins
• Writing your first table

Contributing

Please see the contribution guidelines and our code of conduct. All contributions are subject to the Apache 2.0 open source license.

help wanted issues:

• Steampipe
• Azure DevOps Plugin