This is regarding Alfresco application user report. We have requirement to pull the user report who are part of at least one site. Report using SQL query or REST API is fine?
Better to use JS API from JS Console, or directly REST API:
GitHub - zylklab/alfresco-export-scripts: Alfresco Export Shell Scripts
HINT: getSiteMemberships.sh -f (you need curl and jq linux commands)
Retrieving data ...