sapio365 v2 History

See where sapio365 has been

sapio365  2.2.1

April 22 2024

What’s new in the latest version?

New features

  • Enabled sapio365 installation via an application deployment solution.
  • Enabled sapio365 to run in a multi-user (windows) environment allowing the installation of sapio365 for all users on a computer instead of at the user level using a command line.
  • Added ability to configure the SQL Server Cache configuration for multiple sessions at once using a button in Recent Sessions section.
  • Added ability to edit Service Principals, including their Custom Security Attributes.
  • Added Mailbox Name property column in the Users module, and added the ability to edit its value once loaded (Mailbox Info).
  • Added ability to add owners to private or shared channels in Channel Members module.
  • Added “Hard-Delete” button in Users’ Messages submodule to move emails to Purges folder directly.
  • Added the ability to create a Snapshot or Restore point in Users submodule “On-Premises Group Memberships”, and Group submodules “Delivery management” and “On-Premises Members”.
  • Added ability to transfer sapio365 working environment (sessions, preferences, etc.) to another computer.
  • Added ability to configure the SQL Server Cache configuration for multiple sessions at once using a button in Recent Sessions section.

Automated Tasks (Jobs)

  • New Job in Users and SharePoint sites “Manage user access to selected sites” to report site collection admins, or list everyone who has access to selected users’ OneDrive or sites. You have the option to grant or remove access in general or from the list of site collection admins.
  • New job “Compare Groups Members” in ALL JOBS: Schedule the comparison of members of selected groups in reference to a specific  group. You have the options to automatically add or remove reference group members to the target groups.
  • Improved “USER OFFBOARDING”, “ONBOARDING USERS” and “Set selected users SAME AS…” jobs by allowing them to run on synced accounts even if on-prem data has not been loaded. Only cloud functions will be enabled like copying/removing from roles, copying/removing licenses, etc…
  • Improved “ONBOARDING USERS” job with new option to enforce legacy Multi factor Authentication (MFA).
  • Improved processing times of large data sets by jobs “Hard-delete selected events” and “Hard-delete selected messages”.
  • Improved jobs “Get ALL across mailboxes related to a selected” for Messages and Events with options to omit process-heavy steps like fetching Mailbox Info and Full Access permissions and optimized grid processing for large volumes of entries.
  • Improved “Hard-Delete Events” job by adding an option to do a regular delete (soft-delete).
  • Improved “Update cache of Users, Groups and Sites” job with options to Reload and Reinitialize.
  • Improved jobs “Get ALL entries related to the selected calendar event” and “Get ALL messages across mailboxes related to a selected message” in Events and Messages submodules respectively by automatically logging in to a saved Restore Point.
  • Fixed issue in job “Update cache of Users, Groups and Sites” which previously failed to return an error when a module could not be opened.
  • Fixed issue of App session-based scheduled jobs where it got stuck sometimes and could not run.
  • Fixed issue where encountered loading error in jobs “Build a report from a view” and “Build usage report from a view” stopped the job.
  • Fixed cause of technical error being displayed in summary for “USER OFFBOARDING” job.

Miscellaneous general fixes and improvements

  • Improved dialogs using multi-line text/HTML editors, where you can now Ctrl+Home and Ctrl+End.
  • Improved visibility of grid data’s “Load Status – Last queried on” date by making the column easier to find (in the Sessions tab).
  • Renamed ‘Devices’ module title as ‘Registered Devices’.
  • Improved several modules by adding ability to save Snapshots and Restore Points: Sign-ins, Audit Logs, Deleted Users, Deleted Groups, Tenant Licenses and Service Plans, Registered Applications, Registered Service Principals and Registered Devices.
  • Improved organization of right-click menu for actions in Events and Messages modules.
  • Improved grid behaviour in Events and Messages submodules when refreshing after a deletion made elsewhere. Previous an error was displayed.
  • Improved license validation error dialog which use to display an incorrect message.
  • Improved help diagnose SQL Server Cache connection issues with a test button in the SQL Server Settings section.
  • Improved the saving process for Users and Groups by only refreshing the modified object.
  • Improved License Configuration Settings by automatically providing the user count of the current tenant before adding it as a new one.
  • Improved User Activity Log with a loading dialog when clicking “View Logs from this computer”.  User Activity Log is only available when logged in.
  • Improved ticketing system with all characters being accepted instead of just numbers.
  • Improved tooltip of Temporary Comments by removing extraneous information.
  • Fixed display issue where Lite Mode was shown when no session was loaded.
  • Fixed issue where ‘Notes’ column value was shown in ‘notificationEmailAddresses’ column in Service Principals module.
  • Fixed regression affecting dialog fields using HTML editor, which was not working.
  • Fixed regression causing crash when editing an event’s All Day property from FALSE to TRUE.

Users

  • Improved loading of on-prem data limited to users in a “Details” or filtered module. Previously, all on-prem entries were retrieved.
  • Improved default view in all Users submodules by including ‘User Sync Enabled – On-Premises’ column. You must do a one-time “Reload” of cache so that the information is properly loaded in the grid.
  • Improved Filtered Users with more properties to filter from.
  • Fixed issue where removing an SMTP forwarding address was not saved.
  • Fixed issue where deleting a file, a message or event triggered the reloading of the user.
  • Fixed crash issue when loading mailbox permissions for mailboxes with conflict between Mailbox Name and nickname.
  • Fixed missing icon for Web URL column.
  • Fixed issue where errors were not shown when removing or adding mailbox permissions.
  • Fixed issue where saving the removal of a checkbox value for Custom Security Attributes did not send anything.
  • Fixed regression causing error when creating a new user account with mailbox other than “regular”.
  • Fixed MFA PowerShell issue when loading or editing MFA properties in more than one tenant at a time.

Groups

  • Improved loading of on-prem data limited to groups in a “Details” or filtered module. Previously, all on-prem entries were retrieved.
  • Improved default view in all Groups submodules by including Group Sync Enabled – On-Premises’ column.
  • Improved Filtered Groups with more properties to filter from.
  • Fixed issue when getting members and owners of particular distribution groups failed due to conflict between Mailbox Name and nickname.
  • Fixed issue where applying multiple changes to a group’s members resulted in “not applied” for changes when there was one error amongst them.
  • Fixed missing ‘Group ID’ value for top level rows in Group Members submodule.
  • Fixed issue where change status values in saved Restore Points of Group Members submodule could not be applied.
  • Fixed cause of crash when canceling a “Load additional info for this view?” process in Channels module.

Collaboration and RBAC

  • Fixed RBAC issue where scopes were assigned to Roles more than once if multiple roles wree selected.
  • Fixed Activity Log Sync issue when there is a large volume of records.
  • Fixed cause of crash when running a job in a Role Session that contained Public Comments.
  • Fixed unresponsive checkbox ‘Show all tenants’ in ‘Collaboration Database Information’ dialog of Collaboration Settings.
  • Fixed cause of crash when creating RBAC credentials using a Standard session.

Automation

sapio365  2.2.0

February 27 2024

What’s new in the latest version?

New features

  • Enhanced security of sapio365 role-based access control (RBAC) credentials by adding automatic password renewal parameters to the related sapio365 registered applications and service account to work in tandem with your tenant’s strict password policies.
  • Added the ability to share jobs and views when using a collaboration-enabled license.
  • Added ability to retrieve, add or remove Service Principals from assigned roles in ‘Roles and Administrators’ module.
  • Added new module ‘Service Principals’ with the possibility to retrieve information about the related registered application.
  • Added ability to transfer sapio365 working environment (sessions, preferences, etc.) to another computer.

Automated Tasks (Jobs)

Users:

  • NEW – Added a job to gather all emails and domains information for a selection of users.
  • Fixed a bug in User Off-boarding job where auto-mapping was not applied.

Groups:

  • NEW – Added a job to change the email domain of a selection of groups.
  • Fixed an issue in ‘Show groups/Teams with guest owners’ job where final grid was not showing the interesting information.

Messages:

  • NEW – Added a job to gather all recipients and senders e-mails and domains information for a selection of messages.
  • Improved ‘Get ALL messages from recipients related to selected message’ job by also taking into account email replies, forwarded e-mails and mailbox delegations.
  • Improved ‘Hard-delete selected messages’ job with option to limit Content Search batch volume and applied omission of selected emails in Purge and Versions folders for the search (folder content not applicable for hard-deletion).

Events:

  • Improved ‘Get ALL entries related to the selected calendar event’ job by also taking into account the ‘Send on behalf of’ property.
  • Improved ‘Build a report from view’ for calendar events with added option to retrieve Calendar View events.

Usage Reports:

  • NEW – Added the ability to schedule Usage Reports with ‘Build a usage report from a view’ job.

Miscellaneous general fixes and improvements

  • NEW – Improved grid grouping zone visibility by highlighting the grouping zone and its text in green when dragging a column header.
  • NEW – Improved grid with text size options to increase text size and cell height in Options tab.
  • NEW – Improved grid with a visible column selection indicator. The selected column now shows a border.
  • NEW – Added Current Release Notes section in the ‘back’ to show the release notes of the currently installed sapio365 version.
  • NEW – Improved loading progress display in modules with the addition of counts and time estimates.
  • Improved on-premise connection indicators in hybrid tenants though the use of different icons for each status: enabled, disabled, and not connected.
  • Improved access to “Select from File/Clipboard” by adding it to the Main Grid Menu.
  • Improved confirmation dialog of “Select from File” by indicating the number of rows selected in the grid and by adding a progress bar for the matching process.
  • Improved grid filter for cut-off date/time with option to invert results.
  • Improved scrollbars visibility in all grids.
  • Improved on-premises setup for new sessions on hybrid tenants.
  • Improved first start experience by guiding the user to their first session.
  • Fixed several issues in Elevated sessions management.
  • Fixed a regression where grid cells of Time-only type showed ‘Invalid DateTime’ value.
  • Fixed a grid issue where double-clicking on the border did not result in increasing the cell width to show the full column data.
  • Fixed how Comments are recorded in a cross-tenant RBAC role. They are now attributed to the tenant of the role instead of the delegate’s tenant.
  • Fixed a bug where loading an existing session could fail silently.
  • Fixed a bug where the ‘Update available’ notification would keep on showing even after sapio365 has been updated.
  • Fixed a bug where data in ‘Last queried on’ columns could have inconsistent time zones.
  • Fixed a performance issue when editing licenses.
  • Fixed a bug where ‘Service Capability Status’ column was always empty.
  • Fixed a bug where User/Group management actions were disabled for eligible rows in Flat View.
  • Fixed a bug where not all possible domains were listed when editing an on-premises User’s Username.
  • Fixed a bug where users/groups imported/updated from an excel file could miss some values.
  • Fixed a bug where the “External” information in Team Channels and Chats modules could be inaccurate with role sessions.
  • Prevent Standard Sessions from using shared cache to avoid overwriting valid data with partial data induced by standard session restrictions.

sapio365 role-based access control (RBAC)

  • NEW – Added the ability to configure automatic password renewal for the related sapio365 registered applications and service account.
  • NEW – Added the option to also delete the related sapio365 registered applications and service account when deleting a role in RBAC Configuration.
  • NEW – Added the ability to easily regenerate passwords for a role’s related sapio365 registered applications and service account.
  • Improved role session experience by alerting when the role credentials are about to expire.
  • Improved RBAC security by deprecating the use of custom (existing account or app) RBAC credentials. Dedicated RBAC credentials must now be created.
  • Made RBAC credentials creation easier by removing re-authentication requirement and by using the current session or an available partner access session.
  • Made the ‘Global Administrator’ requirement for the service account optional to work better with tenant policies.
  • Fixed an issue where the role creation dialog prevented using an existing reference name.

Collaboration

  • NEW – Added ability to make a custom job public to share it with others collaborating with the same sapio365 license.
  • Fixed a bug when no progress bar would be shown while writing data to a SQL server database.
  • Added the ability to retry after a failed attempt to write data to a SQL server database.
  • Fixed a few issues where the interface would hang for a while communicating with the collaboration server.

Partner Access

  • NEW – Reworked Partner Access management addressing many issues (existing Partner sessions must be recreated).
  • NEW – Added the ability to easily create RBAC credentials on a customer tenant using the partner access.
  • NEW – Added the possibility to schedule complex jobs on customer tenants.

Restore Points / Snapshots

  • NEW – Added an option to create smaller Restore Points by ignoring the hidden data (only for Users, Groups, Events and Messages).
  • NEW – Added the ability to append data to an existing Restore Point/Snapshot when applicable.
  • Fixed an issue where loading an existing Restore Point/Snapshot showed an error bar if that saved Restore Point/Snapshot had rows with errors.

Views

  • NEW – Added ability to make a saved View public to share it with others collaborating with the same sapio365 license.
  • Improved Views by adding a ‘Replaces’ vs ‘Merges’ option when saving a new View . When applied, this View can either replace the current grid sorting/grouping/filtering settings, or merge its own settings with these current settings.
  • Improved how Views are exported by offering a folder location to set.

Users

  • NEW – Added ability to retrieve and edit custom security attributes in Users.
  • NEW – Added ability to get and manage access to other users’ mailboxes with ‘Send on behalf to’ and ‘Trustee to’ properties in Users. These are retrieved with the ‘Mailbox Info’ button.
  • NEW – Added property columns ‘Password expiration Date’ and ‘User Purpose’.
  • NEW – Added ability to get and manage mailbox quota properties: Prohibit Send Quota, Prohibit Send, Receive Quota, Recoverable Items Quota, Recoverable Items Warning Quota, Issue Warning, Quota, Archive Quota, Archive Warning Quota, Max Send Size, Max Receive Size, Mail Tip. These are retrieved with the ‘Mailbox Info’ button.
  • Improved ‘Load Mailbox Info’ feature with more related columns to ‘Mailbox info – shared’, ‘Forwarding’, ‘Send as’, ‘Send on behalf of’, and also added the property ‘Has Picture’.
  • Improved feature “Update (cloud users) from file” by adding the “Manager” field in the mapping dialog.
  • Improved license management by enabling the retrieval of licenses for guest accounts (button was previously disabled for guests).
  • Improved loading of “Filtered Users” by adding more properties for filter rules.
  • Fixed a bug where opening User Details with more than 200 users would fail.

Groups

  • NEW – Added ability to add external users to shared Teams channels from the related button’s submenu option in the Channel Members module.
  • NEW – Added option in Channels module to load ALL members for selected shared channels, including Teams that channels were shared with. These nested Teams can be expanded to show indirect members.
  • NEW – Added ability to remove owners of shared and private Teams channels .
  • Improved loading of “Filtered Groups” by adding more properties for filter rules.
  • Improved ‘Teams only’ and ‘Security Groups only’ modules by using a filtered request.
  • Fixed a bug where opening Group Details with more than 200 groups would fail.
  • Fixed a bug where loading groups for the first time on tenant without any group would trigger a cache error.
  • Fixed a bug where an error would show in the grid for groups without owners.
  • Fixed a bug where ‘Enable Group Specific Consent’ setting wouldn’t show in ‘Global Settings’ dialog.
  • Fixed an issue where Group owners were always considered as Users even when they were Groups.
  • Fixed a bug where loading owners of a Distribution List would give an error if one of the owners is a RoleGroup.

Registered Applications

  • NEW – Added an hyperlink column containing the application’s Microsoft Entra admin center URL.
  • NEW – Used Service Principals data to fill out missing permission names.

Events

  • Fixed a bug where “Attendees – Response on” column contained invalid dates for attendees that had not responded yet.

OneDrive Files / Files

  • Fixed a bug where successfully uploading a file was impossible if ‘Load ALL drives’ option had been used.

Automation

sapio365  2.1.10

August 10 2023

What’s new in the latest version?

IMPORTANT – Updates to sapio365 sessions may impact how you use sapio365!

For detailed information see: https://docs.ytria.com/sapio365/version-2-1-10-important-modifications-on-sessions.

  • UPDATED sapio365 Advanced session: Added new Microsoft Graph permissions related to new features requiring admin consent.
  • UPDATED sapio365 Advanced Elevated session: Improved data access in Advanced Elevated sessions by switching some features to use elevated permissions instead of delegated ones. You may need to add new permissions requiring admin consent and you may need to add a role to the registered sapio365 app.
  • UPDATED sapio365 RBAC session: Changed how the sapio365 app credentials work together, inline with the new sapio365 Advanced Elevated session. You may need to add new permissions requiring admin consent and you may need to add a role to the registered sapio365 app.
  • NEW sapio365 App session: Added ability to create a registered application for a ‘sapio365 App Session’ to work in and to run scheduled tasks and reports without using user credentials.
  • UPDATED sapio365 Standard session: Replaced deprecated Microsoft Graph permission in sapio365 application used for Standard session. Note that this change significantly reduces sapio365 functionality.

New features

  • Added new ‘Registered Devices’ module listing properties of registered devices. This is accessible from the Tenant section in the sapio365 home window.
  • Added new ‘Chats’ and ‘Chat Messages’ submodules to retrieve all personal, team and meeting chats and message information. ‘Chats’ is accessible from Users module and from My Data.
  • Added ability to create new standard and private Teams channels, and the ability to edit them or to delete them.
  • Added ability to retrieve and edit mailbox recipient limits in the Users module.
  • Improved richness of Users and Groups submodules grid data by extending both User and Group attributes to these submodules via ‘additional columns’. You can set these via ‘Select User/Group columns to show in all sub-views…’ (previously called ‘Configure Transferred Columns’).
  • Added the option to use customer-owned SQL server as an alternative to Cosmos DB for sharing sapio365 data. Note that the ‘Set Cosmos DB’ section in ‘About sapio365’ has been replaced with ‘Set Collaboration Connection Info’ to set or update how data is shared in sapio365.

Automated Tasks (Jobs)

  • Improved global performance on all Jobs. The only bottleneck now is the time needed to requests the information from Microsoft 365 (which we can’t change unfortunately).
  • Added ability to edit the details of a saved Preset, letting you change the options of a scheduled job.
  • Added new task to move selected on-prem groups to another organizational unit (OU) in the Groups module (hybrid tenants): ‘Move selected to another on-prem Organizational Unit (OU)’.
  • Added new tasks which add a new email to the Microsoft 365 aliases list in the Users and Groups modules: ‘Add an alias/proxy address based on current email’. This will not modify the Username/group name nor will it change the email of the selected users/groups (cloud and synced).
  • Added new tasks to remove an email from the Microsoft 365 alias list in the Users and in the Groups modules: ‘Remove an email from the alias/proxy address list’. This will not modify the Username/Group name nor will it change the email of the selected users/groups.
  • Added new tasks to overwrite the on-prem list of aliases/proxy addresses by the Microsoft 365 aliases/proxy addresses in the Users and Groups modules: ‘Overwrite on-prem proxy addresses with cloud aliases’.
  • Improved task ‘Change User Domain’ in Users to change email addresses for both synced and cloud-only users with an existing email address. The update is executed on-prem or in the cloud respectively.
  • Improved task ‘USER ONBOARDING’ by adding the exporting of the list of new users with their new passwords, and with the option to ‘Save current configuration as Default’
  • Improved task ‘USER OFFBOARDING’ with new option to copy users’ OneDrive files to a Teams channel or to a newly created channel, and with the option to ‘Save current configuration as Default’.
  • Improved task ‘ Set selected users SAME AS…’ with option ‘Save current configuration as Default’
  • Improved report ‘Find users with external email forwarding inbox rules’ to also include rule ‘forward as attachment’ in criteria.
  • Improved report ‘Get ALL entries related to the selected calendar event’ in Calendar Events by handling situations where the owner of selected calendar is not part of the attendee list for the event or when the event is no longer in the organizer’s mailbox or calendar.
  • Improved handling and conveying of automation errors in the jobs with more information.
  • Removed option to create Snapshot/Restore Point for cross-tenant jobs in the Main window. You can have this option if you run on a single session.
  • Fixed automation task ‘Set Same AS’ where selected attributes of cloud-users were not copied to the target users and also fixed cause of error when the target on-prem user and the template user had the same value for License Usage Location.
  • Fixed report ‘Building a report from existing views’ where there was no report when using certain combinations of options and also fixed issue using on-prem group members views.
  • Fixed report ‘Multi-tenants Consumption License Analysis’ which was showing a wrong session error message if one of the selected session wasn’t able to complete the task.
  • Fixed report ‘Get All related to Selected Event’ in Events module which failed if the original event no longer existed.

Users

  • NEW Added Users module by adding property column ‘Last Sign-in on’ and other Azure AD Sign-in info properties which can be loaded with ‘Additional info’.
  • Improved Users module by adding property column ‘Employee Leave Date Time’, and by adding Azure AD Sign-in info properties  which can be loaded with ‘Additional info’.
  • Improved Users’ Messages submodule by retrieving hidden mail folders, identified by the new property column ‘Folder is Hidden’.
  • Improved Users’ Inbox Rules submodule by allowing the deletion of a rule even if just the component is selected, which is useful when working with filtered data.
  • Improved Deleted Users module by removing the option to load all drives when loading OneDrive Files and changed the title of the module from ‘Users Recycle Bin’ to ‘Deleted Users’ for consistency. Cleared up ribbon space in Users by removing ‘Recycle Bin’ button (Deleted Users view) since this view is not based on a selection and is available from the main sapio365 (Home) page. Also, removed the empty User Management area in Delete Users Licenses submodule.
  • Added missing ‘Delete Message Rules’ to RBAC permissions list.
  • Fixed access to Group Management section in the ribbon in the Mailbox Permission submodule. For example, previously group members could not be retrieved from selected group-type delegates because the button was disabled.
  • Fixed scenario issue where adding a proxy address to an on-prem user account with an empty list by clicking apply without having had clicked on the ‘plus’ icon. This erroneously showed the pencil icon in the status column.
  • Fixed missing display of ‘Access denied’ error message in the grid in OneDrive Files.
    Fixed issue where removing the value of Company Name of a cloud users resulted in an error.
  • Fixed ‘Create Users’ from file dialog where changing the number of rows to skip added an extra Mailbox Type field.
  • Fixed issue where it was not possible to save after removing all proxy addresses or all “Other mails” from an on-prem user.

Groups

  • Improved Groups grid by removing the property Unseen Count because it relates only to the signed-in user (count  of conversations that have received new posts since the signed-in user last visited the group).
  • Improved Channels and its submodules by making column titles more consistent between them and removing superfluous ones.
  • Improved loading of large volumes of Deleted Groups by limiting batch requests to 100.
  • Improved (speed up) User Management requests in Channel Members submodule by omitting external members.
  • Improved Deleted Groups module by changing the title of the module from ‘Groups Recycle Bin’ to ‘Deleted Groups’, and cleared up ribbon space by removing ‘Recycle Bin’ button (Deleted Groups) since this view is not based on a selection and is available from the main sapio365 (Home) page.
  • Improved ‘Create groups’ from file by adding the group owner field to map in the dialog.
  • Fixed regression which sent out a duplicate API request when editing a Team’s setting or archiving state.
  • Fixed issue in Group Memberships where copying a group to a user showed empty ‘additional/transferred column’ cells for the new groups entry in the grid.
  • Fixed issue of missing ‘Direct’ icon in the grid for new group memberships.
  • Fixed issues in ‘Create from file’ for importing cloud groups where ‘Email is missing’ dialog was shown for security group import and where email domain values were not validated before trying to create mail-enabled security groups or distribution groups.
  • Fixed missing Hide button when Grid Manager was open in Channel Members module.
  • Fixed ‘Create Groups’ from file dialog where changing the number of rows to skip added an extra Group Type field.

Miscellaneous Modules

  • Improved the loading of the local cache or cache shared on a SQL server.
  • Improved loading of OneDrive and Drive Files submodule where loading big number of files.
  • Improved ‘Upload Folder’ dialog in Files submodule with only 3 options instead of 3:  ALL or CONTENT ONLY.
  • Improved Registered Applications module by adding ‘Permission name’ property column.
  • Improved loading of Sign-ins by decreasing the request limit to 100 avoiding server errors due to large volume.
  • Improved the License Tenant allocation dialog with vertical auto-sizing.
  • Improved Files submodule by positioning the download “progress” column right after the file name, excluding it from the “green background” change behaviour, and ignoring it in views.
  • Improved Usage Reports by adding newly available property columns, mainly in the Teams User Activity report.
  • Fixed regression where it was not possible to edit created entries (new users, groups, etc.).
  • Fixed issue where a file is kept open after an upload when the file is bigger than 4MB.
  • Fixed issue in ‘My OneDrive files’ module where uploading a file with the name of the first file in the grid was allowed instead of launching a conflict dialog.
  • Improved address book selection dialog for adding  user/group by adding text ‘Double-click to remove from selection’.
  • Added ability to change the millisecond delay for each type of sapio365 request via the registry in order to reduce the number of requests per minute.
  • Fixed View issue in hybrid tenant where filters on Common column are not retained in the saved View.
  • Improved awareness of Autoload on-prem data option that was set by specifying ‘on-prem’ in the ‘Refresh outdated on-prem cache?’ alert window.
  • Fixed missing On-prem User Management/Group Management sections in ribbon when loading a sapio365 Restore Point.
    Fixed missing icons in some user columns in Members, Owners and Delivery Management.
  • Fixed regression where there was a date discrepancy when loading Activity Logs from cloud.
  • Improved loading time from cache in large environments of partially loaded users and groups in Users and in Groups modules. The ‘Refresh?’ question now comes up faster.
  • Improved User Activity Logs by adding a column with the name of the target tenant in the case of managing multiple tenants through sapio365 RBAC.

Sessions and RBAC

  • Fixed potential cause of crash during authentication.
  • Fixed regression related to role-based session where several sub-modules could not be opened.
  • Improved sapio365 application updates by adding information about missing permissions needed for in-use registered sapio365 applications associated to  Elevated, RBAC and App sessions.
  • Improved control over the current session’s registered sapio365 application by adding a link in the ‘Manage Privileges’ and ‘App Details’ dialogs that open the application in the Azure Portal. And you can see if the application is missing permissions and choose to add them automatically.
  • Improved User Activity Logs by adding a column with the name of the target tenant in the case of managing multiple tenants through sapio365 RBAC.
  • Improved awareness of sapio365 license over-usage/capacity by making the dialog clearer.
  • Fixed RBAC issue where connecting for the first time using a session with an enforced role created an empty entry in the Recent Sessions List.
  • Fixed RBAC issue where loading a Snapshot/Restore Point saved in an RBAC role session tries opens instead in another active recent session.
    Fixed RBAC issue where it was not possible to do a Force Sync in a role session.
  • Fixed RBAC issue where in a role session clicking an out-of-scope feature opens the ‘Insufficient Role Permission’ dialog over the main window instead of the current window.

Miscellaneous general fixes and improvements

  • Improved column value filters where you can now see all values previously filtered and change your previous selection.
  • Improved ‘Remove Duplicates’ feature by enabling it if duplicates info is present and removing them from a list.
  • Improved grid behaviour where now hierarchy columns and comments update only with data is changed, and where sorting or grouping no longer trigger a hierarchy or comments update.
  • Improved the ‘Convert text to date/time’ dialog by adding some format examples.
  • Improved dialog when unloading filtered and hidden entries in Groups and Users module. It’s now clear that you can restore them with ‘Reload’ button.
  • Improved the ‘unloading’ filtered and hidden rows in the grid by adding process count and a progress bar.
  • Improved grid refresh behaviour for multi-value properties. “Processing Multivalues” will be shown when multivalues are exploded or imploded, a field is modified, or when a row is added.
  • Fixed editing exploded multi-value issue. Example:  in OneDrive module where after saving a read to write permission change or vice versa, the pencil icon remained in the grid.
  • Fixed how multi-values are handled in building charts and pivot table. Explode them first to process them as single values.
  • Fixed Comments issue where ‘Refresh’ greyed out (disabled) the ‘View Orphans’ button.
  • Fixed regression where ‘Invert result’ and ‘Case Sensitive’ Reg Ex filter options applied on a column were not saved in Views.
  • Fixed regression where Exchange PowerShell module check failed because there was more than one version of a module installed.
  • Fixed crash caused by PowerShell deserialization issue.
  • Fixed behaviour of applied Views on newly added columns through loading like in hybrid tenants.

Automation

sapio365  2.1.9

March 20 2023

What’s new in the latest version?

New features

  • Enhanced and optimized how Mailbox Permissions are managed. Now you can remove or add delegates (including groups) or even copy them to other mailboxes regardless if they have ‘Send on behalf of’, ‘Send as’, ‘Full Access’, or other access rights in Mailbox Permissions module. You can also clear auto-mapping for all delegates of a selected mailbox.
  • Added ability to delete or to edit applications’ name, description and URLs in the Registered Applications module.
  • Added ability to view and update the details (email notifications and options) of a saved Preset of an automated job listed in the Job Center Configuration.
  • Moved feature ‘Reset Password’ on-premises to ribbon button of the same name so that you can delegate the feature in a RBAC role. It was previously part of Edit (users on-prem).
  • Added ability to create a security or Microsoft 365 group that can be assigned to an Azure AD role with the option “Assignable to role”.
  • Added ability to create a distribution group or an email-enabled security group. Previously, only security or Microsoft 365 groups could be created because of Graph API restrictions.
  • Added ability to move or copy messages to other mail folders you select. If messages in more than one mailbox are selected, they will be copied or moved to folders within their respective mailboxes.
  • Added ability to set rules for random password generation in sapio365 including the minimum password length and the minimum number of uppercase, lowercase and special characters.
  • Added ability to create a shared mailbox or resource account (room or equipment), and also to import several of them from a CSV or Excel file.
  • Added an option to load ALL channels from Teams, including external channels. A check mark in the new ‘External’ column will indicate if a channel belongs to another tenant. Note that retrieving members of an external channel is not included but will be available in a future release.
  • Added shared mailbox properties “Copy items sent as this mailbox” and “Copy items sent on behalf of this mailbox” with the ability to update them in Users.
  • Added additional user properties option in Sign-ins reports just like the ones in Usage Reports.
  • Added the ability to display selected properties in the grid immediately after loading more information for efficiency. You will be asked which properties to display for each type of “Load Info”.

Automated Tasks (Jobs)

  • Added NEW scheduled report “Build a report from a view” to create a report from an existing view from a main module or from one of its sub-modules. This report can be cross-tenant.
  • Added NEW report “Find mailboxes that selected users can access” in Users Job Center which lists mailboxes where your selected users have Full Access rights. From there, you can see what other users or groups have access to those mailboxes, remove or modify those permissions, or add new delegates.
  • Added NEW task “Move selected to another on-premises Organizational Unit (OU)” in Users window that will change the OU of on-prem or synced user accounts you select to another OU. You can move accounts to an existing OU, or to a new one created at the root level.
  • Added NEW tasks “Enable In-Place Archive Mailboxes” and “Disable In-Place Archive Mailboxes” in the Job Center in Users to let you manage the state of in-place archive mailboxes.
  • Improved task “USER ONBOARDING” to create new users on-premises as well as in the cloud. We’ve also added new options to copy Full Access mailbox delegates and access to others’ mailboxes from template users. This task is in the Users Job Center.
  • Improved task “Set selected users SAME AS…” with new options to copy Full Access mailbox delegates and access to others’ mailboxes from template users. This task is in the Users Job Center.
  • Improved task “USER OFFBOARDING” by adding options to remove all mailbox permissions, and to set “Copy to Sent Items folder” if converted to a shared mailbox. Also fixed option “Move users to a specific Organizational Unit” to accept the full path of an OU. Previously it was only at the root.
  • Improved task “Hard-delete selected events” in group and user calendar modules with option to soft-delete recurrent event instances in Calendar View which could not be hard-deleted.
  • Improved task “Get ALL entries related to the selected calendar event” in Users’ and in Groups’ Event Calendar submodules by adding an option to limit results up to 72 hours after the last modified date of the original event.
  • Added a log for jobs/automation to let you know when, what and who executed a job or automation.
  • Fixed issue with cross-tenant jobs in ALL JOBs where the automation resulted in an empty error “The job was unable to complete”.

Users

  • Improved on-prem data loading for Users by adding a new option in the submenu of the feature to ‘Reload selected on-prem users’ instead of reloading all users.
  • Improved Users Activity logs by recording Sync Cloud/On-Premises actions in Users module.
  • Improved Users module by adding ‘Resource Capacity’ property column to represent the maximum capacity set for rooms or equipment type accounts. You can edit this value once you retrieve it with the ‘Load Mailbox Info’ option.
  • Improved cloud user creation, including when importing from file, by adding custom extension attribute fields to the dialog.
  • Improved Users grid by adding ‘Scheduling’ as a new Mailbox Type for accounts that were created by the Bookings app in Microsoft 365.
  • Improved mailbox information in the Users module by adding In-Place Archive status, name and GUID property columns. Their values are retrieved with the ‘Mailbox Info’ load action.
  • Improved Mailbox Permissions by adding columns ‘Delegate Display Name’, ‘Delegate Group Type’, and ‘Delegate User Type’ in all Mailbox Permissions Views to account for groups with access rights to mailboxes.
  • Improved Mailbox Permissions window by fixing elements in the Session tab of the ribbon; Manage, Add and Remove options were missing in the Data subcategory.
  • Improved UI for updating on-prem users’ managers by selecting from the on-prem directory list.
  • Improved on-prem user management features ‘Create’ and ‘Import’ by adding an auto-generating password option. We’ve also made User Principal Name mandatory with the on-prem domain to avoid errors and we’ve organized and added categories for those features.
  • Improved managing MFA in Users module by adding a section in the edition dialog that lets you remove methods common to selected users, and to set one as default. We’ve also added a submenu feature to remove MFA methods from all selected users even if they don’t have any in common.
  • Improved Views for on-prem users data. Now, once on-prem user accounts are loaded, the newly shown Common Columns in the grid will remain unaffected when switching to another View.
  • Fixed grid handling and display issues for specific mailbox permission situations: display of several “NT AUTHORITY/SELF” mailbox permissions, repeated rows if ExternalAccount was mixed with other permissions, etc.
  • Fixed inability to save Snapshots and Restore Points of Mailbox Permissions with pending changes in the grid.
  • Fixed cause of crash when loading licenses for a large number of users due to abnormally high memory consumption.
  • Fixed error handling of Error 400 which was shown in the gid for users where more than one Load additional info was done.
  • Fixed issue in Messages load dialog where when unchecking ‘Recoverable Items Folder’, the number limit of messages gets activated, whereas the toggle is still off.

Groups

  • Improved on-prem data loading for Groups by adding a new option in the submenu of the feature to ‘Reload selected on-prem groups’ instead of reloading every group.
  • Improved Users Activity logs by recording Sync Cloud/On-Premises actions in Groups module.
  • Improved Team Channels view by adding icons in the grid for shared and private channels, and by adding the columns ‘Tenant ID’ and ‘External’ to indicate if a shared channel is external to the tenant. ‘External’ has also been added to all system views there.
  • Improved Channel Members view by adding ‘Tenant ID’ property column. This indicates if a member is external to the tenant by showing a checkmark in the ‘External’ column which was added to all system views.
  • Improved Channel Members and other channel sub-modules by adding ‘Channel Type’ column to indicate if channel is private, shared or standard. This column has also been added to all system views there.
  • Improved Load Info request for Distribution Lists and Mail-enabled security groups to retrieve data that was otherwise not retrieved due to Graph API limitations.
  • Improved edition of distribution groups and mail-enabled security groups by enabling the update of ‘Allow External Senders’ and ‘Hide from address lists’.
  • Improved management of owners of distribution groups and mail-enabled security groups by switching to PowerShell because of current Microsoft Graph API limitations.
  • Improved views in Channel Sites by adding columns ‘Team Display Name’, ‘Channel Display Name’, ‘Channel Type’.
  • Improved views by adding a default system view in Group Sites and by adding columns ‘Group Display Name’, ‘Is a Team’ and ‘Group Type’.
  • Improved shared and private channel member addition feature by showing the username in the directory selection dialog if there is no email available for the member.
  • Improved loading of on-prem group members or memberships with fresh requests instead of using cache.
  • Improved Views for on-prem group data. Now, once on-prem groups are loaded, the newly shown Common Columns in the grid will remain unaffected when switching to another View.
  • Improved Channels Members submodule by adding Group Management section in the ribbon.
  • Improved the loading process of group members for large groups and the error handling of adding existing members.
  • Improved Groups module for on-prem data by moving the on-prem group attribute “mail” to the Common section of the loading dialog. This also makes it always available when creating, editing, updating or importing on-prem groups.
  • Unsandboxed ‘Delete’ feature in Group Conversations submodule.
  • Fixed non-functional Group Management section buttons in the ribbon in Channel Sites submodule.
  • Fixed non-functional Group Management section buttons in the ribbon in Flat view of the Teams Channels submodules.
  • Fixed issue of missing values in the grid for group policy status when loading groups from cache.
  • Fixed flat view of Team Channel Members grid which showed first level rows when it should not.
  • Fixed issue where retrieving User Details of a member of a Teams Channel resulted in a view with on-prem user accounts loaded.
  • Fixed ‘Load all channels’ option in Groups view to retrieve the channel type value of shared channels. It was previously displayed as unknown.

Miscellaneous general fixes and improvements

  • Improved user experience by splitting PowerShell initialization from features that use PowerShell. sapio365 now checks at launch if all required PowerShell modules are available. This information is available in Preferences.
  • Improved flat view actions in submodules where for example, you can now request User Details on a selection of users grouped by licenses. Previously, the buttons were disabled and you had to switch to hierarchy to use them.
  • Improved feature ‘Import from file’ by giving the user information about entries that were skipped after the work is done.
  • Loading errors that show in the grid are no longer cached.
  • Improvement Files module by omitting queries ‘Load Checkout Info’ at the drive label, and by changing its status column and that of ‘Load Permissions’ into a date/time type columns instead of checkbox.
  • Improved sapio365 RBAC by adding the feature ‘Edit Mailbox Permissions’ as a permission. You can now use it in a role.
  • Improved handling of timeouts in automated tasks (jobs) which caused an infinite loop in some instances.
  • Improved grid features ‘Find All’, ‘Find First’ or a ‘Start With’ when no matches result. You will now see ‘NOTHING FOUND’ at the bottom left of grid when there is no result.
  • Improved dialog text with a more consistent terminology for the following user and group management features in Users and Groups windows, especially for hybrid environments: Create, Delete, Edit, Update from file and Create from file.
  • Improved grid behaviour by minimizing column rank columns when switching to flat from hierarchy.
  • Improved how views are saved and loaded in Snapshots and Restore Points. It’s a much smoother experience now.
  • Improved how views are applied. You now have the option to choose to apply sorting, grouping, etc.
  • Improved Sort/Filter tab by moving ‘Unload filtered entries…’ To the Advanced section of the ribbon.
  • Improved control of automated tasks with sapio365 RBAC roles. sapio365 users can now only use system jobs in a RBAC-role session. They can no longer use custom jobs or automations.
  • Improved RBAC by recategorizing certain RBAC permissions and changing some terms, and added new permissions: Add “User – Revoke Access”, Add “User – View Recycle Bin”, Add “Group – Edit Channel Members”, Add “Group – Edit Channel Members (including out-of-scope items)”, Add “Group – View Channel Messages”, Add “Group – View Channel Files”, Add “Group – View Channel Members”, Add “Group – View Channel Sites”, Add “Group- View Recycle Bin”, Add “Site – View Lists”, “Edit Tenant Registered Applications” and “Delete Tenant Registered Applications”.
  • Improved RBAC role sessions by removing the option to view out-of-scope entries in a RBAC role session.
  • Improved sapio365 license activation limit management by letting sapio365 users delete old or obsolete activations to free up new ones. This is available in the About panel of sapio365.
  • Fixed RBAC issue where out-of-scope parent SharePoint sites were hidden even though they had in-scope children.
  • Fixed issue where entering a password with special characters (ex. $) for on-prem connection parameters failed.
  • Fixed Sign-ins reports by retrieving missing data of conditional access policies with addition of new permission Policy.Read.All to sapio365.
  • Fixed grid issue with on-prem data in Users and Groups windows where the on-prem Status column was shown in the wrong column category and affected certain grid functions.
  • Fixed issue where the preview of a comment formula does not match the format of the comment column itself.
  • Fixed Cosmos DB data issue for User Activity which was not showing for all sapio365 users.
  • Fixed throttling issue for retrieving Mailbox Info for large numbers of mailboxes which resulted in PowerShell errors.
  • Fixed handling of one hundredth of a second for date/time values in the grid (usually in logs) which affected the sorting of the value and its export.
  • Fixed usability issue where an error message dialog was stuck behind a sapio365 starting dialog preventing all further action.
  • Fixed issue in sub-modules when adding entries in Flat View from Session tab – Add to Selection were not shown when switching to Hierarchy View.
  • Fixed issue where the ‘Compare Values’ feature was not working for dynamic columns like Column Comments.
  • Fixed unexpected behaviour for sorting date multivalues.
  • Fixed issues when importing jobs including where importing an existing job without a name/icon/description set inside the job header erases the existing settings.
  • Fixed issue where User Activity Logs were not showing the values for auto-reply messages columns.
  • Fixed cause of crash when elevating a session from prompt of a new Advanced session due to webview2 issue.
  • Fixed cause of crash due to mishandling of Microsoft placeholder date for null value.
  • Fixed issue in Comments where a JavaScript escape was needed for a properly handling grid text for annotation formulas.
  • Fixed issue where ‘Show Duplicate in Grid’ was tagging hidden rows instead of being applied only visible ones.
  • Fixed export issues; exporting to Excel did not include milliseconds in time fields and some kind of value was set for grey cells creating an unexpected situation.
  • Fixed time discrepancy in grid because of daylight savings time changes.
  • Fixed cause of Error h800c0008 when downloading files via sapio365 update.
  • Fixed how views are shown in the dropdown-menu. The width is now dynamic so you can see the full name of the view. Also fixed it so that the sorting coming from a view replaces an existing one.
  • Fixed several view issues; selected view is not shown as ‘modified’ even if the pre-existing sorting is not in the view, importing a view does not keep its settings.
  • Fixed font issue in the Release Notes panel in sapio365 (update).
  • Fixed issue where Usage reports showed bad top categories for certain multi-reports.
  • Fixed comment column behaviour issue where applying a view resulted in hiding comment columns.
  • Fixed issue where saving a modified view showed the wrong view name in the save option.
  • Fixed issue where scheduled jobs could not be executed if sapio365 was installed in the program files directory.

Automation

sapio365  2.1.8

September 29 2022

What’s new in the latest version?

New features

  • Added ability to assign and remove admin/directory roles to groups, and adjusted the system Views accordingly.
  • Added ability to manage mailbox auto-replies in the edition dialog in Users. You can now enable, disable, change dates and messages for existing out-of-office replies.
  • Added ability to add new members (from the current tenant) to shared channels, access shared channel sites and files. Previously, these features were was disabled for shared channels.
  • Added retrieval of emails in subfolders Versions, DiscoveryHolds and SubstrateHolds to the “Recoverable Items Folder” option.

Jobs

  • NEW job “Add or remove group memberships of selected users (cloud)” to improve large volume group membership management in Users. You no longer need to load all group memberships before being able to add them.
  • NEW job “Tag selected entries in Users, Groups or Sites” in Usage Reports to compare report entries with the directory list by adding a comment for these entries in their relevant main module Users, Groups or Sites.
  • NEW job “Get ALL recipients and select them in Users and Groups” in user messages module to identify all recipients of the selected messages by adding a comment for each recipient in the main module Users and Groups.
  • NEW job “Get ALL attendees and select them in Users and Groups” in user events and in group events to identify all attendee entries by adding a comment for each attendee in the main module Users and Groups.
  • Improved job “Get ALL entries related to the selected calendar event” to use organizer’s event as main reference regardless of selected event. Added checking calendars of users who were forwarded the event directly or on behalf of another account, checking mailboxes of users who have full access to a mailbox to which an email invitation was sent, and checking mailboxes of calendar delegates. Also added options to speed up query: do not search emails, do not gather folders name (flat) and do not gather Recovery Items Folders.

Users

  • Improved Users module by adding new user properties to grid. And some user properties are now loaded by default instead of with “Additional Load”.
  • Improved the loading time of messages by making the loading of folder path information an option. By excluding this option, you can retrieve messages faster but you will not know which folder they are in.
  • Improved filtered loading of Messages and Events by adding “contains” and “does not contain” pre-filters, and by removing non-functioning ones.
  • Improved filtered loading of Users by adding the “endsWith” filter to applicable fields.
  • Improved loading of OneDrive Files by adding “Load Files – Option” dialog to retrieve files from all drives or just from the main one.
  • Fixed issue causing sapio365 crash when loading a very large volume of messages for all users.
  • Fixed issue in users’ OneDrive Files module where the drive name was displayed as “OneDrive” for every drive in multiple drive cases.

Groups

  • Improved Groups module by adding new group properties to the grid. And some group properties are now loaded by default instead of with “Additional Load”.
  • Improved filtered loading of Groups by adding the “endsWith” filter to applicable fields.
  • Improved loading of document library Files for Groups and for Sites by adding “Load Files – Option” dialog to retrieve files from all document libraries or just from the main one.
  • Improved management of private and shared channels by adding a time delay to avoid errors resulting from Microsoft processing delays.

Miscellaneous general fixes and improvements

  • Fixed WebView2-related issue which made it impossible to open a session in sapio365 if Conditional Access was set in Azure.
  • Fixed issue with setting up new on-prem RBAC credentials or updating existing ones which returned “Error when validating On-premises Credentials” although the credentials were valid.
  • Improved Cosmos DB management by enabling signed-in users who are not global admins but who have the sapio365 General Managers role (sapio356 Access & Restrictions) to manage Cosmos DB connections in sapio365.
  • Improved sapio365 usage by global admin by adding ability to recognize the signed-in user as a global admin because they belong to a group with the “Global Admin” role assigned to it. Previously, group roles were not managed in sapio356, and as a consequence, areas like “RBAC config”or “sapio356 Access & Restrictions” were unavailable to this type of global admins.
  • Improved “Import, Update, Select” features that use a CSV or Excel file by adding a dialog “Continue to select a file for column mapping?” before opening the file selection explorer.
  • Improved sapio365 license over usage dialog with link to section where you can add capacity.
  • Improved tooltip display of rich text cells containing html by showing the html content. Previously, the tooltip rendered the html.
  • Improved Column Map by auto-scrolling to the currently selected column.
  • Fixed issue where sapio365 would exit when saving a view using certain characters in the title.
  • Fixed issue where some columns were no longer categorized. Examples: On-Premises Status lost its category after a re-initialize, Column Comments lost category after switching tenants.
  • Fixed missing display of URL address in the Property Viewer. Previously it displayed “Open” text string (used as a link in the grid).
  • Fixed various issues in the License Modification dialog box including resizing and input behaviour.
  • Improved error message when trying to delete RBAC credentials or scopes used by existing roles. Previously, the information about the affected roles was all in one big paragraph.
  • Fixed connection issue where changing proxy settings resulted in keeping the old settings for sessions that were already open
  • Fixed Restore Point issue where pending changes were not saved in saved Restore Points for modules: Users, Groups, Events, Messages, Group Members, Deleted Users, Deleted Groups, Directory Roles, Group Memberships, Message Rules, User Licenses.
  • Fixed issue with Group transfer column cells displaying “N/A” in the resulting Sites submodule when in fact, the original cell was empty.
  • Fixed multi-value explosion behaviour where some exploded rows disappeared from the grid when “Load Info” was applied to one of the exploded rows or if an entry was modified.

Automation

sapio365  2.1.7.2

July 25 2022

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.