Reporting on Data Protection insights

We just moved to Google Workspace and we can see the data protection insights for drive. But what's the use if you can't actually look at the data or use any sort of reporting on the data? For instance, we have 20,000 hits on data type X but we can't click on anything that will actually show us who owns the file, where it lives, etc. It would be nice to be able to export that data type information into a sheet and be able to sort it and see that Timmy has 8000 files with a Social Security number on them, which files they are and where they are stored, who they are shared to. It just doesn't make any sense that Google wouldn't think that kind of reporting would be useful. I was told that we can possibly use GAM to get that report but does anyone know what command to run?

1 2 175
2 REPLIES 2

Hey @w00dr0w this reporting is available via API, for GAM-specifc discussions you might find the Google Group helpful

Additionally, there are Google Partners that might be able to help with this scenario, for example 

(note: not an official recommendation) @brian_kim works with a partner that has developed a similar solution

What's most important would be to set up Data Protection rules, which you can use with Drive Labels to classify the data. At which point,  you can use GAM to create CSVs and/or query the tables in BigQuery (if you have it set up) to find files that have specific Drive labels, create CSVs of all  the files and permissions, etc.