Looking for a way to look up all external permission share

[Eric_Atencio]

Is there a way to look up all external shares? I've tried NXQL in the admin tab but I get mixed results. The documentation I read seemed to indicate that ACLs are a special NXQL property and that most fields are not searchable. This is about as close as I can get so far: SELECT * FROM Document WHERE ecm:mixinType != 'HiddenInNavigation' AND ecm:isProxy = 0 AND ecm:isVersion = 0 AND ecm:isTrashed = 0 AND ecm:acl/*/principal like "transient%"

It would be nice to get the username, externalUser, and status. Is there another way to monitor without using NXQL?

[Gregory_Carlin]

Hi Eric,

I would build a custom automation scripting for it, with a custom UI. I don't see OOTB solution. You can look at the default elements we use: https://github.com/nuxeo/nuxeo-ui-elements/blob/2.3.3/nuxeo-document-permissions/nuxeo-document-perm...

Regards