Table: microsoft365_team - Query Microsoft 365 Teams using SQL

Microsoft 365 Teams is a collaborative platform that integrates with Microsoft 365 applications. It is designed to facilitate persistent chat, video meetings, file storage, and application integration. Teams are collections of people, content, and tools that provide a convenient collaboration space for a group of users within an organization.

Table Usage Guide

The microsoft365_team table provides insights into Teams within Microsoft 365. As an IT administrator, explore team-specific details through this table, including team creation, settings, and membership. Utilize it to manage and monitor team activities, such as identifying inactive teams, verifying team settings, and auditing team membership.

Examples

Basic info

Explore which Microsoft 365 teams are currently active, when they were created, and their visibility settings. This can help in understanding the team's structure and accessibility within your organization.

select
  display_name,
  id,
  description,
  visibility,
  created_date_time,
  web_url
from
  microsoft365_team;

select
  display_name,
  id,
  description,
  visibility,
  created_date_time,
  web_url
from
  microsoft365_team;

List private teams

Discover the segments that are private within your Microsoft365 teams. This can be useful for reviewing the configuration of your teams to ensure the right privacy settings are in place.

select
  display_name,
  id,
  description,
  visibility,
  created_date_time,
  web_url
from
  microsoft365_team
where
  visibility = 'Private';

select
  display_name,
  id,
  description,
  visibility,
  created_date_time,
  web_url
from
  microsoft365_team
where
  visibility = 'Private';

List archived teams

Uncover the details of archived teams in your Microsoft 365 environment. This is useful for managing and reviewing the status of collaborative projects that are no longer active.

select
  display_name,
  id,
  description,
  visibility,
  created_date_time,
  web_url
from
  microsoft365_team
where
  is_archived;

select
  display_name,
  id,
  description,
  visibility,
  created_date_time,
  web_url
from
  microsoft365_team
where
  is_archived = 1;

Schema for microsoft365_team

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
classification	text		An optional label. Typically describes the data or business sensitivity of the team. Must match one of a pre-configured set in the tenant's directory.
created_date_time	timestamp with time zone		Date and time when the team was created.
description	text		A description for the team.
display_name	text		The name of the team.
id	text	=	The unique id of the team.
internal_id	text		A unique ID for the team that has been used in a few places such as the audit log/Office 365 Management Activity API.
is_archived	boolean		True if this team is in read-only mode.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
specialization	text		Indicates whether the team is intended for a particular use case. Each team specialization has access to unique behaviors and experiences targeted to its use case.
summary	jsonb		Specifies the team's summary.
template	jsonb		The template this team was created from.
tenant_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Tenant ID where the resource is located.
title	text		Title of the resource.
visibility	text		The visibility of the group and team. Defaults to Public.
web_url	text		A hyperlink that will go to the team in the Microsoft Teams client.

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

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

steampipe_export_microsoft365 --config '<your_config>' microsoft365_team