sapio365 Version History

See where sapio365 has been

sapio365  2.1.7.2

July 25 2022

For the latest version of sapio365 click here
Special Hot Fix
  • Fixed sapio365 update issue when using Role session in relation to CosmosDB.
sapio365  2.1.7

July 14 2022

What’s new in the latest version?

New features

  • Added ability to lock sapio365 with a master password. You can now walk away from your station without signing out of your sapio365 sessions each time.
  • Added option to set privacy on security groups in group creation dialog.
  • Added calendar view option when loading users’ and groups’ calendar events to list the contents of the Outlook calendar view. You will also be able to load series master info from there for series instances if you want to manage the whole series of events.
  • Added ability to assign groups to roles in the Access & Restrictions panel.
  • Added ticketing system option for save operations. The saved ticket information is then available in the User Activity Logs for audits. You can manage this option in Preferences.
  • Added new view in Users to focus on the Custom Attributes.
  • Added cache option to use a SQL database on a server instead of the local cache. This enables users to share a common data cache which is much easier to keep updated with a scheduled ‘Update cache of Users, Groups and Sites’ job.

General fixes and improvements

  • Now using Webview2 runtime. Improved dialogs and other HTML-based UI by upgrading to Microsoft Edge WebView2. This replaces the embedded Internet Explorer which has reached its end of life.
  • Fixed issue which resulted in the Script Error shown when sapio365 started.
  • Improved dialog navigation with new keyboard shortcut options (available in help documentation) and history of last inputs on fields.
  • Improved license-check dialog to indicate if the current license is linked with a Cosmos DB set to a different Microsoft 365 tenant.
  • Improved sapio365 window UI by adding tooltips “Minimize the Ribbon / Expand the Ribbon” and “Go to Help Documentation” for top right icons.
  • Fixed issue where sapio365 requests time out by improving the automatic retry process. You will also see a countdown displayed.
  • Improved sapio365 features that rely on PowerShell by displaying a more verbose process to help understand PowerShell connectivity issues and errors.
  • Improved RBAC by removing on-prem password from the grid listing credentials as this is not useful. This was only visible to RBAC managers and global admins.
  • Improved granularity of sapio365 RBAC by applying assigned scopes to the ‘directory load’ in features which add users or groups.
  • Improved RegEx in RBAC scopes with validation of RegEx and Wildcard. It previously accepted invalid formats and resulted in freezing the loading of scope objects with that role.
  • Improved advanced filters for loading data by temporarily removing the filter ‘Ends with’ because of Graph API issues.
  • Improved Preferences section by removing the ‘Use Cache’ option (cache is always used now) and ‘Hide top-level rows when switching to flat view’ grid preference (it’s now on by default), and changed terms of other settings for better clarity.
  • Improved Views by adding a scrollbar in the dropdown list to handle a larger number of created Views. Previously, if you had many Views in your list, you could not access beyond a certain number as the list went down offscreen. Now you can create as many Views as you like and scroll through them to switch to the one you want.
  • Fixed various issues with Views, including the handling of filter option ‘Filter out Empty Cells’.
  • Fixed issue where the ‘Delete’ Event/Message/File button was shown as disabled when the selection was flagged for deletion of an attachment or permission (Files) in Events, Messages, and Files modules respectively.
  • Fixed issue where exporting a number value to Excel is not formatted correctly as an integer when thousand separator is not set as “,” in Windows.
  • Fixed Hierarchy filter setting default in Sites module which cause certain filters to behave unexpectedly.
  • Fixed Refresh issue where upon refresh, some loaded information was lost in Files, Messages and Events modules.
  • Fixed RegEx issue where filters did not work correctly on blank (gray) cells, and fixed incorrect display in edit dialog. Also improved it generally by adding more information when errors occur.
  • Fixed issue where ‘Save x ‘ button (Save Selected) or ‘Undo x’ button (Undo Selected) were shown as disabled when selected row belonged to object tagged for edition in the modules Private Channel Members, Group Members and User Memberships, User Licenses.
  • Fixed sapio365 license check process which may have been stuck in a loop under some circumstances.
  • Fixed how group rules are handled in advanced filters because of missing brackets in resulting filter query.
  • Fixed Edit button state in Property Viewer to show as disabled if there is no editable object in the selection.
  • Fixed issue causing crash when comparing hidden columns as Families in Comparator.
  • Fixed User Activity Logs to display the correct ‘Action Status’ value for Comments and RBAC Module operations (previously shown as ‘Unknown’).
  • Fixed User Activity Logs to display information on target user whose license and plans have been modified.
  • Fixed issue where clicking between links in the main window resulted in opening a new Edge window.
  • Fixed crash issue due to interruption of writing to cache of large volume of data.
  • Added ‘Drift Integration’ option in Preferences to disable Drift chat when there are unforeseen changes in Drift services that cause script errors to pop up upon sapio365 launch.
  • Fixed various Comments issues, including: – when ‘Add’ button was not working properly, – when column title was lost when switching tenants.
  • Fixed handling of exploded multivalues where the suffix is now ONLY used to as a display in the grid. All other manipulations (export, filter, etc) are based on the value.
  • Fixed various RBAC issues like the Checkbox column not sorting properly in the Credentials grid, the Tab key not moving the selection in the Scopes Selection dialog, and where editing or adding a role’s ‘Short Description’ was not working. It displayed credentials reference instead.
  • Fixed issue of ‘Case sensitive’ checkbox being inverted when editing an existing RBAC scope.
  • Fixed issue of ‘RBAC Hidden Items’ count was no longer shown in status bar after clicking the Refresh button.
  • Fixed handling of Restore Points during a RBAC-role session where the scope was not working in a Restore Point.
  • Fixed 2 issues with Snapshots and Restore Points. Last queries columns were not saved and switching to hierarchy toggle was not working.
  • Added more information in error message related to missing admin consent for Graph API permissions needed for sapio365.

Users fixes and improvements 

  • Improved user creation dialog based on a selection of users as template by removing pre-filled unique fields like email, email nickname, etc. You no longer have to remove these values before adding new ones.
  • Improved ‘Import Users’ with a new option to use the grid selection’s common property values as template to pre-fill fields not set from the imported file in addition to the fields mapped from the CSV or Excel file. Also, improved duplicate entries handling to reduce errors.
  • Fixed ‘Force update password’ issue in ‘Reset password’ feature where to only change the password required toggling both Force options to False even when unset.
  • Fixed Refresh issue in Users where loaded info disappeared for all users if ‘Leave additional data loaded in grid’ was chosen.
  • Fixed missing ‘Other’ on-prem user attributes columns in the grid. Previously, the addition of these columns was omitted because there was no value returned.
  • Added option to include body content of users’ email messages and calendar events when saving a Snapshot or a Restore Point.
  • Removed option to edit online meeting status and provider info in group calendar events. There’s currently an issue with the Microsoft Graph API.
  • Fixed Restore Point creation in User Licenses module, which was temporary disabled.
  • Fixed Snapshots and Restore Points to handle on-prem user data (showed error under certain circumstances).
  • Fixed cache issue which was causing ‘Group ID – assigned by’ (licenses) to always show as empty in Users module.
  • Fixed loading of on-prem user attributes when selecting a lesser number of attributes than what was already in the grid. Previously, loaded attributes remained in the grid even after being ‘unselected’ for new data loads. This allows you to clean up your cache of on-prem data.
  • Fixed issue for create, import and update users from file features for certain cases where the format of the Excel values was not the same as in the grid after processing.
  • Fixed ‘Reset’ button in on-prem users’ attribute selection dialog where using ‘Reset’ did not update the selection counter.
  • Improved service plan edition to handle the fact that EXCHANGE_S_FOUNDATION plan cannot be disabled.

Groups

  • Improved ‘Create’ function based on a selection of groups as template by removing the pre-fill of unique fields like email.
  • Improved ‘Import Groups’ with a new option to use the grid selection’s common property values as template to pre-fill fields not set from the imported file in addition to the fields mapped from the CSV or Excel file. Also, improved duplicate entries handling to reduce errors.
  • Improved ‘Import Groups’ from file feature with mapping of dynamic group properties. You can now include dynamic groups in the file you want to import.
  • Improved selection membership edition dialog for on-prem groups by adding two columns: Group Category and Group Scope.
  • Improved address book or directory dialog by sorting on Display Name.
  • Added option to include body content of groups’ conversation posts and calendar events when saving a Snapshot or Restore Point.
  • Improved splash screen info for loading private channel members by adding a progress count.
  • Improved group edition dialog by removing the group visibility value “Hidden membership” from the drop down menu. This value can only be set during group creation. It cannot be edited.
  • Removed option to edit the fields ‘online meeting status’ and ‘provider info’ in users’ calendar events. There’s currently an issue with the Microsoft Graph API.
  • Fixed throttling issue when retrieving channel messages and updated API.
  • Fixed issue where the option to ‘Limit the number of events’ was not working for loading Group calendar events. It was loading everything.
  • Fixed missing grid values (Group Display Name, Member Display Name, Group Hierarchy) after adding groups as members in the Group Members module.
  • Fixed Snapshots and Restore Points to handle on-prem group data because these showed an error under certain circumstances.
  • Fixed missing ‘Other’ on-prem group attributes columns in the grid. Previously, even though these fields were part of the selection, they were not added to the grid because there was no value returned.
  • Fixed loading of on-prem group attributes when selecting a lesser number of attributes than what was already in the grid. Previously, loaded attributes remained in the grid even after being ‘unselected’ for new data loads. This allows you to clean up your cache of on-prem data.
  • Fixed issue for create, import and update groups from file features for certain cases where the format of the Excel values was not the same as in the grid after processing.
  • Fixed ‘Reset’ button in on-prem groups’ attribute selection dialog where using ‘Reset’ did not update the selection counter (the number at the top stayed the same even though the number of checks changed in that category).
  • Fixed Refresh issue in Groups where loaded info disappeared for all groups if ‘Leave additional data loaded in grid’ was chosen.

Files

  • Improved grid in Files module with information about recipient emails of users who were sent sharing links by updating permission properties and adjusting computed columns.
  • Fixed issue where OneDrive Info Permissions ‘Owner Only’ values were not saved to a Snapshot or a Restore Point.

Reports

  • Enriched Usage Reports by adding ‘Unit Cost – Effective Assigned Licenses’ to list of additional info.
  • Improved sign-ins and usage reports dialog by adding a note to remind users that they need a Premium license for sign-ins and that usage reports may show anonymized data if set in Microsoft 365.

Jobs

  • NEW job ‘Set selected users SAME AS…’ in the Users module lets you copy licenses, groups, manager and roles from specified users just like a template. An Excel report is generated at the end to summarize changes for review.
  • NEW job ‘Get ALL messages from recipients related to selected message’ in the Messages modules lets you retrieve the messages from the mailboxes of the recipients of the message you select. A recipient report and Restore Point files will be created from the results from where you may review and delete entries.
  • Improved ‘USER ONBOARDING’ job with NEW options. You can now import users from an Excel or CSV file instead of creating them one by one when running this job. Besides assigning groups and licenses and a manager common to the users to selected, you can now also assign the same roles, group ownerships as the template users, and assign a different manager.
  • Improved job ‘OFFBOARDING USERS’ by adding NEW options to set mailbox permissions for someone other than the manager and turn automapping on or off, download OneDrive files as a backup, and you can choose to add a grid comment for the users that were deactivated.
  • Improved job ‘Get All Related to Calendar Events’ and the ‘Hard Delete…’ jobs by revising automation script for a more optimal process.
  • Improved all scheduled jobs with addition of option to run scheduled jobs in the background to eliminate interruptions.
  • Improved core performance of Job engine: internal process of jobs will run faster.

Automation

sapio365  2.1.6

January 19 2022

What’s new in the latest version?

New features

  • Added user MFA information to the Users grid and the ability to update it. Select the view ‘MFA Info’ to add and load the properties.
  • Added ability to edit mailbox settings: convert mailboxes to ‘shared’, set a SMTP forwarding address or an internal forwarding address and hide from address lists.
  • Added complete delegation by sapio365 RBAC credentials, with access to data gathered through PowerShell (Mailbox info , MFA) and full delegation on Hybrid Microsoft 365 environment with on-premises credentials.
  • Added ability in sapio365 RBAC to delegate the management of users, groups and members in the local Active Directory (on-premises), management of Roles and Administrators, access to Registered Applications module, access to reports modules (Usage Reports, Sign-ins reports, Audit logs), and cost-allocation in Licenses and Services module.
  • Added ability to clone sapio365 RBAC roles to facilitate task delegation across multiple tenants.
  • Added ability to assign sapio365 RBAC roles using groups.
  • Added ability to access files in other document libraries and in the Preservation Hold Library. Previously, only files in the default document library were retrieved.
  • Added the ability to define a maximum number of emails or events to load in Messages and Events modules respectively. Once loaded, you can change this number to perform a new volume load.

General fixes and improvements

  • Improved the PowerShell initialization process when checking for required modules and connecting to the various sessions.
  • Improved the “Edit On-Prem Settings” dialog for initial connection errors.
  • Improved experience saving changes on-premises. Previously, if there were only on-premises changes, ‘Save All’ prompted to save in cloud or on-premises. It’s now smarter.
  • Fixed various issues with Snapshots and Restore Points, including keeping modifications in the following modules: Users, Groups, Events, Messages, Group Members, Deleted Users, Deleted Groups, Directory Roles, Group memberships, Message Rules.
  • Fixed issue when a new Cell comment column shows an unexpected name and is not placed next to the source column due to former deleted Cell Comment.
  • Fixed issue where using ‘Totals’ for groupings was not working properly with multi-values.
  • Improved progress and task bar readability by using format with thousands separator for number counters used.
  • Improved data sync times to and from Cosmos DB.
  • Fixed issue in comments where the preview button was disabled when the comment contained a formula with a lookup reference on an empty cell.

Users fixes and improvements 

  • Improved grid in Users by removing duplicate terms in column titles of OneDrive storage data.
  • Fixed issue where creating a user account on-premises with an invalid password resulted in an error but the user was created anyway. A yellow ‘Warning’ band will be displayed above the grid and you can get the details for that row by extending the column width of the on-premises status column.
  • Fixed issues with creating on-premises users with ‘Other’ attributes. Previously, attribute values set in ‘Other’ category like ‘msDS-cloudExtensionAttribute1’ were not saved.
  • Fixed issue where the creation of an on-premises user with the name of one that exists resulted in removal of that new row upon saving the change.
  • Fixed issue where ‘Reset’ did not clear the pre-filled attribute fields generated when creating an on-premises user from a selection.
  • Fixed issue when updating a user was retuning a “yellow” status (where save was not fully completed) instead of a “green” status.
  • Fixed issue where creating or updating users or groups from a file was case sensitive. Now it uses a case insensitive matching key.

Groups

  • Improved On-premises Groups grid by adding new columns for group type and built-in status.
  • Made multiple improvements to On-Prem Group Membership and On-Prem Group Members modules: added new columns and selection dialog for modification.
  • Improved grid in Groups by removing duplicate terms in column titles of library storage data.
  • Fixed grid issue handling recursive nested on-premises groups in the On-Prem Group Membership module. It previously caused sapio365 to crash.
  • Fixed issue of getting an error trying to accessing Teams’ channels in advanced-only sessions (added new delegate permission).
  • Fixed issue of missing email when creating a Microsoft 365 group.

Jobs

  • NEW job ‘USER ON-BOARDING’ in Users module lets you create new users based on the common attributes of users you select, and assign them licenses and group memberships common to the selected users.
  • NEW job ‘USERS OFF-BOARDING’ in Users module lets you disable selected users with options to revoke access, change passwords, set a manager, un-assign licenses, convert to shared mailbox, forward emails to a set address, and remove them from groups all in one go. In hybrid tenants, selection is limited to synced and cloud-only users.
  • NEW ‘Cross tenant’ category lets you run jobs across multiple tenants. Certain jobs were improved with this new option that lets you choose session tenants on which to run the job.
  • NEW job ‘Get Date of Last Email Sent and/or Receive’ to check when was the last time users received or sent emails. This can even be done across different tenants.
  • NEW job: ‘Save current selections of Users or Groups’ lets you to use your current selection in other Jobs by exporting a csv of user or group data. This is available currently only in Users and in Groups.
  • Improved the jobs that hard-delete selected messages and events by streamlining the PowerShell execution within sapio365. You will only need to enter your credentials the first time you run these jobs in each sapio365 session.
  • Improved the job updating the cache of Users, Groups and Sites module data. It now includes options for each additional data load, including on-premises and the newly added MFA info.
  • Fixed issue where a scheduled ‘Cache refresh’ Job tried to send a report even though there was nothing to report.

Automation

  • Added automation for edition of members of on-premises groups.
  • Added new Automation tag to execute a PowerShell script.
  • Added new Automation tag to do a Graph request.
  • Added new Automation tag to execute a script define by a variable.
  • Fixed various other automation issues which resulted in errors.
sapio365  2.1.5

November 29 2021

What’s new in the latest version?

New features

  • New module ‘Registered Applications’.
  • New ability to set a unit cost to any licenses in Licenses & Services module. Values set there are used in all modules and submodules showing assigned licenses. Added new Views in Groups and in Users, and updated others to include the new license unit cost column.
  • New submodule to fully manage on-premises users’ group memberships.
  • New submodule to fully manage on-premises groups’ members.
  • New security option to enforce session logout upon exiting sapio365. This can also be enforced to selected users through Access & Restrictions settings (via CosmosDB).
  • New ability to select or filter grid entries directly from the Clipboard.

General fixes and improvements

  • Improved loading of Snapshots and Restore Points by offering the related sessions (if present) upon login.
  • Added more specific info (create, update, delete) about Mailbox Permissions actions in the User Activity Logs.
  • Improved RBAC credential usage by setting password policy of the newly created service account to “DisablePasswordExpiration” upon creation of credential to avoid password reset prompts.
  • Improved RBAC credentials creation by making sure all fields are properly set when generating a new pair of credentials to avoid a restart of the process.
  • Improved tooltip for the ‘Go to Next Selected Row’ feature in the Global tab. The directive is now clearer to move up or down selected entries.
  • Improved text to clarify that temporary comments are always included in the save dialog of Snapshots and Restore Points.
  • Fixed Cosmos DB connection issues including handling errors for unauthorized subscription access and displaying the ID of subscriptions to help users with large volumes to identify the correct one to use.
  • Improved comments (annotations) creation and edition dialogs with explanatory tooltips for the various elements.
  • Fixed issue of the ‘Refresh Outdated Cache’ dialog not showing the numbers of entries affected by incomplete data.
  • Fixed issue where the Save Changes confirmation dialog was only asked for the first Save Selected action if several changes were present in the grid.
  • Fixed Multi-value Explosion issue for nested multiple values which were behaving oddly after the first explosion (ex. file permissions).
  • Fixed case where new comment column gets an unexpected name and is not placed next to source.
  • Fixed issue when adding comments to a large number of rows was taking a lot of time. It’s now much faster and there is a progress bar that lets you know where you are at.
  • Fixed issue of being able to change preferences to launch a Standard session as a global admin after having checked ‘don’t ask again’ for automatically switching to an Advanced session.
  • Added the ability from Users and Groups modules to Force Sync on-prem/cloud for remote connections to AAD Connect servers.
  • Improved ‘Saved successfully’ yellow bar situation where saved changes require a refresh to be shown in the grid. Now the yellow bar disappears upon refresh and you have the option to remove errors which were prohibiting new changes to that entry.
  • Updated the list of labels for licenses and Service Plans.

Users

  • Added ability to set or remove a Manager without the need to previously load the additional values in Users.
  • Improved column titles related to licenses in Users to indicate assigned effective licenses, licenses assigned by groups and related data.
  • Added new filters on SMTP Proxy Addresses and Aliases in Load Users advanced filters.
  • Fixed filter options for Filtered Users by removing those that do not apply and fixing the syntax of others.
  • Improved ‘Update from File’ and ‘Import from File’ features in Users with an option to skip top rows in the file.
  • Improved grid in Users and Groups by removing duplicate terms in column titles of storage data.
  • Added 4 new views: ‘Email and smtp addresses’, ‘Mailbox litigation hold and archive info’, ‘Mailbox time zone, language and meeting hours info’ and ‘Out-of-office and auto-reply info’.

Groups

  • Added ability to delete a group conversation thread.
  • Added option to create a security Microsoft 365 group, useful for group-based licensing.
  • Added new filter on SMTP Proxy Addresses in Load Groups advanced filters.
  • Improved ‘Update from File’ and ‘Import from File’ features in Groups with an option to skip top rows in the file.
  • Improved dialog for mass editing members of email-enabled groups that require PowerShell. It’s now clearer that you can skip the dialog which used to pop up for each members in the batch.
  • Fixed issue while editing members of some distribution lists or email-enabled groups where a 400 Bad Request error was returned, by proposing a PowerShell alternative.
  • Fixed issue where Save Selected removes unsaved ‘Created’ rows in Private Channel Members module.
  • Fixed filter options for Filtered Groups by removing those that do not apply and fixing the syntax of others.
  • Fixed columns titles in Groups module by switching and renaming them. They were previously shown as ‘Username – Created On Behalf Of’ and ‘User Principal Name – Created On Behalf Of’.
  • Improved grid in Users and Groups by removing duplicate terms in column titles of storage data.
  • Added 4 new views: ‘Dynamic membership info’, ‘Group licensing info’, ‘Guest addition and expiration policy info’ and ‘SMTP address and hidden from GAL info’.

Licenses improvement

  • Added ability to go to Admin Center directly from sapio365 Licenses & services module with newly added ‘Purchase Licenses’ button in the ribbon.

Messages fixes and improvements

  • Added ability to retrieve related event details from selected emails in Messages module with newly added ‘Event Details’ button in the ribbon.
  • Fixed cause of crash from downloading certain messages as EML because the path name was too long.
  • Fixed ‘Use Mail Folder Hierarchy’ option to include the full path, not just the parent folder when downloading messages as EML.
  • Fixed issue of a dialog appearing when editing an already modified entry in Users Message and Events modules.

Files fix

  • Fixed issue where loading permissions of a OneNote in the OneDrive File module showed permissions for the OneNote components but not for the top OneNote entry.

Sites fix

  • Fixed issue of displaying duplicate entries for SharePoint sites in the grid due to Microsoft Graph API bug. These “ghost” sites were only identified via their ID and retrieving files or other information for them resulted in 404 errors. They are now filtered out until the Microsoft Graph API gets fixed.

Jobs

  • Added new job ‘Find registered applications with Secret Keys or Certificates about to expire’ to All Jobs.
  • Added new job ‘Find multi-tenant registered applications with unverified publishers’ to All Jobs.
  • Added new job ‘Multi-tenants Consumption License Analysis’ to All Jobs
  • Improved job ‘Update cache of Users and Groups’ to work more efficiently with the latest ‘Refresh’ options.
  • Improved Hard-delete jobs used in RBAC sessions by removing “RBAC role” text auto-appended to username in PowerShell options.

Automation

  • Added common jobs (job components) for sending report emails with Snapshots and Restore Points.
  • Added automation for Import/Update users/groups from file.
sapio365  2.1.4

September 21 2021

What’s new in the latest version?

General fixes and improvements

  • Added the ability to create ‘Column Comments’ which are free comments that are not based on any column and whose value is applied on every row dynamically. These are useful with Java script formulas. The original column-linked comments are now called ‘Cell Comments’.
  • Improved cache vs refresh message when loading users, groups and sites.
  • Improved ‘Export to File’ by adding option to ‘Export as text (applies only to values with unsupported format)’ when exporting to Excel or CSV for unsupported formats like bytes/mb/g.
  • Improved Restore Points by enabling to save marked changes – ‘Edit’ status is now included.
  • Improved sapio365 RBAC role information by adding tenant information. Before you had to rely on the role name and description that you defined.
  • Improved ‘Select from file’ with a confirmation message after the entries are selected in the grid and fixed an issue where blank rows in the file were causing errors.
  • Improved User Activity Logs by recording access and changes of on-prem data (users and groups).
  • Improved user interface elements like clearer content and sizing of message boxes, consistent property column references and removal of obsolete modules like Mail Folders in My Data.
  • Fixed Admin Audit Logs pre-filters which returned an error because of request syntax.
  • Fixed cause of error in computing integer values in Comments when the value format uses a thousand separator.
  • Fixed comment dialog shortcut texts to reflect system language setting. Example, ‘Ctrl+Enter’ in German would be ‘Strg+Enter’.
  • Fixed crash issues related to comments, Snapshots and Restore Points in certain scenarios.
  • Fixed display discrepancies for empty cells and for cut-off dates of the saved Snapshots and Restore Points.
  • Fixed false ‘Partial on-prem cache’ warning.
  • Fixed issue in sapio365 RBAC where an error “validating elevated privileges” during set up was occurring because the automatic delay between each step in the process was not long enough.
  • Fixed issue of automatically deleted automation trace files ending up in the trash (and taking up storage space). Now they are hard-deleted.
  • Fixed issue of disappearing the case sensitive option in Regex filters under certain conditions.
  • Fixed issue of lost ‘load info’ date in Snapshots and Restore Points.
  • Fixed issue of manually hidden rows not being saved in a Restore Point and Snapshots.
  • Fixed issue of presence of extraneous log entries in the User Activity Log where unsaved modifications and already saved changes were being recorded.
  • Fixed issue of sapio365 vanishing during the Comments deletion process under certain circumstances.
  • Fixed issue of the Job Catalog freezing or flashing, and the onboarding popping-up when running a job from the main window.
  • Fixed issue of multivalue explosion being lost after saving changes in Users and in Groups.
  • Fixed issue resulting in script error message for fresh installs of sapio365.
  • Fixed issue when disabling ‘Show Empty’ in the Hierarchy tab resulted in the hiding of the parent of a single child row.
  • Fixed issue where “Freeze up to” was unexpectedly affected by System Columns when applying a view.
  • Fixed Property Viewer refresh issue which caused sapio365 becoming non-responsive after hiding all columns in certain large volume situations.
  • Fixed regression which prevented the launching of a new sapio365 install under specific conditions.
  • Fixed sapio365 in-product tutorial which was showing “Undefined” jobs at first launch.
  • Fixed the error resulting from ‘Update from file’ because the “@” of the email field values was omitted when writing to the grid.
  • Fixed timeout issue during sapio365 connection to licensing system and fixed update errors due to strict proxy settings.
  • Fixed Views issue where modification of a View was not working with Restore Points or Snapshots.
  • Fixed FlexyView behavior where the unloading hidden rows resulted in the unexpected disappearance of all grid data.

Users

  • Added ability to edit calendar events and also added more properties to the grid in the Events module.
  • Added ability to edit message properties like ‘is draft’, ‘subject’, ‘classification’, etc.
  • Added mailbox Litigation Hold properties to the Users module. You will see which users are on litigation hold, for how long and by whom. This information can be loaded with ‘Load Mailbox Info’.
  • Added ‘Purged’ folder to messages module to access hard-deleted items that ended up there because Litigation Hold or single item recovery is enabled. It’s included in the “Deletions” option when retrieving messages.
  • Added an option to include Event information along with the corresponding column properties to the Messages grid when retrieving user messages.
  • Improved ‘Add to Groups’, ‘Copy’, ‘Move to’ dialogs in the Membership module with ability to add without closing the dialog. Also ‘Contains’ filter is now on Display Name instead of Principal name when moving or copying members.
  • Added option to add groups or members from a file in the Group Membership module.
  • Improved ‘Update from file’ to only apply to visible users for better control. Filtered and hidden rows will not be affected.
  • Improved Messages module by separating owner display names and folder names into their own columns.
  • Improved loading of Messages and Events by adding a time field option in advanced filters for more precise results. For example, you can now retrieve messages with creation date/times up to the minute.
  • Improved loading of Messages and Events by changing some pre-filter options that were not working previously.
  • Improved license management by adding option to select all licenses when assigning or removing Microsoft licenses in the edition dialog.
  • Cleared up prompts that lead to existing pre-filtered Users modules when launching Users module. You will only be asked if the same type of User module already exists.
  • Fixed discrepancy of the value of the ‘Force Change Password With MFA’ property displayed in the grid versus the one in the edition and creation dialogs in Users module.

Groups

  • Added ability to edit calendar events and also added more properties to the grid in the Events module.
  • Added option to add group members or owners or private channel members from a file in the Members, Owners and Private Channel Members modules respectively.
  • Added ‘Group – Delete Events’ permission in sapio365 RBAC.
  • Removed request for information on group event attachments (and property columns) because they are no longer supported by Microsoft Graph APIs (errors).
  • Improved member addition dialogs with ability to add without closing the dialog in Group Members module. Also “Contains” filter is now on Display Name instead of Principal name.
  • Improved ‘Update from file’ to only apply to visible groups for better control. Filtered and hidden rows will not be affected.
  • Improved management of owners and members of email-enabled security groups & distribution lists with a workaround of the errors returned due to Graph API limitations.
  • Improved loading of Events by adding a time field option in advanced filters for more precise results. For example, you can now retrieve events with creation date/times up to the minute.
  • Improved loading of Events by changing some pre-filter options that were not working previously.
  • Fixed unexpected behavior in Group Members module where removing “Show Empty” resulted in loss of hierarchy for some entries in certain scenarios.

Automation Jobs Library (AJL)

  • Added new job in Users’ Messages: Hard delete selected emails.
  • Added new job in Users’ Events: Hard delete selected events.
  • Added new job in Groups’ Events: Hard delete selected events.
  • Added new job in Users’ Events: Get ALL entries related to the selected calendar event.
  • Improved Jobs’ scheduling with ‘Run once’ option.

Automation

  • Added option to open a Restore Point or Snapshot after creation.
  • Added ‘Explode’ parameter to SetVarListsFromGridColumns to enable multi-value field explosions (with no actual explosion in the grid) to build a list of unique values of all values in the column.
  • Added warning when automation script tries to execute a disabled grid action.
  • Fixed process for <SelectFromList> which was very slow for large volumes of rows.
sapio365  2.1.3

July 13 2021

What’s new in the latest version?

General fixes and improvements

  • Refactored the main sapio365 page for easier access to modules and to jobs. Click on the tabs at the top to navigate between the module access, the full list of automation jobs and your own jobs.
  • Added a sapio365 user onboarding process with helpful information for when launching the product for the first time.
  • Added a live chat interface on the home page. You can now talk to a product expert directly from sapio365.
  • Cleared up text in dialogs for saving Snapshots and Restore Points. The security options are now easier to understand.
  • Improved messaging when cached data is displayed in Users, Groups and Sites modules. You will see a message bar “currently showing data from cache” message at the top of the grid with a button to show the ‘Last queried date’ column in the grid.
  • Improved Views in all modules by giving users the option to load related column property values. For example, if you switch to Sharing Info, you will be asked if you want to load the information in the related columns (file permissions in this example).
  • Improved Job Center layout in all Modules by adding more text padding and by moving descriptive elements for better readability.
  • Fixed issue of not being able to cancel a loading of data when Grid Manager is expanded (hidden behind it).
  • Fixed crash issue resulting from scenario when on the machine, Windows does not recognize internet connection even though it is present.
  • Fixed a couple of issues for specific conditions that led to crashes: closing a window after viewing mailbox permissions, and when loading on-prem data more than once at the same (simultaneous requests).
  • Fixed ‘View Multivalues’ grid function which was not always showing the cell values.
  • Fixed ‘Export to File’ to export to CSV as UTF-8 instead of UTF-16.

Users

  • Added ability to create and update on-prem user accounts from an Excel or CSV file.
  • Added ability to edit Mailbox Permissions. You can now add or remove mailbox delegates or change their permissions.
  • Added ability to delete on-premises users.
  • Added ability to edit more on-prem user attributes: all onPremmsDS-cloudExtensionAttribute (1-20), otherMailbox, mailNickname.
  • Added new user property ‘HiddenFromAddressListsEnabled’ in the grid replacing the ‘Shown in Addressbook’ property which was removed in the previous version.
  • Improved loading times of on-premises data by adding a cache of on-prem data in Users.
  • Improved how on-premises attributes are selected for loading by combining attribute name aliases in their title. The Quick Search has been improved as well (returns all checkboxes). You can also refresh the list of custom attributes by clicking on ‘Refresh attribute list’ in the ‘Other’ category.
  • Fixed term inconsistencies for on-premises attributes in the category names used in the Property Viewer, the Column Map and the Grid Manager. Also fixed handling of unknown type attributes in the grid
  • Improved ‘Load on-premises Users’ dialog by making it easier to find ‘ProxyAddresses’. It is now in the ‘Advanced’ category instead of ‘Technical’.
  • Improved terms’ consistency in grid by changing “Load Info” to “Additional Info” where applicable and added appropriate icons in grid.
  • Fixed issue of extra rows generated in the grid when editing user attributes on-premises.
  • Fixed ‘Save All’ for edition of on-prem attributes.
  • Fixed the ‘Search’ function (general and within a category) in the on-premises attribute selection dialog in the Users module. It is now easier to find and select the attributes you want to load.

Groups

  • Added ability to delete on-premises groups.
  • Added ability to create and update on-prem group accounts from an Excel or CSV file.
  • Added ability to update Microsoft 365 groups from a CSV or Excel file.
  • Improved how on-premises attributes are selected for loading by combining attribute name aliases in their title. The Quick Search has been improved as well (returns all checkboxes). You can also refresh the list of custom attributes by clicking on ‘Refresh attribute list’ in the ‘Other’ category.
  • Improved loading times of on-premises data by adding a cache of on-prem data in Groups.
  • Improved terms’ consistency in grid by changing “Load Info” to “Additional Info” where applicable and added appropriate icons in grid.
  • Fixed term inconsistencies for on-premises attributes in the category names used in the Property Viewer, the Column Map and the Grid Manager. Also fixed handling of unknown type attributes in the grid
  • Fixed ‘Save All’ for edition of on-prem attributes, which was previously glitchy.
  • Fixed the ‘Search’ function (general and within a category) in the on-premises attribute selection dialog in the Groups module. It’s now easier to find and select the attributes you want to load.

SharePoint Online sites

  • Added ability to get site information directly from the SharePoint site usage report for the sites you select.
  • Improved loading times of SharePoint sites buy adding a cache of site data.

Licenses

  • Fixed issue of friendly names of service plans not being shown in the license edition dialog.

Mail Messages

  • Fixed issue of saving all changes when “Save Selected” is used in Messages module.
  • Fixed issue of not being able to see the Preview Body of a loaded Restore Point of a Message Module when not logged in.

Automation

  • Automated “Show Empty” button in Category from Hierarchy tab.
  • Automated ability to set manager information.
  • Automated ability to add or remove members from private channels.
sapio365  2.1.2

May 17 2021

What’s new in the latest version?

General fixes and improvements

  • Improved management of multi-value attributes like file permissions and audit log event details. Now only one family of multi-value properties can be exploded at a time.
  • Fixed refresh issue that occurred after any modification of permissions or attachments in the MY Data module.
  • Fixed issue that caused crash when using the Column Map.
  • Fixed blank dialog issue in temporary comments, and added missing column reference insert button in the editing dialog.
  • Fixed auto-scrolling issue in grid, caused when clicking to expand or collapse a category would shift focus to the selection in the grid.
  • Improved the license allocation section in sapio365 RBAC during role creation/editing. Microsoft 365 licenses are now displayed with user-friendly names.
  • Updated the term ‘Office 365’ to ‘Microsoft 365’ in grid values and in various dialogs.

Users

  • Improved loading time of users’ on-premises attributes with selection options. Choose what you want to load.
  • Optimized license management with shorter loading times for large volumes.
  • Fixed issue related to cancelling the loading of ‘Mailbox Info’, ‘Mailbox Permissions’, and ‘On-prem data’. Now partially loaded data is retained.
  • Removed the ‘is resource’ property in Users module grid, and in the editing dialog because the Microsoft API that is used is not functional. A workaround will be implemented in the next release.
  • Fixed issue with loading ‘Mailbox Permissions’ and ‘Mailbox info’ caused by to recent change by Microsoft affecting URL call-back used in requests.

Groups

  • Improved loading time of groups’ on-premises attributes with selection options. Choose what you want to load.
  • Added the ability to convert M365 groups to Dynamic membership in group editor.
  • Fixed an issue related to cancelling the loading of ‘On-prem data’. Now partially loaded data is retained.

Documents

  • Added file-sharing information for permission links. You can now see who was invited with anonymous links, internal or user-specific links.
  • Added a new file permission property ‘Expiry date of link’ that describes links used for sharing. These are related to all Files modules for users, groups, sites and channels.

Automation Jobs Library (AJL)

  • NEW Job: Archive Teams based on criteria matching email or names.
  • NEW Job: Restore archived Teams based on criteria matching email or name.
  • Improved the main AJL jobs view by making ‘Full catalog’ the default view.
  • Improved job titles in each module to indicate if any job will apply only to selected, or to entire tenant. Added missing icons and descriptions.
sapio365  2.1.1

March 5 2021

What’s new in the latest version?

General 

  • Creation of on-premises users and groups individually or imported from a file.

General fixes and improvements

  • Improved token management with a display of token counts and balance.
  • Fixed token count system (consumption is now more accurately accounted for).
  • Improved management of hybrid session with setting options on the homepage: New option to load on-premises data; ‘On-premises settings’ is now always enabled since its access no longer relies on a match between on-premise and cloud domains.
  • Fixed a mismatch of labels between the edit dialog ‘Edit on-premises’ and the button that launches it.
  • Improved grid selection responsiveness in grids with large volumes of entries (there was a lag previously).
  • Fixed issue of transferred columns being hidden and positioned at the end because of the introduction of views.
  • Improved terms by renaming ‘Account Expires’ column to ‘Account Expiration Date’, and its column ID.
  • Improved readability of the Views selection box by making it bigger.
  • Fixed column sorting logic to sort cells by ‘with value’, ‘no value’, and then empty cells. Empty cells were previously sorted before ‘no value’ cells.
  • Fixed issue related to crash that occurred for specific scenarios using ‘Change Options’ for pre-filtered results.
  • Fixed issue of an extra row displayed after refreshing a grid with pre-filtered results.
  • Fixed issue to properly display ‘Unsupported property filter clause operator error’ message when appropriate. Previously, the message would not appear while the grid showed ‘No data’.
  • Fixed issue with viewer displaying ‘Partial Load Error’ when switching between certain views.
  • Fixed Advance Filters in Sign-ins with the correct format for the filter criteria.
  • Improved visibility of ‘Select from file’ feature with new button found under the Global tab. Previously, this feature was only available as an option in ‘Filter from file’ found under the ‘Filter/Sort’ tab.
  • Cleaned up irrelevant PowerShell errors in grid.

Users and Groups

  • Improved UI for cache/refresh/Loads in Users and Groups.
  • Improved ‘Refresh’ by retaining additionally loaded information in Users and Groups.
  • Improved the ‘Import’ dialog in Users and Groups by retaining the last settings and mappings used (sticky). Also, importing users or groups from a file with double headers (result of sapio365 export) is now supported.
  • Improved the ‘Add members’ function in Group Members for large volumes by handling throttling errors.
  • Fixed pre-filter issue in Groups and Users, where empty results of a criteria match were ignored, and the unfiltered list of entries was returned.
  • Fixed issue of ‘adding members and owners’ features being disabled when adding to new empty groups.
  • Improved column auto-mapping in ‘Import Users’ and ‘Import Groups’ by making it more permissive.
  • Cleaned up pre-filtered grids in Users and Groups by removing the irrelevant ‘Cached data is out of date’ dialog.

sapio365  2.1.0.1

January 15 2021

Special Hot Fix
  • Fixed sapio365 launch issue for new computers (‘Application starting’ loop).

sapio365  2.1

December 18 2020

What’s new in the latest version?

Learn more about version 2.1 >

General 

  • Added on-prem attributes and edition in Users for hybrid environments.
  • Added on-prem attributes and edition in Groups for hybrid environments.
  • Added Views feature, with system views in Users, Groups, Files and Messages.

Improvements

  • Fixed regression issue of “Convert to Team” feature resulting in no changes in the grid, and changes saved. 
  • Fixed crash resulting from scenario of elevating privileges and managing privileges. 
  • Fixed issue of empty value cells showing an icon after a column with that icon has been set as “Deactivated”. 

sapio365  2.0

November 17 2020

What’s new in the latest version?

Learn more about version 2.0 >

General 

  • Redesigned sapio365 home/main interface; the color palette has changed and the overall layout is now cleaner. 
  • Added interface and dashboard for the Automation Jobs Library (AJL). Jobs can be managed, executed or scheduled. 
  • Added modular sapio365 licensing so that customers can build their own Microsoft 365 management platform: Pro license includes all features, including access to AJL. AJL license allows AJL access only. Add-on includes Snapshot/Restore Point licenses, AJL job editor, Collaboration license and On Premise license (arriving Dec 15, 2020).
  • Added Snapshots and Restore Points features (create and load) to share and work with sapio365 views. Snapshots are read-only stills of the FlexyView Grid while Restore Points permit modifications so you can continue where you left off.
  • Added options to remove filtered and hidden rows in the Sort/Filter tab to speed up FlexyView Grid processes.
  • Added “Deactivated” column property setting to omit deactivated columns during requests, thus speeding up the loading process.
  • Added Data Viewer in the FlexyView Grid which gives users a reader-friendly view of selected data. The Data Viewer is accessible at far-right of the FlexyView Grid.
  • Added pre-filter option for loading Users and Groups. Users can choose from several properties to load entries which meet the selected criteria, speeding up loading times.

Global – Improvements and fixes

  • Improved data caching with delta operation. Fetching cached data and updating of the grid is faster (for example, after saving bulk changes in large workloads).  
  • Improved appearance of license information with user-friendly names of Microsoft licenses and service plans. These are displayed in the FlexyView Grid and in editing dialogs.

Users

  • New – Added editing features in Mailbox Permissions view to manage mailbox delegates. This is accessible via a selection in Users.
  • New – Added ‘Import’ and ‘Update’ from file features in Users.

Groups

  • New – Added ‘Import Groups’ from file feature in Groups

Messages

  • Improved mail messages view by integrating Mail Folders data. Users now have a unified view of Mail Folders with Messages. Mail Folders view has be discontinued.  

AJL Jobs

  • 145 jobs currently available to execute and to schedule.

sapio365  1.7.7

October 20 2020

What’s new in the latest version?

General fixes and improvements

  • Fixed Windows Scheduler issue; some scheduled jobs did not add the sapio365.exe location path in Windows Task Scheduler.
  • Fixed issue of “Show Empty” hierarchy toggle set to Off when services plans are set not to be displayed in the User Licenses module; switching off “Show Empty” resulted in hiding all entries in the grid.
  • Improved the organization of property columns in User and in Groups modules.
  • Fixed issue of loading inline/embedded images in message preview in the Messages module.
  • Fixed issue of using PowerShell features with the wrong session when ‘Single Sign-on’ is set on the computer. You are now asked to sign-in regardless of this setting.
  • Improved the  Proxy Settings dialog.
  • Fixed sizing issue in the ‘About’ panel.
  • Fixed error display in Audit Logs and Sign-ins modules; grid results showed “no data” previously and now show error “HTTP 403: Authentication_RequestFromUnsupportedUserRole: User is not in the allowed roles “.
  • Fixed issue of missing error status bar (red) at the top of the grid in Users Licenses module when error occurs during license edition.
  • Added Microsoft .NET Framework 4.8 Runtime support for PowerShell on Windows 7.

Global Jobs

  • NEW – ‘Mail attachments by name or type for selected users’.
  • NEW – ‘Find last date groups were emailed’.
  • NEW – ‘Query files by name or type for selected groups’.
  • NEW – ‘Export content of all selected groups’.
  • NEW – ‘Get memberships of a selected group’.
  • NEW – ‘Query files by name or type for selected sites’.
  • NEW – ‘Users for selected licenses’.

sapio365  1.7.6

October 7 2020

What’s new in the latest version?

General

  • NEW – Added a Partner access feature  to access customer environments using partner credentials.
  • NEW – Make any grid selection or filter entries using values chosen directly from a CSV or Excel file. You can select the ‘AND’ mode to combine property values, or use the default ‘OR’ mode.
  • NEW – Added ‘View multi-value’ function in the right-click menu to show multi-value entries for the selected column in a separate pop-up window.
  • Improved loading times of calendar events, messages and mail folders with pre-filter options.
  • Fixed – Size issue for HTML dialog boxes for Hi-Resolution Display (HiDPI).
  • Fixed – grid behavior upon new annotations; when adding a first annotation/comment the grid would empty and then rebuild itself.
  • Improved launch process of sapio365.
  • Fixed issue for ‘License Configuration Settings’; the proper dialog is now shown when required to update user count limits.

Job Center

  • NEW – Updating Jobs and existing presets can now be done using drag & drop . Drag the Job file (.xml files) directly onto the automation job center panel.
  • Fixed – Greatly increased ability to send large email attachments (reports) for scheduled jobs.
  • Improved automation job ‘Reset’ option by adding a dialog with choices on how to reset the grid view.
  • Improved – Job Center Configuration panel now displays the ‘Remove from grid’ icon by default.

Users

  • NEW – Added a column titled ‘Member – Group licensing’ in the Users module to indicate if a user belongs to a group used for assigning licenses.
  • NEW – Added mailbox settings columns in the Users module: Mailbox type, Keep copy of forwarded message (SMTP), SMTP forwarding address, Forwarding addresses, ‘Send on behalf of’ delegates, ‘Send as’ delegates.
  • NEW – Added a submodule “Mailbox Permissions” to show mailbox delegates for selected accounts in the Users module. It’s accessible from the User Management area in the ribbon.
  • Improved – launch of OneDrive files, Messages, Mail folders, Events, Contacts, Mail rules from Users module by disabling requests and buttons in the ribbon for guest type user selections.

Groups & Teams

  • Improved – icons identifying archived and non-archived Teams in the Groups module.
  • Fixed issue of the Team icon disappearing after saving when converting a group to a Team.

sapio365  1.7.5

June 4 2020

What’s new in the latest version?

NEW – General

  • Fixed license count issue.
  • Fixed display of jobs in Job Center Configuration when launching sapio365 while signed out of a session.
  • Improved ‘splash’ screen when loading sapio365 (always on top).
  • Fixed RBAC role session selection/sign-in issue (concurrent access).
  • Fixed tenant/user limits of sapio365 license management (signature data).
  • Fixed loading of cache in Users and Groups modules.
  • Improved trace system.

NEW – Jobs

  • Improved job ‘Clean up Teams with guest members’ with informative splash screen allowing interruption of the automation process.

Users

  • Fixed grid status display issue when applying non-changes in the Users module/ Reset Password dialog box.

Groups

  • Fixed edition dialogs in Groups by disabling editing of properties that are not available in the grid for the selected groups.
  • Fixed error displayed when launching Group Members module from selected groups that were previously loaded with ‘Load Info’.

Files

  • Improved file and folder importing speed.
  • Improved speed of grid entry creation during file and folder importing in Files modules (reduce sapio365 freezing occurrence).
  • Improved loading of large volumes of drive items in Files modules (reduces occurrences of sapio365 freezing).
  • Fixed automatic row expansion in Files modules when creating new entries during file upload.

Messages

    • Fixed deletion of messages in My Messages module.

Events

  • New – Added ability to delete calendar entries in Events modules.

Usage Reports

  • Improved Usage Reports’ dialog with a note on requiring Users/Groups cache to include additional properties in the report.

sapio365  1.7.4

May 26 2020

What’s new in the latest version?

NEW – General

  • New – Opened free access (no license needed) to My Data section.
  • New – Added Licenses and Group Memberships in My Data section.
  • New – Added notification in Standard session to inform Global/Company Admin user of qualification to use an Advanced session.
  • New – Added License History in the backstage to manage multiple sapio365 licenses.
  • Improved sapio365 launching experience by offering the option to continue using the existing session or starting a new one when an instance is already running.
  • Improved loading options by changing to friendlier terms in Sign-ins, Audit logs, Messages, Mail folders, and Events modules.

NEW – Jobs

  • New – added ‘Disable Giphy in Teams’.
  • New – added ‘Clean up Teams with guest members’.
  • New – added ‘List recently created Teams by department’
  • Improved ‘List users with & without recent sign-in activity’.
  • Improved ‘Licenses of sign-in blocked users’.

Users

  • New – Added ‘Company Name’ field in edition dialog in Users.
  • New – Added new column properties, including group licensing information, in Users module.
  • Improved ‘Import Users’ dialog in Users by adding a Reset button.

Groups & Teams

  • Improved ‘Import Groups’ dialog in Groups by adding a Reset button.
  • New – Added new group licensing column properties in Groups module.
  • Improved flat data analysis in Team Channels module by adding a separate column ‘Group Display Name’.
  • New – Added new group licensing column properties in Group membership module.
  • Fixed issues related to error display when adding organization contacts, guests as members in Office 365 groups in Group Members module.

Reports

  • Updated ‘Additional Info’ options in Usage Reports with more user & group properties.

User Licences

    • New – Added new group licensing column properties in User Licenses module.
    • Improved organization of column properties related to licenses by changing their category in User Licenses module.


User and Group Recycle Bins

  • New – Added the ability to create Comments in User and Group Recycle Bin modules.

sapio365  1.7.3

Apr 27 2020

Correction

Fixed – Unable to do a first time registration
Fixed – When creating a Job preset, options may not be shown correctly


sapio365  1.7.2

Apr 21 2020

What’s new in the latest version?

NEW – General

  • New – Added “Last activity date” and “Last activity service” summary columns in the Office365 Active Users usage report grid.
  • New – Added new button ‘Files’ in channels to access private channel files information.
  • New – Added new column to show effective membership type in Private Channel Members.
  • New – Added an ‘Is Yammer’ column in the Groups Module to identify Yammer groups connected to Office 365 groups (requires ‘Load Info’ to enable).
  • New – Added management buttons in user and group Usage Reports to access user and group details when applicable.
  • Improved – Simplified the Job Center Configuration panel view, and added a toggle button to change to advanced view.
  • Improved – Added a featured jobs space in the sapio365 home screen.

NEW – Jobs

  • New – Find users unable to use Teams
  • New – List users with sign-in errors
  • New – Find users’ last activity by location

Users

  • Fixed – ‘Sync Enabled – On Premises’ column value format now displays the proper date/time in the Users module.

Groups & Teams

  • New – Added columns and edit options for “Hide from Outlook clients” & “Hide from address lists” in the Groups module (requires ‘Load Info’ to enable).

sapio365  1.7.1

Mar 25 2020

What’s new in the latest version?
  • New – Added ‘Import Users’ button in the Users module for creating users in bulk.
  • New – Added ‘Import Groups’ button in the Groups module for creating Office 365 groups and security groups in bulk.
  • Improved – Added more properties in the Users edit dialog: ‘On-premises Immutable ID’ and ‘On-premises Attributes’.
  • Improved – Updated the edit dialog with distinct icons and clearer tooltips for properties that require loading before editing.
  • User License Module: enhanced for more intuitive understanding, with ‘smart’ filter that adapts depending on the level of the info shown.

sapio365  1.7.0

Feb 24 2020

What’s new in the latest version?

NEW – General
Learn more about version 1.7 >

  • Major change of session types: the old Basic session is now called a Standard session, the old Admin session is now called an Advanced session. Creation of an Ultra Admin session is no longer available, but the extended access it provides is available with the option to ‘elevate’ the privileges of an Advanced session (can use existing Ultra Admin apps).
  • Added new options (Flags) in sapio365 RBAC configuration of roles : ‘Log role usage in User Activity Logs, ‘Log access of modules with this role in User Activity Logs’, and ‘Enforce user-assigned roles on Standard session sign-ins’.
  • Added option to toggle the default display of the dialog for the ‘Grid Configure Transferred’ option.
  • Added options for ‘Show/Hide columns’ and ‘Show column with ID’ in right-click menu to execute without closing the dialog in the Grid Column Map.

NEW – Jobs

  • Main – Report users by disabled service plan
  • Main: View private channel sites

Global – Improvements and fixes

  • Fixed – Issue with scope-limiting properties ‘Sign-in=status’ and Assigned licenses’ in sapio365 RBAC
  • Updated – Added new RBAC permissions & scope-limiting properties.
  • Fixed – License allocation info now corresponds to the tenant of the credentials used in sapio365 RBAC.
  • Improved – Loading and updating data is faster and more options have been added to manage the connection to Azure Cosmos DB.
  • Improved – Regex queries (search, filters, etc.) now have a ‘NOT’ function.
  • Improved – Tooltip display time is longer during mouse hover.
  • Improved – Data loading errors are now shown in the grid header instead of a pop-up message box.
  • Fixed – Crash on exiting sapio365 in large tenant environments (100k users).
  • Improved – Pivot tables now offer formatting of all axes, a hierarchy view, JavaScript function to transform values, and the capability to navigate and drill down charts.
  • Improved – sapio365 performance for running multiple instances at the same time.
  • Improved – Comment management features now include editing, deletion of entries, refreshing the grid display, and hiding out-of-scope comments.
  • Improved – Session options are now easier to understand in the scheduled Job Preset dialog.

Users

  • New – Added a ‘Download as EML’ button in ribbon of the Messages module to download a message in EML format.
  • New – Added a ‘Delete’ button in the ribbon of the Mail Rules module.
  • New – Added a ‘Revoke Access’ button in the Users module to revoke access tokens for Office 365 applications.
  • New – Dialog for resetting passwords in Users module allowing the Password Reset or Force change. password on next sign-in (with one-time MFA option).
  • Fixed – Usage Location value representation for certain locations were incorrect.
  • Fixed – Issues with deleting on attachments in an exploded list in the Message module.
  • Improved – Canceling a ‘Refresh All’ now offers an option to update the grid with partial results in Users module.
  • Improved – Edition dialog in Users now shows if information must be loaded before it can be edited thanks to an icon and text upon hover.
  • Improved – The creation feature in Users module can now use selected users’ info as template to prefill the creation dialog.

Groups & Teams

  • New – Added two buttons in the ribbon in the Team Channels module: Show Sites, Show private channel members & owners.
  • New – Added Private Channel Members module with members/owners management features.New – Added ‘Load Info’, ‘Show Members’ and ‘Sites’ buttons in Teams’ Channels module to manage storage info, access to Files, and SharePoint sites.
  • New – Added button ‘Request access (private channel chats)’ to help obtain Microsoft authorization for protected APIs.
  • New – Added an option to hide/show nested group members (hidden by default).
  • New – Added new column ‘Extension’ in Attachments category in Group Conversation Posts module.
  • Improved – Group members module now also displays group owners and the means to manage them all.
  • Improved – Canceling a ‘Refresh All’ now offers an option to update the grid with partial results in Groups module.
  • Improved – Edition dialog in Groups now shows if information must be loaded before it can be edited thanks to an icon and text upon hover.
  • Improved – The creation feature in Groups module can now use selected groups’ info as template to prefill the creation dialog.

Files

  • New – Added columns for file check out status and applied retention labels in OneDrive Files, Group Files and Site Files modules.
  • Improved – ‘Created On’ and ‘Created by’ columns in OneDrive Files module now shown by default.
  • Improved – Flat view in OneDrive Files, Group Files and Site Files modules now hides folders by default to only display documents.
  • Fixed – Crash during file upload in OneDrive Files, Group Files and Site Files modules.

Reports

  • New – Added options for Usage Reports combining same report type data together into one report.

sapio365  1.6.2

Nov 28 2019

What’s new in the latest version?

Global – Improvements and fixes

  • Added new shortcut keys to limit expansion/collapse of categories and hierarchies in grid.
  • Cleaned up process log by removing debug entries.
  • Reorganized ‘Backstage’ menu into sections.
  • Added new sapio365 update notification in the main module (yellow).
  • Improved ‘Duplicates’ feature to work within categories when present.
  • Fixed display of duplicated users in edition dialog box.
  • Added new display of progress bar for initial CosmosDB sync and for Jobs update.
  • Improved throttling (pause) on high volume requests.
  • Fixed crash due to interruption of job and of loading drive items in users and groups
  • Fixed creation of Ultra Admin session (change of Microsoft API).
  • Fixed multiple issues related to high DPI.
  • Added Uninstall options to keep personal data for a re-install.

Users

  • Fixed ‘Undo’ (changes) for ‘Set/Remove Manager’ in Users.

Groups

  • Added Teams Settings in the group editing dialog.
  • Fixed ‘Convert to Team’ feature.
  • Fixed Group Posts and Channel Message: content preview is now shown.

Files

  • Added shortcut F2 to for the ‘Rename’ feature in Files.

Sites

  • Added Document Library information grid columns (quota, size, etc) in Sites.

sapio365  1.6.1

Oct 22 2019

Correction
  • New features now available in production release – Files module: ‘Create Folder’, ‘Import Folder’ and ‘Add Folder’

sapio365  1.6.0

Oct 17 2019

What’s new in the latest version?

Learn more about version 1.6 >

NEW – General

  • Schedule a job in Windows Scheduler directly from the sapio365 UI. (Applies to system-level jobs)
  • ‘sapio365 administration roles’ can now be assigned to non-global admins to govern access to RBAC, Comments and User Activity logs
  • Added counter in ‘loading’ dialogs to inform the user of what’s being processed and how quickly

Jobs

  • New – Main, Users: Trace email…
  • New – Main: Find all 0 byte files in SharePoint libraries
  • New – Main: Update Users & Groups cache
  • New – Main, Groups: Find Teams where members can add, edit or delete channels
  • New – Groups: Find last date groups were emailed…
  • New – Users: List owned teams for selected users

Global – Improvements and fixes

  • Fixed – date picker behaviour in dialogs
  • Fixed – display issue of search results in dialog (was hidden)
  • Fixed – log pagination for all modules
  • Improved – added ability to include parameters in the command line for the launching of sapio365
  • Improved – cache and loading performance in Users and Groups
  • Improved – integrated Javascript in Comments and automation CalcVar

Users

  • Fixed – ‘Undo’ feature for entries that were flagged “added/updated/removed manager”

Groups

  • New – Added icon for ‘is archived’ column for Teams in the Groups module

Files

  • New – Added a ‘Create new Folder’ button
  • New – Added buttons in Files: Upload files and folders
  • Fixed – Information was missing from root-level rows

Reports

  • Fixed – issues when exploding nested multi-value cells in Audit Logs
  • Improved – Sign ins module with loading options to restrict the retrieval of entries for a specific time range
  • Improved – Audit logs module with loading options to restrict the retrieval of entries for a specific time range
  • Adapted Usage Report module to handle future Microsoft changes (column property removal/addition)
  • Modified position of transported columns in Usage Reports module

sapio365  1.5.0

Aug 22 2019

What’s new in the latest version?

Learn more about version 1.5 >

NEW – General

  • NEW – Option on first launch to use cache when loading Users or Groups
  • NEW – Sign-ins report module
  • NEW – Audit logs report module
  • NEW – Additional properties can now be added in Usage reports
  • NEW – Additional properties can be selected and carried forward from any Users or Groups windows to any resulting windows
  • NEW – Messages & Events – Pre-filter options for time frame and result details (for faster results)
  • NEW – Messages & Events – New button: Get more messages/events. Loads the next batch of entries going back in time.
  • NEW – Messages & Events – New column properties ‘Icon’ and ‘Extension’ added
  • NEW – Added new ‘global’ Jobs (in main window)
  • NEW – Jobs can now be added and edited by users
  • NEW – Command line access to launch Jobs and automation processes

Jobs

  • NEW – Sign-ins – Find users who haven’t signed in since…
  • NEW – Users – Add selected as owners to all groups…
  • NEW – Groups with no calendar events
  • NEW – Groups with empty document library
  • NEW – File queries for groups and sites

Global – Improvements and fixes

  • Cell Explosions – improved the UI making it simpler to manipulate and understand the consequences
  • Hovering on exploded cells now shows their related values
  • Quick search in grid – new improved dialog
  • Grid – counter on groups and hierarchy is now cleaner and easier to understand

Groups

  • Groups – New properties added
  • Groups – Fixed ‘Add Guests’ property column
  • Groups – fix on owner management

Users

  • Users – Password Reset – UI improvement (columns and all)
  • Users – Getting license details is now faster (uses cache rather than reloading all)
  • Users – OneNote files can now be “managed” same as other OneDrive files (i.e. download, remove, rename…)

Grid configuration options reorganized

  • Colmn Map dialog improvements
  • Moved default menu and all sub-menus
  • Made the Manage Grid Config button more accessible

sapio365  1.4.0

Jun 11 2019

What’s new in the latest version?

Learn more about version 1.4 >

NEW – General

  • Caching of data for Users module and Groups module
  • Comments – Add personal comments in any grid – Can be shared and edited
  • Column Map available in all modules – Quickly find and add any column to any grid
  • Usage Reports available for Users and Groups
  • Drive quotas now available in Users module
  • Additional properties added to Users module
  • Drive quotas now available in Groups module
  • See and edit Managers in Users module
  • Global counters in Files module: number of files & folders; folder size; total size
  • New button: Create Teams from Groups
  • Teams icon now displayed in all group-related modules
  • New session: info about consent and its meaning
  • Multiple Ultra Admin sessions now possible on 1 tenant

Role-Based Access Control (RBAC)

  • New – Can now set credentials with a foreign tenant
  • New – Easy Create button for creating RBAC credentials
  • Improved – multiple improvements; more stable

Jobs

  • New – See users for selected licenses in Tenant Licenses module
  • New – Find shared files in Users
  • New – Find shared files in Groups
  • New – Find shared files in Sharepoint Sites
  • New – Deactivate selected users
  • Improved: find groups with no member, no owner
  • Various small improvements

Global – Improvements and fixes

  • New: easy Create button setup process for CosmosDB
  • New: easy Create button for Ultra Admin applications
  • Fixed potential issue with firewalls and proxies when logging in
  • Improved: on new session more info provided for login errors
  • Improved preferences panel
  • Fixed: formatting in grid for large numbers and bytes
  • Fixed: files’ permissions editing of type (read/edit)
  • Small fix: grid filters now show warning if no filterable rows available
  • Fixed: date format in grid and for export
  • Improved: drag & drop in grouping zone optimized
  • Simplified ribbon for User management & Group management sections
  • Simplified ‘Compare’ dialog
  • Global stability improvements
  • Various small fixes
  • Various UI improvements (incl. enhanced home page)
  • Various term corrections

Groups

  • New column: ‘Guest Allowed’ (true/false)
  • Improved: owners are now shown directly in the main Groups module
  • Refresh in Groups module no longer shows empty lines after a Load Info

Messages

  • Can now access users’ private chats from Teams in Messages module (listed as entries without any Parent Folder set)

Users

  • Small fix: canceling loading of users disabled all buttons in frame
  • Password column now displayed when creating a new user
  • User signed-in status shown as icon (replaced checkbox) for better readability

sapio365 Licensing

  • NEW – Only licensed users are counted toward Ytria licensing count
  • NEW – Now free access to personal data for all users

sapio365  1.3.0

Mar 19 2019

What’s new in the latest version?

New

  • Role-Based Access Control (RBAC)

Improved

  • Users – New properties
  • Group Members/User Memberships – faster retrieval
  • User/Group Selection dialog – now uses caching instead of ‘load all’ by default
  • Groups – Owners are now shown directly in the main Group ModuleGroup Recycle Bin – added new properties
  • OneDrive for Groups – removed incorrect Private status
  • Attachment related information – properties renamed
  • Horizontal scrolling in the grid is much faster
  • Improved display of icons on HDPI
  • No more main-frame size limitation

Fixed

  • Users – some information was not shown after making an edit
  • OneDrive – was missing data for some users
  • Group Members – corrected potential infinite loop handling of some complex group nesting
  • Groups – was missing information after creation
  • Group Delivery Management – ‘Delete Restrictions’ was not working
  • Group Recycle Bin – ‘Deleted time’ was not displayed
  • Sites – ‘Created on’ and ‘Modified’ columns were always empty
  • Grid – in Hierarchy mode – hiding a parent was not hiding its children
  • Grid – the date format was inconsistent when using copy/paste
  • Ytria License – improper tenant name was used for license validation

Jobs

  • New – Users: Show external email forwarding rules for all users
  • New – Groups : Get memberships of a selected group
  • New – Groups: Find empty groups
  • New – Groups: Find memberless groups
  • Fixed – Groups: Show groups with guest owners
  • Fixed – Users : Export content of all selected users
  • Fixed – Groups: All documents/folders shared with guests

sapio365  1.2.0

Jan 21 2019

What’s new in the latest version?

New

  • Added mail header information in the Messages grid.
  • New ribbon function: Rename OneDrive files and folders.
  • Added access to new information (OneDrive, mail, etc…) for User and Group Recycle Bins.
  • Added new ‘Last queried on’ column to show when the data was last requested.
  • Added User Activity Logs to keep track of user-initiated editions.
  • Added new column in Groups: Membership count.
  • Added new column in Groups: Owner User Names.

Optimized

  • Added new ‘Assigned Licenses’ column in the Users grid.
  • Changed the value type and terms for the ‘Sign-in status’ column in the Users grid.
  • Changed the scope on which the Refresh Selected and Save Selected take effect when the grid has been categorized.
  • When grouping, terms of categorized values are now displayed as ‘True/False’; changed from ‘Checked/Unchecked’.

Improved

  • Content search for Group Conversation Posts is now available via added ‘Preview’ column in the grid.
  • Optimized loading of OneDrive item permissions. ‘Owner’ permissions are now hidden by default.
  • Cleared up the organization of exploded multiple value cells with index columns on the extreme left.

New Jobs Added

  • Users: Users with duplicate plans
  • Users: List Teams of selected users
  • Users: Export content of all selected users
  • Users: View by status: guest, sign-in, unlicensed…
  • Groups: All documents and folders shared with guests
  • Groups: Add ‘non-member’ group owners as members for selected groups.

Fixed

  • Fixed large volume processing issue when fetching messages and events.
  • Additional miscellaneous fixes.

sapio365  1.1.0

Oct 18 2018

What’s new in the latest version?

New

  • License/service plan editing implemented in Licenses module.
  • Copy/move now possible for group memberships.
  • Mail rules now available (for current user, and in Ultra Admin sessions only).
  • Revamped UI/logic for group member handing in both Users and Groups module.

Improved

  • Edit/refresh in hierarchy grid now allowed for targeted data “scopes.”
  • Upgraded selection dialog mechanics for groups and users.
  • General grid UI improvements.

sapio365  1.0.1

Oct 03 2018

What’s new in the latest version?

Fixed

  • More fixes and continual improvement of how sapio365 works with proxy connections.
  • Issues with display/retrieval for certain properties in Groups module now fixed.
  • Error management when retrieving additional data in Users and Groups has been improved.

New

  • Multiple new jobs now available in the Job Center console.
  • Invert grid selection now possible.

New

    • Significant performance enhancements for loading speed and data manipulation.
    • Better handling of additional data retrieval for open grids.
    • Cell explosion for multivalue cells now with clearer UI.
    • General grid UI improvements.

sapio365  1.0.

Jul 28 2018

Official Base Gold Release

sapio365  0.5.0

Jul 01 2018

What’s new in the latest version?

Fixed

  • Proxy connection errors have been solved! Some users would receive an error when trying to provide admin consent with application IDs set to the previously recommended redirect addresses. The redirect address is fully user definable within sapio365.
  • Target folder when downloading files is now created. A fix for errors occurring when the target folder didn’t exist.
  • Records editing—fixed ‘Apply’ button being active even when no modifications had been made.

New

  • Create groups directly from sapio365.
  • Create user profiles.
  • Reset passwords on any number of users, with options to set custom or auto-generate passwords, and force change on next login.
  • Manage global group settings as well as group expiration policy settings.
  • View Microsoft Teams conversations and handle Teams-related information such as:
    – Member settings
    – Guest settings
    – Fun settings
    – Team URL
  • Concurrent live sessions. All sessions now stay active regardless of tenant, and without the need to sign in/out.
  • Restore, report, or fully delete soft-deleted users, groups, and sites.
  • Edit granular permission settings on OneDrive files.

Improved

  • Editing of groups and users fully stable.
  • Better multi-value cell handling and presentation.
  • Better handling of “cancel” operations when loading a large volume of information.
  • Various performance improvements and visual enhancements.
  • Continued ribbon UI consolidation.