topic Alfresco Audit Analysis and Reporting (A.A.A.R.) in Alfresco Forum

topic Alfresco Audit Analysis and Reporting (A.A.A.R.) in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/alfresco-audit-analysis-and-reporting-a-a-a-r/m-p/3060#M978 <HTML><HEAD></HEAD><BODY>NEWS: Starting from the v1.3 you can analyze the whole repository together with the audit data. <CITE>Who is using the Alfresco E.C.M.? How the repository is growing up in the passing time? Which are the most viewed contents in the Alfresco E.C.M. last week? Who are the most active users in the Alfresco E.C.M. in the last quarter? Which is the created content during last week? And during last month? Which is the most accessed content of the last month? How many failed login?</CITE> These are only some of the questions that are often done about an Alfresco E.C.M. and is well known that Alfresco has not a powered reporting system (and honestly is not it's job). Unfortunately the need is still there and most of the answers are tricky solutions, quite hard to manage and scale. By the way Alfresco E.C.M. has a detailed audit service (<A class="jive-link-external-small" href="https://wiki.alfresco.com/wiki/Content_Auditing" rel="nofollow noopener noreferrer" target="_blank">https://wiki.alfresco.com/wiki/Content_Auditing</A>) that exposes a lot of (potentially) useful informations. <IMG src="http://francescocorti.files.wordpress.com/2013/10/logo-aaar.png?w=500" /> With Alfresco Audit Analysis and Reporting (A.A.A.R.) is provided a solution to extract, store and query audit data together with the document/folder informations at a very detailed level, with the goal to be useful to the end-user in a very easy way. To reach that goal, to make the data more friendly for the end-user, the data are published in reports in well-known formats (pdf, Microsoft Excel, csv, etc.) and stored directly in Alfresco as static documents organized in folders, versioned, authorized and published. On the top of the A.A.A.R. solution, the <A href="http://fcorti.com/aaar-analytics/" rel="nofollow noopener noreferrer">A.A.A.R. Analytics</A> is a set of powerful tools to analyze data in an interactive and customizable way with a user console composed by dashboards, reports and free analysis. The A.A.A.R. Analytics is distribuited separately from the A.A.A.R. solution downloadable here. Remembering that Alfresco is leader as an Open Source E.C.M. platform, the provided solution integrates the Pentaho Suite (<A href="http://www.pentaho.com" rel="nofollow noopener noreferrer">http://www.pentaho.com</A>) as the most important Open Source Business Intelligence platform. Thanking to the use of Pentaho Data Integration (<A href="http://kettle.pentaho.com" rel="nofollow noopener noreferrer">http://kettle.pentaho.com</A>) and Pentaho Report Designer (<A href="http://reporting.pentaho.com" rel="nofollow noopener noreferrer">http://reporting.pentaho.com</A>) the solution is a scalable and generic Reporting System with an open window on the Business Intelligence world. Saying that, the solutions is suitable also for publishing (static) reports containing not only audit data coming from Alfresco but also KPI, analysis and dashboards coming from a complete Enterprise Data Warehouse. <IMG src="http://francescocorti.files.wordpress.com/2013/01/img.png?w=500" /> <A href="http://fcorti.com/about/" rel="author nofollow noopener noreferrer">Francesco Corti</A><TABLE class="j-table jiveBorder" style="border: 1px solid #c6c6c6;" width="100%"><THEAD><TR style="background-color: #efefef;"><TH style="width: 19.5066%;"></TH><TH style="width: 78.7972%;"></TH></TR></THEAD><TBODY><TR><TD style="width: 19.5066%;">Owner</TD><TD style="width: 78.7972%;">Francesco Corti‌</TD></TR><TR><TD style="width: 19.5066%;">Versions</TD><TD style="width: 78.7972%;">Community 4.0.xCommunity 4.2.xCommunity 5.0.xCommunity 5.1.xEnterprise 4.0.xEnterprise 4.1.xEnterprise 4.2.xEnterprise 5.0.xEnterprise 5.1.x</TD></TR><TR><TD style="width: 19.5066%;">License Type</TD><TD style="width: 78.7972%;">GNU General Public License (GPL)</TD></TR><TR><TD style="width: 19.5066%;">Project Page</TD><TD style="width: 78.7972%;"><A class="link-titled" href="http://fcorti.com/alfresco-audit-analysis-reporting/" title="http://fcorti.com/alfresco-audit-analysis-reporting/" rel="nofollow noopener noreferrer">A.A.A.R. - Alfresco Audit Analysis and Reporting - F. Corti</A> </TD></TR><TR><TD style="width: 19.5066%;">Download Page</TD><TD style="width: 78.7972%;"><A class="link-titled" href="https://sourceforge.net/projects/aaar/files" title="https://sourceforge.net/projects/aaar/files" rel="nofollow noopener noreferrer">Alfresco Audit Analysis and Reporting - Browse Files at SourceForge.net</A> </TD></TR><TR><TD style="width: 19.5066%;">Tags</TD><TD style="width: 78.7972%;">alfresco, pentaho, pdi, prd, etl, business intelligence, report, audit, statistics, cloud, CMIS, reporting, Dashboard, analytics, interactive, dynamic, free analysis, olap, saiku, kettle, pentaho data integration,KPI,Integration</TD></TR><TR><TD style="width: 19.5066%;">Component Type</TD><TD style="width: 78.7972%;">External Utility, Integration</TD></TR><TR><TD style="width: 19.5066%;">Extension Points</TD><TD style="width: 78.7972%;">Public API, Scheduled Job</TD></TR><TR><TD style="width: 19.5066%;">Installation</TD><TD style="width: 78.7972%;">Script</TD></TR><TR><TD style="width: 19.5066%;">Products</TD><TD style="width: 78.7972%;">Repository </TD></TR></TBODY></TABLE></BODY></HTML> Fri, 15 Jun 2018 14:57:11 GMT alfresco 2018-06-15T14:57:11Z Alfresco Audit Analysis and Reporting (A.A.A.R.) https://connect.hyland.com/t5/alfresco-forum/alfresco-audit-analysis-and-reporting-a-a-a-r/m-p/3060#M978 NEWS: Starting from the v1.3 you can analyze the whole repository together with the audit data. Who is using the Alfresco E.C.M.? How the repository is growing up in the passing time? Which are the most viewed contents in the Alfresco E.C.M. last week? Who are the most active users in the Alfresco E Fri, 15 Jun 2018 14:57:11 GMT https://connect.hyland.com/t5/alfresco-forum/alfresco-audit-analysis-and-reporting-a-a-a-r/m-p/3060#M978 alfresco 2018-06-15T14:57:11Z