Get account data xquery
For exporting usergroup information during an eXist-db this xquery fetches all user groups and meta-information for each user.
To run the xquery below on the server:
- Open a webbrowser, surf to: http://<server>:8877
- Click on ‘dashboard’.
- Log in as ‘admin’.
- Open eXide.
- Click: ‘New XQuery’ (paste the xquery in the box below to the browserscreen)
- Click: ‘eval’ to run the xquery.
xquery version "1.0";
declare namespace cfg = "http://exist-db.org/Configuration";
<x>
<users>
{
for $username in sm:list-users()[not(.=('SYSTEM','admin','guest','xis-webservice'))]
return (
<cfg:primary-group user="{$username}" primarygroup="{sm:get-user-primary-group($username)}"/>,
doc(concat('/db/system/security/exist/accounts/',$username,'.xml'))/cfg:account
)
}
</users>
<groups>
{
for $groupname in sm:list-groups()[not(.=('dba','decor','decor-admin','terminology','issues','editor','tools','debug'))]
return
doc(concat('/db/system/security/exist/groups/',$groupname,'.xml'))/cfg:group
}
</groups>
</x>