Your admin bestie has a new look and more features to make your life easier

It’s the same tool you love but prettier! The first thing you’ll see is a new dashboard with more entry points to your Microsoft 365 data. Run or schedule your saved Views from the new Quick GridView and Usage Reports sections, or create a pdf of important statistics in the new Business Reports.

This latest version of sapio365 is really much more than just a makeover. It’s also jam-packed with important improvements and several new features that help you with your admin tasks.

We’ve simplified how you sign into sapio365 if you’re using a sapio365 RBAC role, and the Refresh processes are more flexible and faster. You no longer have to wait for a new sapio365 release to find new automated jobs, views and business reports. Finally, you can now manage registered devices, retrieve the full list of personal SharePoint Online sites, check out two new Entra usage reports, manage email aliases of cloud accounts and so much more!

Scroll down to see highlight details or click on the links below:

• sapio365 RBAC multi-tenant roles now available
• Use sapio365 with GCC High tenants
• Manage registered devices, their users and owners
• Access all Personal SharePoint Sites (OneDrive), including orphans
• Analyze your Copilot usage report or Teams team activity report
• Pre-filter Registered Applications or Service Principals
• Exclude selected Microsoft licenses from analysis
• Save more GridView configurations in custom Views
• Get target details directly from the Admin Audit Logs
• More GridView filters added
• Set the Organizational Unit (OU) of new users
• Manage users’ email aliases, username or email domain
• Manage users’ Litigation Hold or Retention Hold state
• See more user account properties
• Manage more group member types
• Create Teams directly
• See when Teams channels were created or if they’re archived

Leveraging sapio365’s Role-Based Access Control (RBA) to delegate tasks across several tenants lets you hand over precise access rights without giving away the keys to the kingdom. The RBAC roles you customize are now available for multiple credential sets so that you don’t have to clone them for each tenant that you manage. You can even add sapio365 RBAC credentials based on customer contracts (Managed Service Providers).

Know a frustrated admin managing a Microsoft 365 GCC High tenant? Quick, be a good friend and let them know that sapio365 now works with National Cloud deployments! A couple of adjustments and they’ll be well on their way to saving precious admin time.

You can now load registered devices using pre-filters. You’ll be able to manage registered users for selected devices. You can also enable or disable devices, see device owners and manage them too.

Retrieve information on all Personal SharePoint Sites (OneDrive) to discover orphan sites, or pre-filter them from the main sapio365 window. You can also pre-filter SharePoint Online sites to limit your results. These new entry points are available in Elevated or App sessions only.

Combine the data from the new Copilot Usage Report with data from other usage reports, and enrich it with extra user information. You can also now access the Teams team activity report for statistics on how Teams are being used in your tenant.

Limit the number of Registered Applications or Service Principals you retrieve by using designated pre-filters. You can use a combination of property values as your filter criteria.

Good news! You can now automatically omit all those free Microsoft license assignments that clutter your licensing cost reports. Simply set these irrelevant licenses to ‘Exclude’ in the Licenses And Service Plans window. Once set, license relevance will be shown in related windows (Users, Groups, etc) with columns ‘Is Assigned an Included License’ and ‘Inclusion – Assigned Licenses’. Apply filters on these columns to exclude them from your views.

Creating custom Views in sapio365 is a quick shortcut to creating recurrent reports based on data that you sort, filter, or group just so. You now have the ability to save a View’s exploded state of multivalues, hierarchy filter settings and module-specific state like the “Show Plans” state in the Licenses module. You can even save temporary comment columns that only show when you’re using that view! Bring your most used Views to the top of the list by setting them as favourites.

Since Admin Audit Logs record admin actions like changes to user accounts or groups, you can now get more details on the target in sapio365 whether it’s a user, group, service principal, registered application or device. Simply select the log entry and click on the relevant button in the ‘Target Management’ section in the ribbon to load the target’s details.

If your data analysis includes properties that have empty values, you’ll be glad to see a filter to retain empty value cells only in addition to the existing one that excludes them. We’ve also improved value filters to list only unique values when applied on a multi-value property. Are you looking to create a custom view based on expiration dates? Use a cut-off filter for future date values, and schedule that view for a weekly report on passwords that will expire within the week.

Do you create on-prem user accounts on the regular? sapio365 lets you create an account or import a bunch of them from a file in a few clicks. Now, you can also specify which Organizational Unit (OU) you want to create them in. Choose from a list of existing OUs or enter an OU’s canonical name, and you’re on your way to easy bulk importing to your on-prem Active Directory.

Have some of your users’ alias lists grown out of control? You can update a user’s alias list by removing or adding aliases in sapio365. sapio365 will even validate if the email domain you’ve entered is part of the current tenant’s domain list.

You can now see the name of the retention policy (retrieved by loading ‘Mailbox info’) applied on your user accounts and update the state of the retention hold. You can also enable a Litigation hold on the mailbox and set its duration.

See when users last signed in successfully by looking up new “Last sign-in” related properties ‘lastSuccessfulSignInDateTime’ and ‘lastSuccessfulSignInRequestId’. Look up “registration” term for new usage properties that help you understand how users in your organization are using Microsoft Entra authentication capabilities, such as multifactor authentication (MFA), Self-Service Password Reset (SSPR), and Passwordless authentication. You can retrieve all their values by loading ‘Additional Info’.

If your groups’ members include Service Principals, Microsoft 365 or security groups, you can now see these members in the Group Members window. Additionally, you can add or remove them from groups. Use filters to help you isolate them for your selection from the directory when adding them to groups.

You now have the option to create a Team directly in sapio365. Simply toggle the ‘Is a Team’ option to ‘Yes’ when creating a Microsoft 365 group.

Look up newly added Teams channel properties ‘Created on’ and ‘Archived’ to customize a View for a creation report. And if your tenant embraces shared channels from other tenants, you’ll see these checked on the column property ‘External’.

So many new and exciting features! We hope you’re excited to try them all out. If you have any questions or need more information, please reach out to us. With sapio365 v3, the best just got better!

How to Create an Entra ID Activity Summary Report from Microsoft Office 365 Admin Audit Logs

The Mystery of One School Board’s Vanishing Microsoft Office 365 Storage Space

The Savvy Admin’s Guide to Audit Logs in Office 365

What you need to know about Microsoft Office 365 Audit Logs and Office 365 license assignment dates