Folder permissions audit - report generator

We wanted to audit all our users access to different permissions in our vault.  It's hard just going through the groups / users in PDM admin tool. 

I couldn't find a good solution on line so came up with one, wrote a report generator query. It dumps all user and group permissions to all assigned folders in a big list.  Pretty easy to look at in a pivot table. 

Might be of use to some of yall so sharing; see attached.  Good luck!

I'll also attach a couple Solidworks' Report Generator queries that my VAR kindly provided.  It was a good start as to what I needed.

SolidworksSolidworks Pdm/enterprise Pdm