topic Alfresco all sites user report in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/alfresco-all-sites-user-report/m-p/45833#M18380 <HTML><HEAD></HEAD><BODY><P style="margin: 2.0pt 0in 2.0pt 0in;">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?</P></BODY></HTML> Thu, 04 Oct 2018 15:40:21 GMT raju_kurapati 2018-10-04T15:40:21Z Alfresco all sites user report https://connect.hyland.com/t5/alfresco-forum/alfresco-all-sites-user-report/m-p/45833#M18380 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? Thu, 04 Oct 2018 15:40:21 GMT https://connect.hyland.com/t5/alfresco-forum/alfresco-all-sites-user-report/m-p/45833#M18380 raju_kurapati 2018-10-04T15:40:21Z Re: Alfresco all sites user report https://connect.hyland.com/t5/alfresco-forum/alfresco-all-sites-user-report/m-p/45834#M18381 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P></P><P>Better to use JS API from JS Console, or directly REST API:</P><P></P><P><A class="link-titled" href="https://github.com/zylklab/alfresco-export-scripts#getsitemembershipssh" title="https://github.com/zylklab/alfresco-export-scripts#getsitemembershipssh" rel="nofollow noopener noreferrer">GitHub - zylklab/alfresco-export-scripts: Alfresco Export Shell Scripts</A>&nbsp;</P><P></P><P>HINT:&nbsp;getSiteMemberships.sh -f &nbsp;(you need curl and jq linux commands)</P><P></P><P>Regards.</P><P>--C.</P></BODY></HTML> Sat, 06 Oct 2018 19:04:30 GMT https://connect.hyland.com/t5/alfresco-forum/alfresco-all-sites-user-report/m-p/45834#M18381 cesarista 2018-10-06T19:04:30Z