Looking for a way to look up all external permission share
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?
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-permissions.html#L266