turbot/microsoft365
steampipe plugin install microsoft365

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
classificationtextAn 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_timetimestamp with time zoneDate and time when the team was created.
descriptiontextA description for the team.
display_nametextThe name of the team.
idtext=The unique id of the team.
internal_idtextA unique ID for the team that has been used in a few places such as the audit log/Office 365 Management Activity API.
is_archivedbooleanTrue if this team is in read-only mode.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
specializationtextIndicates 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.
summaryjsonbSpecifies the team's summary.
templatejsonbThe template this team was created from.
tenant_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Tenant ID where the resource is located.
titletextTitle of the resource.
visibilitytextThe visibility of the group and team. Defaults to Public.
web_urltextA 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