Schools and other organizations may adopt document storage policies that prohibit students from storing certain types of files on their OneDrive.

One way to query for banned content is with Azure Active Directory Cloud App Discovery in Microsoft 365. It can be found in the Cloud App Security portal. Note that this requires a Premium license

Another caveat using the portal is that you cannot combine filters as an ‘OR’ query, as shown in the image below. It is therefore impossible to search for files that match various types of music or video extensions for example.

usage-report-teams-sapio365

Scheduling a recurrent search in sapio365

sapio365 extends your access as the admin of your MS 365 content, and gives you the means to query that content, even while you sleep!

Find the ready-to-run automated job that will search users’ OneDrives for any documents matching a name or file type, and then run it. Or you can schedule it to run every week in the off hours if you don’t want to tie up your machine during the day. Note that the same job exists for both group/Teams and SharePoint site libraries. And if the extension type you need to search for is not in the list, you can add it to the query.

licenses-sapio365

Dealing with these prohibited files

Once the files are found, you can then notify the OneDrive owners, or delete the files directly in sapio365.

licenses-sapio365

sapio365 gives you a 360-degree view of all the content in your organization, whether it’s on OneDrive or in a site document library. And, since you also have the tools needed to add or remove files directly in sapio365, document management is a breeze! Try it for yourself today.

Free for 7 days

No credit card required

Keep me posted on more like this!

We’ll keep you up to date on new technical articles, tips and tricks, and upcoming events.

We don’t spam, and you can unsubscribe at any time.

  • This field is for validation purposes and should be left unchanged.

Share This