Reports

Introduction

Prerequisites

As they are generated in the background, you need the advanced or Enterprise authentication configured to have access to it. More info in the following article: Manage Authentication.

 

The reports section can be accessed in the administration section through the Menu.

Screenshot_2022-06-28_at_14.45.26.png

Opening the report page will lead you to a reporting dashboard where you will find a summary of each of your reports. (The feature requires prerequisites, see the section below)

 

Consider that only Microsoft Teams administrators have rights on all the teams of your tenant. If you are not a Microsoft Teams administrator, you will see all the teams but you will be able to interact with the teams you are an owner of.

 

 

Reports Dashboard

On this page, you can see the number of teams on your tenant, the number of teams concerned by each report, and the evolution of this number compared to the last week.

screencapture-teams-powell-software-Home-AdminIndex-2022-07-29-15_27_05.png

*Through your reports dashboard, you will be able to download a CSV file for all teams in your tenant. This file contains all existing report columns in a single place. This allows you to create personalized reports on Power BI or other third-party tools. We recommend to use UTF-8 encoding table if you are using Excel to open the file.

Capture_d__cran_2022-07-29_152914.jpg

To access the report's detail, click the report card. It will open a page detailing each report with concerned teams.

For example: if you click the report "teams without a template," you will access the page that will list all teams that are missing a template. You can download the report information as a . CSV file by clicking the button on the top right corner of the page.

screencapture-teams-powell-software-Home-AdminIndex-2022-07-29-15_31_47.png

 

For every report on the report dashboard, you will be able to:
  • Access the list of teams for each report
    Capture_d__cran_2022-07-29_153706.jpg
  • Download the CSV to create personalized Power BI reports, for example.
    Capture_d__cran_2022-07-29_153302.jpg
  • Modify the team information through the edit button​ - general information, members/owners,  associated template.
    Capture_d__cran_2022-07-29_153457.jpg
  • Send a message to team owners to notify them about the governance issues concerning their teams. Clicking the button "send a message to team owners", will permit opening a panel, where you can select team owners from the list. As you do so, it will open a chat in Microsoft Teams where you will be able to personalize your message and notify team owners about what needs to be corrected. 
    Capture_d__cran_2022-07-29_153457cc.jpg

 

Let us walk you through each report available on the Reports Dashboard. 

 

Report: Expired Teams

Screenshot_2022-06-28_at_22.44.51.png

You can set an expiration delay for the created team in the template settings. 

If you set the expiration delay as 90 days,  teams created based on that template will expire in 90 days.

You can manage all expired teams through reports by clicking the "expired teams" report card.

We will extend the team expiration feature in the nearest future with additional actions when a team is expired or expires soon.

 

Expired teams list

MicrosoftTeams-image__2_.png

On the report "Expired teams," you have the list of all expired teams. 

 

The expired teams' list displays:

  • The team title
  • The expiration date
  • The template name applied to the team
  • The number of team owners
  • The number of team members
MicrosoftTeams-image__3_.png
 
  • The search box allows you to find the desired team.
  • Click the team title to access detailed information for each team.
  • To view the template applied on the team, click the template name. 

 

Report: Teams with Guests

Screenshot_2022-06-28_at_22.31.57.png

The report "Teams with external users" lists all teams using guests.

The  list  displays:

  • The team title
  • The template applied to the team
  • The number of team owners
  • The number of team members
  • The number of guests

*CSV button to download your report as a CSV file.

Screenshot_2022-06-28_at_22.32.02.png

 

Report: Teams with insufficient owners

Screenshot_2022-06-28_at_22.49.09.png

The report "Teams without insufficient owners" lists teams that have less than X owners. 

You can specify the maximum number of team owners to display on the page in the report. Choose the number and click save. 

Screenshot_2022-06-28_at_22.56.55.png

The  list  displays:

  • The team title
  • The template applied to the team
  • The number of team owners
*CSV button to download your report as a CSV file.

 

Report: Teams with insufficient members

 

Screenshot_2022-06-28_at_22.54.54.png

The "Teams without insufficient members" report lists teams with less than X members. 

You can specify the maximum number of team owners to display on the page in the report. Choose the number and click save. 

Screenshot_2022-06-28_at_23.01.05.png

The  list  displays:

  • The team title
  • The template applied to the team
  • The number of team members
  • The number of guests
*CSV button to download your report as a CSV file.
 

 

Reports: Teams with Missing owners 

Screenshot_2022-06-28_at_22.49.33.png

The Reports "Teams with missing owners" will list teams that are missing owners.. 

When a team is created based on a particular template, it will follow the configurations set in the template, including the minimum number of owners. 

For example: If the minimum number of owners in the template is set to 2, the team cannot be created if this requirement is not fulfilled. 

However,  team owners can leave the team after the team creation. Suppose the team is missing owners based on the minimum number required in the template settings. In that case, this page will notify administrators with a red exclamation mark next to owners.

Screenshot_2022-06-28_at_23.04.45.png

 

 

Reports: Teams with Missing members

Screenshot_2022-06-28_at_23.04.08.png

The Reports "Teams with missing members" will list teams that are missing members. 

 

When a team is created based on a particular template, it will follow the configurations set in the template, including the minimum number of members. 

For example: If the minimum number of members in the template is set to 2, the team cannot be created if this requirement is not fulfilled. 

However,  team members can leave the team after the team creation. Suppose the team is missing members based on the minimum number required in the template settings. In that case, this page will notify administrators with a red exclamation mark next to owners or members.  

Screenshot_2022-06-28_at_23.04.36.png

 

 

Report: Inactive Teams

Screenshot_2022-06-28_at_23.11.36.png

The report "Inactive Teams" will list inactive teams or simply those not used by their members anymore. This will help eliminate unnecessary, excessive teams.

What do we consider an inactive team?

Last access: We use the team "Last activity date" provided by Microsoft.

"The latest Date the group received a message. - This is the latest date an activity happened in an email conversation, Yammer, or the Site."

For more detailed information, click here.

No document modification since

A team will appear inactive when no document has been modified on the group linked to the team since "X" days. Adding or deleting a document is considered a modification. Modifications made on the group-hosted documents synchronized on a personal drive are also considered activities.

 

⚠️ Inactivity status can have up to 3 days delay in the Microsoft Graph calls

Screenshot_2022-06-28_at_23.12.14.png

The inactive teams' list  displays:

  • The team title
  • The template used as a reference for the team
  • Number of team owners
  • The number of team members
  • The number of guests
  • Last Activity date - when was the last time the team was active. 

 

Keep in mind that, If you edit the teams, the changes will be applied immediately to the team, and the report will be updated in the next report synchronization.

 

How do we define when a team is inactive.

The team is defined as inactive if there are no messages, replies, document modifications, or access to the group since a specific date. 

You can filter your teams according to the last activity date. For example, if you put "90" days, the list will display teams that have not been active for 90 days. Respectfully, if you put "30" days, the list will display teams inactive for 30 days. 

Screenshot_2022-06-28_at_23.13.40.png

The administrators can change the report and define the maximum number of days that will determine the inactivity of teams, as shown above.

For example: if you insert the number 30, it means that if for 30 days there was no activity in the team, the team will be considered inactive.

 

Report: Teams with privacy not respected

Screenshot_2022-06-28_at_23.22.53.png

The Report  "Teams with privacy not respected" lists teams that do not correspond to the privacy settings defined in their template. 

After a team has been created with a template with a privacy configuration, it can then be modified by owners during the team's life. It can also be the case for teams that have been associated with a template after their creation.

If teams do not match their template settings, they will be highlighted in the report.

The list will display: 

  • The team title
  • The team privacy
  • Privacy settings of the associated template

privacy.jpg

 

Report: Teams without template

Screenshot_2022-06-28_at_23.26.14.png

The report "Teams without templates" lists teams not associated with a Powell Teams template. Either during the team creation or after a team modification.

It is crucial to identify those teams and apply templates to them to ensure that governance rules are taken into account for those teams.

The list displays: 

  • The team title
  • Number of team owners
  • The number of team members
  • The number of guests

Screenshot_2022-06-28_at_23.26.06.png

 

Report: Inactive Teams with guests

This report will list inactive teams (90 days being the number of days determining inactivity) that contain guest users. 

Screenshot_2022-06-28_at_14.03.53.png

The list displays: 

  • The team title
  • The template used as a reference for the team
  • Number of team owners
  • The number of team members
  • The number of guests
  • Last file update
  • Activity status

Screenshot_2022-06-28_at_23.30.47.png

 

Report: Big Teams (>1GB)

MicrosoftTeams-image__1_.png

This report will list teams with more than 1GB of document storage.

The list displays: 

  • The team title
  • The template used as a reference for the team
  • The team size
  • The number of documents
  • Number of team owners
  • The number of team members
  • The number of guests

MicrosoftTeams-image__5_.png

 

 

 

Report: Public Teams

This report will list all the public teams existing on your tenant.

Screenshot_2022-06-28_at_14.03.46.png

The list displays: 

  • The team title
  • The template used as a reference for the team
  • The team privacy 
  • Number of team owners
  • The number of team members
  • The number of guests

 

Was this article helpful?
0 out of 0 found this helpful