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?