Job Catalog

Creation reports


View groups created within a date range
List groups with a creation date that falls between the dates (inclusively) you specify.

List recently created Teams channels
List the Teams channels that were created on and after a specific date and categorize them by their creation date and the Team they belong to.

eDiscovery


View emails sent from select mailbox owners within a date range
Retrieve email messages sent from selected mailboxes within a specified date range.

SharePoint Sites files created within the date/time range
List SharePoint sites files created within the date/time range.

Group files created within the date/time range
List groups files created within the date/time range.

Find OneDrive files created within a date range
Search users’ OneDrive and list files created within a specific date range.

Find OneDrive files by name or type for selected users
Search selected users’ OneDrive for files that match a specified name and extension type.

Find files by name or type for selected sites
Search selected SharePoint site document libraries for files that match a specified name and extension type.

Trace email using subject, sender and recipient info
Search all mailboxes for a string in the name of the sender, recipent or subject in the latest messages.

View channel chats of all Teams
List chats of all Teams. Private channel chats are included if you are part of the channel or if you have received approval from Microsoft for sapio365 to request private channel chats.

Find 0-byte files in SharePoint libraries
Search and list all SharePoint document libraries for 0-byte sizes files.

View channel chats of selected TeamsList chats of selected Teams. Private channel chats are included if you are part of the channel or if you have received approval from Microsoft for sapio365 to request private channel chats.

Find files by name or type for selected groups and Teams
Search selected group and Teams document libraries for files that match a specified name and extension type.

Email trace


Search all mailboxes and find attachments by name or type
Search all users’ mailboxes and lists attachments that match a specified file name and extension type.

View emails sent from select mailbox owners within a date range
Retrieve email messages sent from selected mailboxes within a specified date range.

Search selected users’ mailboxes and find attachments by name or type
Search mailboxes of selected users and list attachments that match a specified file name and extension type.

Find the last time groups were emailed
Search members’ mailboxes to find the last time selected groups were sent an email. Select groups from distribution groups, Teams, Office 365 groups or email-enabled security groups.

View email messages of all users
List email messages of all users in one place. Choose a date range and use advanced filters to limit your results. From this view, you can delete messages, dowload attachments and messages.

View email messages of selected users
List email messages of selected users in one place. Choose a date range and use advanced filters to limit your results. From this view, you can delete messages, download attachments and messages.

View message rules of selected users
List message rules of selected users.

Usage reports


View users’ last activity by location or department
List the last time each user was active in Office 365, and categorize them by department or location.

Get OneDrive activity usage report
List OneDrive activity in the last 180 days.

Get OneDrive usage report
List OneDrive usage in the last 180 days.

Get usage report of Teams user activity
List Teams user activity in the last 180 days.

Get usage report of Email activity
List Email activity in the last 180 days.

Get usage report of Email app activity
List Email app activity in the last 180 days.

Get Mailbox usage report
List Mailbox usage in the last 180 days.

Get usage report of Office 365 groups activity
List Office 365 groups activity in the last 180 days.

Get usage report of Office 365 active users
List Office 365 active users in the last 180 days.

Get usage report of Office 365 activations
List Office 365 activations.

Get usage report of SharePoint activity
List SharePoint activity in the last 180 days.

Get SharePoint site usage report
List SharePoint site usage in the last 180 days.

Get usage report of Skype for Business activity
List Skype for Business activity in the last 180 days.

Get usage report of Skype for Business device usage
List Skype for Business device usage in the last 180 days.

Get usage report of Yammer activity
List Yammer activity in the last 180 days.

Get Yammer device usage report
List Yammer device usage in the last 180 days.

Get usage report on Yammer groups activity
List Yammer groups activity in the last 180 days.

Export content of selected users
Select users and download their OneDrive files to your local machine. This job also exports Excel or XML reports on their group memberships, roles, assigned licenses, personal contacts, messages and inbox rules, and OneDrive file information.

View ownerless groups
List groups without assigned owners. From there, you can add new owners or promote members to those groups to ensure a healthy collaborative environment.

Groups/Teams with shared files (anonymous, guests, etc)
List Office 365 groups/Teams and their library files shared anonymously, directly with guests, or within the organization.

Users with shared files (anonymous, guests, etc)
List users and their OneDrive files shared anonymously, directly with guests, or within the organization.

Find OneDrive files created within a date range
Search users’ OneDrive and list files created within a specific date range.

Find OneDrive files by name or type for selected users
Search selected users’ OneDrive for files that match a specified name and extension type.

Find files by name or type for selected sites
Search selected SharePoint site document libraries for files that match a specified name and extension type.

View files of all groups
List documents and folders in a hierarchical view for every group and Team document library. From this view, you can upload files or delete them, and you can see file information like who last modified it, the creation date, if it was shared and how it was shared and with whom. You can also change or remove file permissions.

Groups with duplicate files
List groups that have duplicate files.

Sites with duplicate files
List sites that have duplicate files in their document library.

Users with duplicate files
List users who have duplicate OneDrive files.

SharePoint sites without any files
List SharePoint sites whose document library does not contain any files.

View OneDrive files of all users
List files and file information for all users’ OneDrive. In this view, you can download, upload or delete files, and you can manage file permissions.

View OneDrive files of selected users
List files and file information for selected users’ OneDrive. In this view, you can download, upload or delete files, and you can manage file permissions.

Find users with OneDrive files shared within the organization with a link
List all users with OneDrive files shared within the organization using a sharing link. From there, you can delete the link.

Find users’ OneDrive files shared with guests
Search users’ OneDrive and list files shared with guests.

Find users’ OneDrive files shared with many
Search all users’ OneDrive and list files that have been shared with more than a specified number of people.

Find group/Teams files shared within the organization with link
List all groups/Teams and their document library files shared within the organization using a sharing link. From there, you can delete the link.

Find groups and Teams files shared with guests
Search group and Teams document libraries and list files shared with guests.

Find group and Teams files shared with many
Search all group and Teams document libraries and list files that have been shared with more than a specified number of people.

Find site document library files shared within the organization with a link
List all sites with document library files shared within the organization using a sharing link. From there, you can delete the link.

Find site files shared with guests
Search SharePoint site document libraries and list files shared with guests.

Find site document library files shared with many
Search all SharePoint sites and list files that have been shared with more than a specified number of people.

Get OneDrive activity usage report
List OneDrive activity in the last 180 days.

Get OneDrive usage report
List OneDrive usage in the last 180 days.

View lists of all SharePoint sites
List SharePoint list information of all sites and subsites. In this view, you can access list item information and list column information.

View list items of all SharePoint site lists
List every list item for every SharePoint site list. Display site list item information like last modified by, creation date, checked out to, version, retention label, etc.

View files of selected groups
List documents and folders in a hierarchical view for selected groups and Teams document library. From this view, you can upload files or delete them, and you can see file information like who last modified it, the creation date, if it was shared and how it was shared and with whom. You can also change or remove file permissions.

Find files by name or type for selected groups and Teams
Search selected group and Teams document libraries for files that match a specified name and extension type.

Back up


Export content of selected users
Select users and download their OneDrive files to your local machine. This job also exports Excel or XML reports on their group memberships, roles, assigned licenses, personal contacts, messages and inbox rules, and OneDrive file information.

Help desk


View active users
List all users and their properties, including licensed and unlicensed users, rooms, equipment, and shared mailboxes. From there, you can edit users’ properties, reset passwords, and perform various other identity management actions.

Migration


Find 0-byte files in SharePoint libraries
Search and list all SharePoint document libraries for 0-byte sizes files.

Synchronization


View active users
List all users and their properties, including licensed and unlicensed users, rooms, equipment, and shared mailboxes. From there, you can edit users’ properties, reset passwords, and perform various other identity management actions.

Update cache of Users and Groups
Update the local cache of the Users and Groups modules.

User management


View guest users
List guests and their user properties.

Export content of selected users
Select users and download their OneDrive files to your local machine. This job also exports Excel or XML reports on their group memberships, roles, assigned licenses, personal contacts, messages and inbox rules, and OneDrive file information.

View active users
List all users and their properties, including licensed and unlicensed users, rooms, equipment, and shared mailboxes. From there, you can edit users’ properties, reset passwords, and perform various other identity management actions.

Search all mailboxes and find attachments by name or type
Search all users’ mailboxes and lists attachments that match a specified file name and extension type.

Restore deleted users
Restore a selection of user accounts deleted in the last 30 days and which can still be restored.

Find users with a service plan assigned before a specific date
List users who were assigned a selected service plan before a specific date.

Deactivate selected users
Apply various offboarding options to selected users: block sign-in, revoke access, reset password, remove licenses and delete accounts.

Search selected users’ mailboxes and find attachments by name or type
Search mailboxes of selected users and list attachments that match a specified file name and extension type.

Find OneDrive files created within a date range
Search users’ OneDrive and list files created within a specific date range.

Find OneDrive files by name or type for selected users
Search selected users’ OneDrive for files that match a specified name and extension type.

View owned Teams for selected users
Identify and list Teams owned for each user you select.

View Teams of selected users
List all the Teams each selected user belongs to.

View all Admin Audit Log entries
List all available event entries from the Admin Audit Log. You can find who initiated changes to users’ information, group and Teams memberships, and other areas of interest.

View all sign-in activity
List all available sign-in activity entries in Azure Active Directory. You can see who has attempted to sign in, the frequency of sign in attempts, sign-in location and more.

View all administrator roles
List all administrator roles in Azure Active Directory and their assigned users. From there you can add or remove assignments.

Chart of global license consumption
Show chart of global license consumption.

View users with selected licenses
Lists users who have selected licenses assigned. From there, you can remove or assign new licenses to those users.

View group memberships of all users
List every users’ group membership. From this view, you can add or remove group memberships.

View assigned licenses of all users
List licenses assigned per user. In this view, you can add or remove licenses, and enable or disable service plans.

View Licenses and service plans of all users
List licenses and service plans assigned per user. In this view, you can add or remove licenses, and enable or disable service plans.

View email messages of all users
List email messages of all users in one place. Choose a date range and use advanced filters to limit your results. From this view, you can delete messages, dowload attachments and messages.

View personal contacts of all users
List all the personal contacts and their information for every user.

View group memberships of selected users
List selected users’ group membership. From this view, you can add or remove group memberships.

View assigned licenses of selected users
List licenses assigned per selected user. In this view, you can add or remove licenses, and enable or disable service plans.

View Licenses and service plans of selected users
List licenses and service plans assigned per selected user. In this view, you can add or remove licenses, and enable or disable service plans.

View email messages of selected users
List email messages of selected users in one place. Choose a date range and use advanced filters to limit your results. From this view, you can delete messages, download attachments and messages.

View personal contacts of selected users
List all the personal contacts and their information for selected users.

View message rules of selected users
List message rules of selected users.

Find users with OneDrive files shared within the organization with a link
List all users with OneDrive files shared within the organization using a sharing link. From there, you can delete the link.

Get OneDrive activity usage report
List OneDrive activity in the last 180 days.

Get usage report of Teams user activity
List Teams user activity in the last 180 days.

Get usage report of Office 365 active users
List Office 365 active users in the last 180 days.

Get usage report of Office 365 activations
List Office 365 activations.

Get usage report of Skype for Business activity
List Skype for Business activity in the last 180 days.

Get usage report of Skype for Business device usage
List Skype for Business device usage in the last 180 days.

User offboarding


View sign-in blocked users
List users who are blocked from signing in to Microsoft 365.

Delete users
Delete selected users. You can restore deleted users within 30 days from the recycle bin.

Export content of selected users
Select users and download their OneDrive files to your local machine. This job also exports Excel or XML reports on their group memberships, roles, assigned licenses, personal contacts, messages and inbox rules, and OneDrive file information.

View active users
List all users and their properties, including licensed and unlicensed users, rooms, equipment, and shared mailboxes. From there, you can edit users’ properties, reset passwords, and perform various other identity management actions.

View deleted users
List users deleted in the last 30 days. From there you can restore or delete them permanently.

Restore deleted users
Restore a selection of user accounts deleted in the last 30 days and which can still be restored.

Remove all licenses from users with blocked sign-ins
List assigned licenses of users whose sign-in is blocked and choose to remove their licenses. If licenses are assigned via a group, users will be also removed from those groups.

View unlicensed users
List users without any licenses assigned to them.

Deactivate selected users
Apply various offboarding options to selected users: block sign-in, revoke access, reset password, remove licenses and delete accounts.

Users without managers
List users without an assigned manager. From there you can set a manager to ensure continued access to users’ content.

View users with managers
List users who have a set manager.

View all sign-in activity
List all available sign-in activity entries in Azure Active Directory. You can see who has attempted to sign in, the frequency of sign in attempts, sign-in location and more.

View users with selected licenses
Lists users who have selected licenses assigned. From there, you can remove or assign new licenses to those users.

Find users unable to use Teams
List users for whom sign-in is blocked, no Teams license is assigned, or their Teams service is disabled.

User onboarding


View unlicensed active users
Get a list of users and their properties without any assigned Microsoft 365 licenses. This includes guests, shared mailboxes, rooms and equipment.

View sign-in allowed users
List users and their properties who are set to be able to sign in to Microsoft 365.

View active users
List all users and their properties, including licensed and unlicensed users, rooms, equipment, and shared mailboxes. From there, you can edit users’ properties, reset passwords, and perform various other identity management actions.

Restore deleted users
Restore a selection of user accounts deleted in the last 30 days and which can still be restored.

Find users with a service plan assigned before a specific date
List users who were assigned a selected service plan before a specific date.

View unlicensed users
List users without any licenses assigned to them.

View users with selected licenses
Lists users who have selected licenses assigned. From there, you can remove or assign new licenses to those users.

View users’ last activity by location or department
List the last time each user was active in Office 365, and categorize them by department or location.

View licensed users
Get a list of users and their properties, including sign-in blocked status, who have MS 365 licenses assigned to them.

View unlicensed active users
Get a list of users and their properties without any assigned Microsoft 365 licenses. This includes guests, shared mailboxes, rooms and equipment.

View sign-in allowed users
List users and their properties who are set to be able to sign in to Microsoft 365.

View sign-in blocked users
List users who are blocked from signing in to Microsoft 365.

View pending service plans for selected users
Identify and list users who are assigned licenses that include service plans with a pending status.

Export content of selected users
Select users and download their OneDrive files to your local machine. This job also exports Excel or XML reports on their group memberships, roles, assigned licenses, personal contacts, messages and inbox rules, and OneDrive file information.

View by status: guest, sign-in, unlicensed
Filter down to a list of guests users, users allowed/blocked from signing-in, or licensed/unlicensed users.

Licenses of sign-in blocked users
List users whose sign-in is blocked and who also have assigned licenses. You’re then able to remove licenses from users within the resulting window.

Remove all licenses from users with blocked sign-ins
List assigned licenses of users whose sign-in is blocked and choose to remove their licenses. If licenses are assigned via a group, users will be also removed from those groups.

Users by assigned & unassigned licenses
Categorize active users by their assigned and unassigned Office 365 licenses.

Find users with a service plan assigned before a specific date
List users who were assigned a selected service plan before a specific date.

Users with duplicate plans
List users with licenses that have overlapping service plans.

View unlicensed users
List users without any licenses assigned to them.

Users by license usage location
List users grouped by their license usage location.

Chart of global license consumption
Show chart of global license consumption.

View users with selected licenses
Lists users who have selected licenses assigned. From there, you can remove or assign new licenses to those users.

Users with empty OneDrive accounts
List all users without any documents in their OneDrive.

Users with no calendar events
List all users without calendar events.

Report users by disabled service plan
List disabled service plans and the users affected by the plan.

View summary of all licenses and service plans
List all purchased licenses and the service plans within each. In this view, you will see how many licenses are consumed and if there are any suspended licenses.

View assigned licenses of all users
List licenses assigned per user. In this view, you can add or remove licenses, and enable or disable service plans.

View Licenses and service plans of all users
List licenses and service plans assigned per user. In this view, you can add or remove licenses, and enable or disable service plans.

View assigned licenses of selected users
List licenses assigned per selected user. In this view, you can add or remove licenses, and enable or disable service plans.

View Licenses and service plans of selected users
List licenses and service plans assigned per selected user. In this view, you can add or remove licenses, and enable or disable service plans.

Calendar events


View calendar events of all groups
List every group’s calendar events and event information. In this view, you can also see attachment information and delete attachments.

View users’ calendar events for a date range
List calendar events and their properties for selected users for a specific date range.

View calendar events for all users
List every users’ calendar events and event information. In this view, you can also see attachment information and delete attachments.

View calendar events for selected users
List selected users’ calendar events and event information. In this view, you can also see attachment information and delete attachments.

View calendar events of selected groups
List selected group’s calendar events and event information. In this view, you can also see attachment information and delete attachments.

Email messages


Search all mailboxes and find attachments by name or type
Search all users’ mailboxes and lists attachments that match a specified file name and extension type.

View emails sent from select mailbox owners within a date range
Retrieve email messages sent from selected mailboxes within a specified date range.

Find users with external email forwarding inbox rules
List users and their inbox rules forwarding mail to external addresses.

Search selected users’ mailboxes and find attachments by name or type
Search mailboxes of selected users and list attachments that match a specified file name and extension type.

Find the last time groups were emailed
Search members’ mailboxes to find the last time selected groups were sent an email. Select groups from distribution groups, Teams, Office 365 groups or email-enabled security groups.

Trace email using subject, sender and recipient info
Search all mailboxes for a string in the name of the sender, recipient or subject in the latest messages.

Users by auto-reply status
Categorize users by their out-of-office (auto-reply) status.

View email messages of all users
List email messages of all users in one place. Choose a date range and use advanced filters to limit your results. From this view, you can delete messages, dowload attachments and messages.

View personal contacts of all users
List all the personal contacts and their information for every user.

View email messages of selected users
List email messages of selected users in one place. Choose a date range and use advanced filters to limit your results. From this view, you can delete messages, download attachments and messages.

View personal contacts of selected users
List all the personal contacts and their information for selected users.

View message rules of selected users
List message rules of selected users.

Get usage report of Email activity
List Email activity in the last 180 days.

Get usage report of Email app activity
List Email app activity in the last 180 days.

Get Mailbox usage report
List Mailbox usage in the last 180 days.

View OneDrive files of selected users
List files and file information for selected users’ OneDrive. In this view, you can download, upload or delete files, and you can manage file permissions.

Administrator roles


Chart admin roles by user count
Create a chart of user count based on the assigned administration role.

Export admin roles by users
Export a list of directory roles by users.

Security


View licensed users
Get a list of users and their properties, including sign-in blocked status, who have MS 365 licenses assigned to them.

View unlicensed active users
Get a list of users and their properties without any assigned Microsoft 365 licenses. This includes guests, shared mailboxes, rooms and equipment.

View guest users
List guests and their user properties.

View sign-in allowed users
List users and their properties who are set to be able to sign in to Microsoft 365.

View sign-in blocked users
List users who are blocked from signing in to Microsoft 365.
View by status: guest, sign-in, unlicensed
Filter down to a list of guests users, users allowed/blocked from signing-in, or licensed/unlicensed users.

Remove all licenses from users with blocked sign-ins
List assigned licenses of users whose sign-in is blocked and choose to remove their licenses. If licenses are assigned via a group, users will be also removed from those groups.

View ownerless groups
List groups without assigned owners. From there, you can add new owners or promote members to those groups to ensure a healthy collaborative environment.

Deactivate selected users
Apply various offboarding options to selected users: block sign-in, revoke access, reset password, remove licenses and delete accounts.

View emails sent from select mailbox owners within a date range
Retrieve email messages sent from selected mailboxes within a specified date range.

Groups/Teams with shared files (anonymous, guests, etc)
List Office 365 groups/Teams and their library files shared anonymously, directly with guests, or within the organization.

Users with shared files (anonymous, guests, etc)
List users and their OneDrive files shared anonymously, directly with guests, or within the organization.

SharePoint Sites with shared files (anonymous, guests, etc)
List SharePoint sites and their library files shared anonymously, directly with guests, or within the organization.

List users with & without recent sign-in activity
List users sign-ins activity for a specific period in the last 30 days.

Groups with guest members
List groups/Teams with members who are guests (external).

View all Admin Audit Log entries
List all available event entries from the Admin Audit Log. You can find who initiated changes to users’ information, group and Teams memberships, and other areas of interest.

View all sign-in activity
List all available sign-in activity entries in Azure Active Directory. You can see who has attempted to sign in, the frequency of sign in attempts, sign-in location and more.

View all administrator roles
List all administrator roles in Azure Active Directory and their assigned users. From there you can add or remove assignments.

Trace email using subject, sender and recipient info
Search all mailboxes for a string in the name of the sender, recipient or subject in the latest messages.

View all email-enabled security groups
This job lists all email-enabled security groups with over 100 properties all in one place. In this view, you can edit groups’ properties and settings, and perform various other group management actions.

View all security groups
This job lists all security groups with over 100 properties all in one place. In this view, you can edit groups’ properties and settings, and perform various other group management actions.

Show groups/Teams with guest owners
List groups/Teams that have owners who are guests.

Groups with anonymously shared files
List groups/Teams with files that have been shared using an anonymous share link.

SharePoint sites with anonymously shared files
List SharePoint sites with files that have been shared using an anonymous share link.

Users with anonymously shared files
List users with OneDrive files that have been shared using an anonymous share link.

Find users unable to use Teams
List users for whom sign-in is blocked, no Teams license is assigned, or their Teams service is disabled.

View OneDrive files of all users
List files and file information for all users’ OneDrive. In this view, you can download, upload or delete files, and you can manage file permissions.

Clean up Teams with guest members
List Teams with guests and Teams where guests can be added, with options to change this group setting and to remove guests from those Teams.

Find users with OneDrive files shared within the organization with a link
List all users with OneDrive files shared within the organization using a sharing link. From there, you can delete the link.

Find users’ OneDrive files shared with guests
Search users’ OneDrive and list files shared with guests.

Find users’ OneDrive files shared with many
Search all users’ OneDrive and list files that have been shared with more than a specified number of people.

Find group/Teams files shared within the organization with link
List all groups/Teams and their document library files shared within the organization using a sharing link. From there, you can delete the link.

Find groups and Teams files shared with guests
Search group and Teams document libraries and list files shared with guests.

Find group and Teams files shared with many
Search all group and Teams document libraries and list files that have been shared with more than a specified number of people.

Find site document library files shared within the organization with a link
List all sites with document library files shared within the organization using a sharing link. From there, you can delete the link.

Find site files shared with guests
Search SharePoint site document libraries and list files shared with guests.

Find site document library files shared with many
Search all SharePoint sites and list files that have been shared with more than a specified number of people.

Get Teams device usage report
List Teams device usage in the last 180 days.

Get Yammer device usage report
List Yammer device usage in the last 180 days.

SharePoint sites


View group sites
List SharePoint sites and subsites of every group. From this view, you can access site information like usage quotas, lists, document library files, etc.

View list items of all group site lists
List every list item for every group SharePoint site list. Display groups’ site list item information like last modified by, creation date, checked out to, version, retention label, etc.

View list columns of all group sites
List every list column and its information of all SharePoint site lists. Get list column information of group sites like if columns are hidden, text type, calculated formulas, etc.

SharePoint sites without any files
List SharePoint sites whose document library does not contain any files.

View all SharePoint sites
List all SharePoint sites and subsites, and their information such as storage usage and quotas, creation dates, links, etc. From this view, you can access document library files and site lists.

View private channel sites
List SharePoint sites and site information of every private channel.

View all SharePoint sites & subsites by type (Teams, Yammer, private channels, etc)
Get a clearer view of your SharePoint site topology. See which sites belong to Teams, private channels, regular Office 365 groups or Yammer-linked groups.

Find group/Teams files shared within the organization with link
List all groups/Teams and their document library files shared within the organization using a sharing link. From there, you can delete the link.

Find site document library files shared within the organization with a link
List all sites with document library files shared within the organization using a sharing link. From there, you can delete the link.

Find site files shared with guests
Search SharePoint site document libraries and list files shared with guests.

Find site document library files shared with many
Search all SharePoint sites and list files that have been shared with more than a specified number of people.

Get usage report of SharePoint activity
List SharePoint activity in the last 180 days.

Get SharePoint site usage report
List SharePoint site usage in the last 180 days.

View lists of all SharePoint sites
List SharePoint list information of all sites and subsites. In this view, you can access list item information and list column information.

View list items of all SharePoint site lists
List every list item for every SharePoint site list. Display site list item information like last modified by, creation date, checked out to, version, retention label, etc.

View list columns for all SharePoint site lists
List every list column and its information of all SharePoint site lists.

View sites of selected Office 365 groups
List SharePoint sites and subsites of selected Office 365 groups. From this view, you can access site information like usage quotas, lists, document library files, etc.

View list items of selected Office 365 groups sites
List every list item for selected Office 365 groups SharePoint site list. Display groups’ site list item information like last modified by, creation date, checked out to, version, retention label, etc.

View list columns of selected Office 365 groups sites
List every list column and its information of selected Office 365 groups SharePoint site lists. Get list column information of group sites like if columns are hidden, text type, calculated formulas, etc.

Storage


Groups with duplicate files
List groups that have duplicate files.

Sites with duplicate files
List sites that have duplicate files in their document library.

Users with duplicate files
List users who have duplicate OneDrive files.

SharePoint sites without any files
List SharePoint sites whose document library does not contain any files.

View private channel sites
List SharePoint sites and site information of every private channel.

Get SharePoint site usage report
List SharePoint site usage in the last 180 days.

Back up


Export content of selected groups
Select groups or Teams, and download their document library files and group conversation attachments to your local machine. Export Excel or XML reports on group members and owners, Team channels and chats, group conversation threads and calendar events, and document library file information.

Group management


View groups and Teams
This job list all groups and Teams .From there, you can edit groups’ properties, and perform various other identity management actions.

Delete groups
Delete selected groups, including Teams, distribution groups, security groups and email-enabled security groups. Office 365 type groups (Teams) will be available to restore from the recycle bin. All other groups are deleted permanently.

Export content of selected groups
Select groups or Teams, and download their document library files and group conversation attachments to your local machine. Export Excel or XML reports on group members and owners, Team channels and chats, group conversation threads and calendar events, and document library file information.

View deleted groups
List groups deleted in the last 30 days. From there you can restore or delete them permanently.

View Archived Teams
List Teams that have been archived. You may restore them from this view.

Get memberships of a selected group
List the groups that your selected group (nested) is a member of.

Restore deleted groups
Restore a selection of groups or Teams deleted in the last 30 days and which can still be restored.

Remove all licenses from users with blocked sign-ins
List assigned licenses of users whose sign-in is blocked and choose to remove their licenses. If licenses are assigned via a group, users will be also removed from those groups.

Find ownerless/memberless groups
List groups without owners or without members or neither.

View groups created within a date range
List groups with a creation date that falls between the dates (inclusively) you specify.

Find groups about to expire
List Office 365 groups and Teams that are set to expire within a specific date range.

View ownerless groups
List groups without assigned owners. From there, you can add new owners or promote members to those groups to ensure a healthy collaborative environment.

Find memberless groups
List groups without any members. This includes Office 365 groups, Teams, distribution groups, security groups and email-enabled security groups.

Find ownerless AND memberless groups
“List groups that have no owners nor members. This includes Office 365 groups, Teams, distribution groups, security groups and email-enabled security groups.”

Groups/Teams with shared files (anonymous, guests, etc)
List Office 365 groups/Teams and their library files shared anonymously, directly with guests, or within the organization.

Find files by name or type for selected sites
Search selected SharePoint site document libraries for files that match a specified name and extension type.

Add non-member owners as members for selected groups or Teams
Ensure the current owners of the groups or Teams you select are also members to ensure access to all Microsoft services. If they are not already members, they are added to their relative groups.

View group sites
List SharePoint sites and subsites of every group. From this view, you can access site information like usage quotas, lists, document library files, etc.

View lists of all group sites
List SharePoint list information of all group sites and subsites. In this view, you can access list item information and list column information.

Add selected users as owners to groups
Add selected users as owners to all the groups in your tenant. Applicable groups types include: distribution groups, Office 365 groups or email-enabled security groups.

Find the last time groups were emailed
Search members’ mailboxes to find the last time selected groups were sent an email. Select groups from distribution groups, Teams, Office 365 groups or email-enabled security groups.

Groups with guest members
List groups/Teams with members who are guests (external).

View all Admin Audit Log entries
List all available event entries from the Admin Audit Log. You can find who initiated changes to users’ information, group and Teams memberships, and other areas of interest.

View calendar events of all groups
List every group’s calendar events and event information. In this view, you can also see attachment information and delete attachments.

View files of all groups
List documents and folders in a hierarchical view for every group and Team document library. From this view, you can upload files or delete them, and you can see file information like who last modified it, the creation date, if it was shared and how it was shared and with whom. You can also change or remove file permissions.

View all Office 365 groups
List all Office 365 groups, including Teams, with over 100 properties all in one place. In this view, you can edit groups’ properties and settings, and perform various other group management actions.

View all distribution lists
List all distribution groups in Azure Active Directory with over 100 properties all in one place. In this view, you can edit groups’ properties and settings, and perform various other group management actions.

View all email-enabled security groups
This job lists all email-enabled security groups with over 100 properties all in one place. In this view, you can edit groups’ properties and settings, and perform various other group management actions.

View all security groups
This job lists all security groups with over 100 properties all in one place. In this view, you can edit groups’ properties and settings, and perform various other group management actions.

View channels of all Teams
List channels and channel information of all Teams. In this view, access chats, private channel memberships, private channel sites and files.

View conversations of all Office 365 groups
List conversation posts and replies of every Office 365 group. From this view, you can delete posts, or download or delete attachments.

View members of all groups and Teams
List members of every group, including Teams, Office 365 groups, security groups, email-enabled security groups, and distribution groups. From this view, you can add or remove members and owners.

Show groups/Teams with guest owners
List groups/Teams that have owners who are guests.

Find Teams where members can add, edit or delete channels
List Teams with member settings enabled to add, edit or delete channels.

Update cache of Users and Groups
Update the local cache of the Users and Groups modules.

Groups with empty document library
List groups/Teams that have a document library with no documents.

Groups with no calendar events
List all groups/Teams without any calendar events.

View groups’ calendar events within a date range
List calendar events for selected groups that are set between dates you specify.

View group memberships of all users
List every users’ group membership. From this view, you can add or remove group memberships.

View group memberships of selected users
List selected users’ group membership. From this view, you can add or remove group memberships.

Clean up Teams with guest members
List Teams with guests and Teams where guests can be added, with options to change this group setting and to remove guests from those Teams.

Disable Giphy in Teams
Disable the setting that allows the use of Giphy in all existing Teams.

View all SharePoint sites & subsites by type (Teams, Yammer, private channels, etc)
Get a clearer view of your SharePoint site topology. See which sites belong to Teams, private channels, regular Office 365 groups or Yammer-linked groups.

Email owners of inactive Teams
This job finds Teams without any activity during a period and sends a notification email to each owner.

Find group/Teams files shared within the organization with link
List all groups/Teams and their document library files shared within the organization using a sharing link. From there, you can delete the link.

Find groups and Teams files shared with guests
Search group and Teams document libraries and list files shared with guests.

Find group and Teams files shared with many
Search all group and Teams document libraries and list files that have been shared with more than a specified number of people.

Get usage report of Office 365 groups activity
List Office 365 groups activity in the last 180 days.

Get usage report of Yammer activity
List Yammer activity in the last 180 days.

Get Yammer device usage report
List Yammer device usage in the last 180 days.

Get usage report on Yammer groups activity
List Yammer groups activity in the last 180 days.

View files of selected groups
List documents and folders in a hierarchical view for selected groups and Teams document library. From this view, you can upload files or delete them, and you can see file information like who last modified it, the creation date, if it was shared and how it was shared and with whom. You can also change or remove file permissions.

View calendar events of selected groups
List selected group’s calendar events and event information. In this view, you can also see attachment information and delete attachments.

View channels of selected Teams
List channels and channel information of selected Teams. In this view, access chats, private channel memberships, private channel sites and files.

View sites of selected Office 365 groups
List SharePoint sites and subsites of selected Office 365 groups. From this view, you can access site information like usage quotas, lists, document library files, etc.

View lists of selected Office 365 groups sites
List SharePoint list information of selected Office 365 groups sites and subsites. In this view, you can access list item information and list column information.

View conversations of selected Office 365 groups
List conversation posts and replies of selected Office 365 groups. From this view, you can delete posts, or download or delete attachments.

Find files by name or type for selected groups and Teams
Search selected group and Teams document libraries for files that match a specified name and extension type.

Teams management


View groups and Teams
This job list all groups and Teams .From there, you can edit groups’ properties, and perform various other identity management actions.

Delete groups
Delete selected groups, including Teams, distribution groups, security groups and email-enabled security groups. Office 365 type groups (Teams) will be available to restore from the recycle bin. All other groups are deleted permanently.

Export content of selected groups
Select groups or Teams, and download their document library files and group conversation attachments to your local machine. Export Excel or XML reports on group members and owners, Team channels and chats, group conversation threads and calendar events, and document library file information.

View deleted groups
List groups deleted in the last 30 days. From there you can restore or delete them permanently.

View Archived Teams
List Teams that have been archived. You may restore them from this view.

Find groups about to expire
List Office 365 groups and Teams that are set to expire within a specific date range.

View ownerless groups
List groups without assigned owners. From there, you can add new owners or promote members to those groups to ensure a healthy collaborative environment.

Find memberless groups
List groups without any members. This includes Office 365 groups, Teams, distribution groups, security groups and email-enabled security groups.

Find ownerless AND memberless groups
List groups that have no owners nor members. This includes Office 365 groups, Teams, distribution groups, security groups and email-enabled security groups.

Groups/Teams with shared files (anonymous, guests, etc)
List Office 365 groups/Teams and their library files shared anonymously, directly with guests, or within the organization.

Find files by name or type for selected sites
Search selected SharePoint site document libraries for files that match a specified name and extension type.

Add non-member owners as members for selected groups or Teams
Ensure the current owners of the groups or Teams you select are also members to ensure access to all Microsoft services. If they are not already members, they are added to their relative groups.

Add selected users as owners to groups
Add selected users as owners to all the groups in your tenant. Applicable groups types include: distribution groups, Office 365 groups or email-enabled security groups.

View owned Teams for selected users
Identify and list Teams owned for each user you select.

View Teams of selected users
List all the Teams each selected user belongs to.

Find the last time groups were emailed
Search members’ mailboxes to find the last time selected groups were sent an email. Select groups from distribution groups, Teams, Office 365 groups or email-enabled security groups.

View all Admin Audit Log entries
List all available event entries from the Admin Audit Log. You can find who initiated changes to users’ information, group and Teams memberships, and other areas of interest.

View files of all groups
List documents and folders in a hierarchical view for every group and Team document library. From this view, you can upload files or delete them, and you can see file information like who last modified it, the creation date, if it was shared and how it was shared and with whom. You can also change or remove file permissions.

View all Office 365 groups
List all Office 365 groups, including Teams, with over 100 properties all in one place. In this view, you can edit groups’ properties and settings, and perform various other group management actions.

View channel chats of all Teams
List chats of all Teams. Private channel chats are included if you are part of the channel or if you have received approval from Microsoft for sapio365 to request private channel chats.

View members of all groups and Teams
List members of every group, including Teams, Office 365 groups, security groups, email-enabled security groups, and distribution groups. From this view, you can add or remove members and owners.

Show groups/Teams with guest owners
List groups/Teams that have owners who are guests.

Update cache of Users and Groups
Update the local cache of the Users and Groups modules.

View groups’ calendar events within a date range
List calendar events for selected groups that are set between dates you specify.

View private channel sites
List SharePoint sites and site information of every private channel.

View group memberships of all users
List every users’ group membership. From this view, you can add or remove group memberships.

View group memberships of selected users
List selected users’ group membership. From this view, you can add or remove group memberships.

List recently created Teams channels
List the Teams channels that were created on and after a specific date and categorize them by their creation date and the Team they belong to.

List recently created Teams by department
List the Teams that were created since the date you specify and categorize them by the department of the user who created it.

Clean up Teams with guest members
List Teams with guests and Teams where guests can be added, with options to change this group setting and to remove guests from those Teams.

Disable Giphy in Teams
Disable the setting that allows the use of Giphy in all existing Teams.

View all SharePoint sites & subsites by type (Teams, Yammer, private channels, etc)
Get a clearer view of your SharePoint site topology. See which sites belong to Teams, private channels, regular Office 365 groups or Yammer-linked groups.

Find group/Teams files shared within the organization with link
List all groups/Teams and their document library files shared within the organization using a sharing link. From there, you can delete the link.

Find groups and Teams files shared with guests
Search group and Teams document libraries and list files shared with guests.

Find group and Teams files shared with many
Search all group and Teams document libraries and list files that have been shared with more than a specified number of people.

Get Teams device usage report
List Teams device usage in the last 180 days.

Get usage report of Teams user activity
List Teams user activity in the last 180 days.

Get usage report of Office 365 groups activity
List Office 365 groups activity in the last 180 days.

View files of selected groups
List documents and folders in a hierarchical view for selected groups and Teams document library. From this view, you can upload files or delete them, and you can see file information like who last modified it, the creation date, if it was shared and how it was shared and with whom. You can also change or remove file permissions.

View channel chats of selected Teams
List chats of selected Teams. Private channel chats are included if you are part of the channel or if you have received approval from Microsoft for sapio365 to request private channel chats.

Find files by name or type for selected groups and Teams
Search selected group and Teams document libraries for files that match a specified name and extension type.