sapio365 v1.7 is here!
Version 1.7 is jam-packed with major changes, added features and visible improvements. Start by picking the session type you need according to your Office 365 role and the data you want to access.
Once connected, see how we’ve made managing groups even easier by seeing who is a member, owner, guest or contact and manage them all in one place. You’re even able to manage private channel members, site content and chats – even if you’re not an owner.
You’ll also experience greater control of sapio365 RBAC, richer usage reports, the ability to check in checked out files, change Teams settings, and lots more – update sapio365 today or download it below!
Top new features
Choose your sapio365 session type more easily
We’ve relabeled sapio365 sessions according to the scope they provide you. Start a Standard session if you can’t get admin consent or if you’ve been assigned a role through sapio365 RBAC. Otherwise, launch an Advanced session and get access equivalent to your Office 365 role, but with so much more at your disposal! And if you’re a global admin, simply elevate your privileges to get access to mailbox and site content you don’t own.
Manage group members AND owners in the same place
Query your groups for their members in sapio365 and you’ll notice the group owners displayed in the same grid. It’s now easier to add or remove members and owners from groups – you’ll even see if they are active users, guests or contacts.
Add or remove private channel members
You can now add or remove members for several private channels in one shot in the new Private Channel Members submodule (accessible from the Channels module). There, you can transform members into owners or vice versa. And when you add new non-Team members to a channel, they get added to the Team automatically – saving you valuable time!
Find and discard checked out documents
We’ve added checkout information in all Files modules so you can get an instant idea of what’s been checked out and by whom in your environment – even if you’re not the SharePoint site owner! Easily discard as many checked out documents as you want with a click.
Combine Usage Reports into a single, more meaningful document
You don’t need to process separate reports to answer usage questions regarding users or groups. sapio365 lets you merge data from several detailed Usage Reports to create a super report that you can refine to get a more complete picture of user activity or group usage.
General additions and enhancements
Along with some minor fixes and improvements that smooth out the user experience, the following general changes are noteworthy because they have an important impact on how you use sapio365.
Set sapio365 RBAC logging and enforcement parameters
When you assign users to roles you create in sapio365 RBAC, you now have the options to log when a role is used and by whom, which sapio365 modules are being accessed, and to enforce the taking on of a role when assigned users sign-in to a Standard session.
Show or hide columns while navigating the Column Map
You can now continuously customize your grid view with the Column Map without closing it, all from the ‘Show/Hide columns’ in the right-click menu. Choose ‘Show column with ID’ to include property technical names in the Column Map.
Less pervasive error messages
Errors sometimes occur when retrieving data from Office 365 because you don’t have access or it no longer exists. We now let you know in a more subtle way by displaying a message in the grid header.
Invert regex queries
Sometimes you just need the opposite of a regex operation. We’ve added a NOT function so that you can get exactly what you want when using regex in a search, filter, etc.
Improved comment management
Managing sapio365’s in-app user comments now includes editing, deletion of entries, refreshing the grid display, and hiding out-of-scope comments.
Improved pivot table function
You can now format all axes in a pivot table. You’ll also have access to a hierarchy view, the use of JavaScript functions to transform values, and the capability to navigate and drill down charts.
Better Azure Cosmos DB connection with more options
Loading and updating data to Azure Cosmos DB is generally faster. You can now select from existing Cosmos DB accounts to connect to your license, or you can clean up unused accounts created by sapio365 in the ‘Set Cosmos DB Connection Info’ section of About sapio365.
Ready to Schedule
New Jobs Added
Report users by disabled service plan
Schedule this job to keep an eye on services your users have available with their licenses, but have still not been enabled.
View private channel sites
If your Office 365 allows the creation of private channels, you can schedule this job to search through Teams and email the list of private channels straight to your mailbox.
What’s new in reports
See documents with retention labels applied
You can now see if any retention labels have been applied to files in OneDrive, Teams documents and site library documents. Simply select your files and click ‘Load Info’ button.
View files only – hide folders
Folders are now hidden by default when choosing a flat view in OneDrive Files, Group Files and Site Files modules. In this flat view, all you see is a convenient list of documents. And to unhide them, just click the ‘Show Folders and Notebooks’ button.
What’s new in Users
New Jobs Added
Download messages as EML files
If you ever want to save important messages locally without backing up the entire mailbox, use the ‘Download as EML’ button in the Messages module. Open the EML file using any email client to view the message content, including attachments.
Delete users’ mail rules
Since sapio365 helps you find potentially dangerous mail forwarding inbox rules set up by users, it’s only natural to let you remove them with a click. Be on the lookout for rule editing capabilities in the next release!
Revoke users’ access to Office 365 applications
Instead of revoking access tokens one user at a time in the admin portal, or going in blind with PowerShell, simply click on the new ‘Revoke Access’ button in sapio365 for any selection of users. Watch how the time value in the ‘Sign-in Sessions valid from’ column resets as users are required to re-sign in to all Office 365 applications within the next 15 minutes.
Reset passwords or force users to change it on sign-in
You now have the choice to reset users’ passwords or force them to change it on the next sign-in, or to do both. This includes the option of requiring users to sign in using Multi-Factor Authentication (MFA).
Get partial grid update when cancelling a Refresh All
When you cancel a ‘Refresh All’, you’re now offered the option to update the grid with partial results in the Users module.
Create a user from a template
When creating a new user, you can now select existing users to prefill the creation dialog with their common properties like department, country, office, etc.
What’s new in Groups & Teams
Get access to private channel chats
If you want to avoid adding yourself to private channels to access their chats, you can request authorization from Microsoft to use protected APIs used by sapio365. We’ve made things easier with a guide on filling out the form. You can access it by clicking on the ‘Request access (private channel chats)’ button under ‘New Advanced Session’.
Access private channels’ SharePoint sites
Having a hard time identifying SharePoint sites associated to your Team private channels? Select all private channels in the Channels module and click on the new button ‘Sites…’ to get info like URL, created on, last modified, etc.
Get private channel members & library storage info in the Channels module
Before you head over to manage private channel members, you can preview them in the newly-added column ‘Channel members’ in the Channels module. We’ve also added some site library information here. Simply click on ‘Load Info’ to retrieve them.
Edit Teams settings
Bulk update your settings for Teams in the Groups module, including member settings, guest settings, messaging and fun settings.
Show or hide nested group members
Nested group members are now hidden by default in the Group members module. Display them by clicking on the ‘Nested Group’ button in the ribbon.
New column properties for ‘Icon’ and ‘Extension’ added to attachment info in Group Conversation Posts
With these two new columns, you can now filter or categorize post attachments by their extension or their representative icon.
Create an Office 365 group from a template
Just like for users, when creating a new group, you can now select existing groups to prefill the creation dialog with some basic properties they have in common like name, description and privacy.
What’s new in SharePoint sites
Added new columns: Library storage information
Just like in the Users and Groups modules, we’ve added property columns displaying various drive information for SharePoint sites. Sort and filter relevant columns to see which sites have reached their consumption quotas, or categorize them by their quota state to get a general picture of storage consumption.