One of the nice things about the General Audit Tool is that you can build detailed and complex searches. These searches can then be saved for use as audits, policy checks, or simply to be used again to save time.
In the screenshots below, we will be building a search for all documents owned by members of the group ‘sales’, however, we want to exclude the member of the group called ‘Robert’.
To achieve this we can go to Drive audit, in the Files tab and just apply the custom filter.
We select the Type of the search to be for User / Group / OU Search, we select the name of the group and the files owned by them, then we exclude documents where the owner is ‘Robert’, then simply select ‘Apply & Save’.
This will save this search for future references and we can apply this search again and edit.
We can simply export the data into a spreadsheet.
We can also create and schedule a report that can be run on a weekly or daily basis.