Manage Azure Active Directory users and their properties
There are over 150 user properties available in sapio365. Use the Column Map to add or remove them from the grid to help you analyze user information to manage your users.
Click on a section below or scroll down to see what solutions are available to manage users with sapio365.
Load more properties
Some properties require separate loading using a designated button in the ribbon. The icon and text will indicate which button to use.
Note: Editing these properties requires loading.
1 - Load Info: access mail and SharePoint information
Use this button to retrieve information about mailbox settings like out-of-office replies, language and time zone. This will also load in the grid users' personal SharePoint sites information like interests, schools, skills as well as their OneDrive storage information.
2 - Get Mailbox Info: access mailbox delegation information
Use this button to retrieve mailbox access and forwarding information for selected users.
|Property||Description of value|
Status - Get mailbox info
|Indicates if 'Get Mailbox Info' has been loaded.|
|Shared or user type mailbox|
Keep copy of forwarded message (SMTP) - Mailbox Settings
|Setting option for SMTP forwarding|
SMTP forwarding address - Mailbox Settings
|Email address set for SMTP forwarding|
Forwarding addresses - Mailbox Settings
|Email addresses set by user with mail flow settings|
'Send on behalf of' delegates - Mailbox settings
|Users who can send email on behalf of this mailbox|
|'Send as' delegates - Mailbox Settings||Users who can send emails from this mailbox|
Use these buttons to manage users you select.
1 - Create a new user
Create a new user in Azure AD based on the properties of selected existing users. The creation dialog will be populated with the properties common to all users you selected.
2 - Import users from a file
Add users in bulk to Azure AD using any CSV or Excel file. Headers are optional and if you do have them they do not need to be formatted since the import dialog allows you to map the data which will be added to the grid.
3 - Delete users
Clicking on the 'Delete' button will flag selected users to be deleted upon saving.
Deleted users will be sent to the User Recycle Bin, and are kept there usually for 30 days with the option to restore them or to delete them permanently.
Update users' information
Make changes to users' properties based on a grid selection of users or a file.
1 - Edit users
Make changes to user information for all the users you select.
Common and different values for all selected users are indicated in the dialog. Click on the pencil icon to change a value. Once you click Apply, you will see the changes you made in the grid before you save them.
Note: Values that are displayed using 'Load Info' can only be changed if they are loaded in the grid.
2 - Update users from a file
This feature allows you to make specific bulk changes to users properties using an CSV or Excel file.
Similar to the 'Import users' feature, 'Update users' lets you map the columns in your file to the columns in the sapio365 grid. The only difference is that you are asked which property to use as the criteria used to match file data to that of the grid (pink rectangle in image below): Username or Graph ID.
Prepare the Users module grid with the users you wish you to modify, and export it. Make your changes in the file and use it to update those users. sapio365 will try to automatically match header names to the grid columns, and prefill mapped data in the mapping dialog.
Reset passwords & revoke access
1 - Reset users' passwords & force password change
Use this feature to reset users' MS 365 passwords to a given password or to randomly-generated passwords, or force users to change their password (with or without the next time they login. These can be executed separately or together.
Note: After clicking on 'Apply', make sure to copy the passwords from the grid before saving because this is the only time you will see them.
Note: The enforcement flags for password change will be set in the grid for a user until the user changes their password.
2 - Revoke users' access to MS 365
Clicking on the 'Revoke Access' button will revoke session tokens for selected Azure AD users, signing them out of MS 365 sessions to force them to sign-in again. This may take up to 15 minutes to complete. Once the changes are saved, the 'Sign-in Sessions validity' date is reset to the date and time the revoking took place. You may need to refresh to see new date/time.
More information can be found in Microsoft's documentation on revoking sessions.
Permanently delete or restore deleted users
View deleted user accounts which are available for reinstatement. You can access this from the Users module or from the main window.
1 - Restore users
Use this button to restore the user account and its associated data, including licenses (they will be assigned if they are available), OneDrive files, and mail.
2 - Permanently delete users
Click this button to permanently delete users. Once grid changes are saved, this action cannot be undone.
Get users' messages, mail settings, inbox rules, calendar events, personal contacts
Use features in the 'User Management' area to access tools to manage mail and calendar information for selected user accounts, including shared mailboxes, rooms and equipment. Open each submodule in the current window or in a new one.
When retrieving mail messages, folders and calendar events, you can choose a specific date range, or criteria to speed things along. You can also choose to more information. For example, you can include Teams private chat messages, header information and more when querying messages.
1 - Update mailbox permissions
Launch this submodule and you will see who has access to selected mailboxes and with which permissions. You'll be able to add or remove delegates, and change their permissions.
Note: You will be asked to confirm a session or sign-in even if you have enforced Single-sign-on on your machine because this feature requires PowerShell authentication.
2 - Delete messages and attachments
The Messages submodule lists emails for selected mailboxes with rich information about each message and its attachments.
You will able to see a preview of the message, and you can even download it as an EML files to your computer. Use any mail client, including Outlook, to view an EML file.
Load attachment information to see attachment names and other properties. You'll then be able to download them or delete all attachments for selected messages, or 'explode' them to process them individually.
3 - Delete calendar events and attachments
The Events submodule lists calendar events for selected users with rich information about each event and its attachments.
Just like in the Messages submodule, you will able to see a preview of the events, and manage event attachments.
4 - See users' personal contacts
List personal contacts for selected users, including all their contact information.
5 - Delete inbox rules
See selected users' inbox rules and their components including conditions, exceptions and actions. From here, you can delete rules as long as they are not 'Read-only'.
Note: Due to Microsoft Graph API limitations, rules that are indicated as 'Read-only' will appear empty.
Get group memberships
Select users and retrieve a list of the groups they belong to by clicking on 1) "Group Membership" button.
In the new view, you can 1) add selected users to others groups, or 2) remove, copy or move the selected group memberships from those users to other users.
As always, you can always undo the resulting changes in the grid before you save your changes.
OneDrive documents and folders
Select users and retrieve information about their OneDrive content by clicking on 1) "OneDrive Files" button.
In the resulting submodule, you will see each users' files listed in within their folder hierarchy. From there, you can select documents or folders to 2) rename them, download them, or delete them from their respective OneDrive. You can also check them out or update their sharing permissions.
NEW - Users on-premises
Over 100 on-prem attributes
sapio365 2.1 brings you an unprecedent global view of all user accounts displayed in the FlexyView Grid. You can see right away which accounts are not synced, which are cloud-based and which are on-premises only.
Quick analysis with the tools within sapio365 can quickly reveal problems like lack of synchronization and other identity management issues.
When you 'Load On-premise Users', you retrieve more than 100 additional properties, bringing the total to over 250 users attributes for synced user accounts!
You can now see the entirety of your user accounts in one place to easily identify, analyze and fix identity management issues.
Mass edition of on-prem and hybrid users
Just like for cloud-only user accounts, you are able to directly make changes on a mass scale to user properties in Active Directory directly from sapio365 with the secure 2-step saving process of sapio365.
We have also added a Quick Search feature in the edition dialog so that you can quickly find the attribute of interest – handy when there are so many property fields.