We are thrilled to share with you that Powell Teams is now Powell Governance, marking our expanded focus on Microsoft 365!

Expect documentation to be reflect this change in the coming days. For more information, please have a look at this article.

Powell Governance brings you native reports in the administration center based on most commun governance risks and information to monitor. With custom reports, you have the ability to build your own reports based on the rules that matter the most for your company.

Whether it's about having control over the inactivity period or tracking very specific teams, such as teams without owners containing the word "test" in their name, Custom Reports in Powell Governance empowers you to tailor your reports to meet your unique needs looking at Teams, SharePoint sites and users.

Create a new custom report

Custom reports can be created from scratch or based on an existing report. I can help you to set up your new templates easily or simply edit a property of an existing report. Duplicating an existing report (from Powell Governance or another custom report) will open the report builder interface with a preconfiguration based on the reference report. 

To start your report you will first need to set up a title and a description to it. It will allow you to find your new reports easily.

Then you have to chose on which kind of information your report will display:

• Teams - Updated in live (few minutes of delay after an update from Powell Governance or a Microsoft tool)
• SharePoint sites - Updated once a day
• Users - Updated once a day

After that you can configure the heart of your report: the properties. Depending on the type of property used, you will be able to filter the teams based on the value of each property.

Chose the property, then add an operator and then the value you want. Here my first property is "Number of team owners" equals to "0" as I want to see only the team that have no owner.

Then my second one is "Team name" contains "test" as I also want to see only the team that contains "test" in their names.

In the exemple, my properties are linked with a "And" but it is also possible to use a "Or" between them to build your rules.

You can chose if the relation between the properties are exclusive or not with "And" or "Or". When you configure more than one condition blocks, then the relation between those blocks are an "And".

For each type of report source, we will have different properties to use to build your report.

Teams:

• Associated tag
• Associated tag values
• Creation date
• Document storage (GO)
• Expiration delay (days)
• Governance status respected
• Guest acceptance in template
• Has a company policy
• Is archived
• Is associated to a template
• Last guest review date
• Last guest review delay (days)
• Last team chat delay (days)
• Last team document modification delay (days)
• Last team update delay (days)
• Name
• Number of channels, documents
• Number of guests
• Number of members
• Number of owners
• Number of private channels
• Number of teams applications
• Sensitivity label
• Sensitivity label rule respected
• Team classification
• Team created from Powell Governance
• Template guest rule accepted
• Template Id
• Template minimum number of member rule respected
• Template minimum number of owner rule respected
• Template naming rule name
• Template naming rule respected
• Template tags rule respected
• Template visibility rule respected

SharePoint sites:  

• Associated tag
• Associated tag values
• Created from Powell Governance
• Expiration delays (days)
• External sharing
• Governance status respected
• Has company policy
• Is archived
• Is associated to a template
• Is delete
• Last update delay (days)
• Number of site documents
• Number of site guests
• Number of site members
• Number of site owners
• Number of site visitors
• Sensitivity label
• Sensitivity label rule respected
• Site creation date
• Site created from Powell Governance
• Site delete date
• Site description
• Site Id
• Site name
• Site storage limit (GO)
• Site storage usage (GO)
• Site storage used %
• Site type
• Site url
• Template guest rule respected
• Template Id
• Template minimum number of members rule respected
• Template minimum number of owners rule respected
• Template name
• Template tags rule respected

Users:

• Is a guest
• Number of workspaces a user is owner of

• Number of workspaces a user is member of

• Number of teams a user is owner of

• Number of teams a user is member of

• Number of sites a user is owner of

• Number of sites a user is member ofPowell Governance user role,

• User Azure AD Id

Once your rules are well defined, you can now configure the table of your new custom report.

In the same exemple, I want to see in my report table the following columns: Team name, Number of team owners, Number of team members and the status of the team. It is possible to reorder those columns as you want.

Define a default order on your results with the last section" Order by"

That's it, your report can now be tested! To do so, click on "Preview" on at the bottom of the page to see the result of your configuration before saving it.

(I had to change the rule to 1 owner as no teams were found on the tenant used to take the screenshot with the exemple configuration).

Edit or delete a custom report

After the report creation, you can still take actions on your report.

• Duplicate allow you to start a new report creation based on your custom report
• Edit the report will open the report builder allowing you to change some configurations
• Delete will remove the custom report from the list of all Powell Governance administrators of your tenant