topic How to Get Data regarding site audit from Alfresco DB in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/how-to-get-data-regarding-site-audit-from-alfresco-db/m-p/134073#M36094 <DIV class=""><DIV class=""><DIV class=""><DIV class=""><DIV class="">Step by step approach to running sql queries on Alfresco DB</DIV></DIV></DIV></DIV></DIV><P><A class="" href="https://hub.alfresco.com/t5/alfresco-content-services-forum/step-by-step-approach-to-running-sql-queries-on-alfresco-db/m-p/249132#M13900" target="_blank" rel="noopener nofollow noreferrer">Jump to solution</A></P><DIV class=""><DIV class=""><P>Good day All,</P><P>Please i am trying to find out-:</P><UL class=""><LI>Number of people who accessed the site</LI><LI>Number of people who uploaded // downloaded files</LI><LI>size of the total current data volume for the site</LI><LI>count of files in the site</LI></UL><P>on Alfresco at any given time besides generating other reports, can someone give me these sql queries on Alfresco Db?</P><P>Look forward to your kind response</P></DIV></DIV> Tue, 14 Nov 2023 11:56:02 GMT shriyam_gupta 2023-11-14T11:56:02Z How to Get Data regarding site audit from Alfresco DB https://connect.hyland.com/t5/alfresco-forum/how-to-get-data-regarding-site-audit-from-alfresco-db/m-p/134073#M36094 <DIV class=""><DIV class=""><DIV class=""><DIV class=""><DIV class="">Step by step approach to running sql queries on Alfresco DB</DIV></DIV></DIV></DIV></DIV><P><A class="" href="https://hub.alfresco.com/t5/alfresco-content-services-forum/step-by-step-approach-to-running-sql-queries-on-alfresco-db/m-p/249132#M13900" target="_blank" rel="noopener nofollow noreferrer">Jump to solution</A></P><DIV class=""><DIV class=""><P>Good day All,</P><P>Please i am trying to find out-:</P><UL class=""><LI>Number of people who accessed the site</LI><LI>Number of people who uploaded // downloaded files</LI><LI>size of the total current data volume for the site</LI><LI>count of files in the site</LI></UL><P>on Alfresco at any given time besides generating other reports, can someone give me these sql queries on Alfresco Db?</P><P>Look forward to your kind response</P></DIV></DIV> Tue, 14 Nov 2023 11:56:02 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-get-data-regarding-site-audit-from-alfresco-db/m-p/134073#M36094 shriyam_gupta 2023-11-14T11:56:02Z