Table: grafana_team_member - Query Grafana Team Members using SQL

Grafana Team Members are the users associated with a specific team in Grafana, a multi-platform analytics and visualization software. Team Members have specific roles and permissions within the team, which determine their access and capabilities in Grafana. Understanding the members and their roles is crucial for managing access and permissions effectively within Grafana.

Table Usage Guide

The grafana_team_member table provides insights into the team members within Grafana. As a system administrator, you can explore member-specific details through this table, including their role, email, and associated metadata. Use it to manage and monitor user access and permissions, ensuring appropriate security and functionality within your Grafana teams.

Important Notes

You must specify the team_id in the where clause to query this table.

Examples

List all members for a team

Explore which users are part of a specific team in Grafana, useful for understanding team composition and managing user access rights.

select
  *
from
  grafana_team_member
where
  team_id = 1;

select
  *
from
  grafana_team_member
where
  team_id = 1;

List all members of all teams

Explore which members belong to which teams in Grafana to understand team composition and facilitate effective communication. This is useful for managers to keep track of team structures and ensure the right teams are working on the right projects.

select
  t.name,
  tm.login,
  tm.email
from
  grafana_team as t,
  grafana_team_member as tm
where
  tm.team_id = t.id;

select
  t.name,
  tm.login,
  tm.email
from
  grafana_team as t,
  grafana_team_member as tm
where
  tm.team_id = t.id;

Schema for grafana_team_member

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
avatar_url	text		URL of the avatar for the user.
email	text		Email of the user.
login	text		Login of the user.
org_id	bigint		ID of the org.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
team_id	bigint	=	ID of the team.
user_id	bigint		ID of the user.

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)" -- grafana

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

steampipe_export_grafana --config '<your_config>' grafana_team_member