We have a request from our IT Compliance team to report on SharePoint Online use and look for noncompliance. Our original strategy for site management was not the best and there hasn't been any strong governance or control enacted, so we have some runaway site collections with hundreds of subsites.
My thought is we need to export a list of documents and list items then look for keywords that would imply the document should be in a controlled storage repository and not SharePoint, but I am curious if there's recommendations on how we can do the export. The PnP PowerShell cmdlets are an option but it will require resource time to develop and test this before we can rely on it, then of course the effort to analyze the data is another significant task.
I am looking for any recommendations on how we can either export this information to process, or if there's other utilities out there that can help achieve this task.
PS: I do feel a little bit like John Wick being given an impossible task - but that discussion would be best had at happy hour.