A.A.A.R. – Alfresco Audit Analysis and Reporting

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?

These are only some of the questions that are often done about an Alfresco E.C.M. and is well known that Alfresco only recently is starting to define a reporting system and today they are following exactly the same path you can see here, with a solution for Enterprise Edition only and a high cost.

AAAR responsive

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.A.A.R. Analytics 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.

Remembering that Alfresco is leader as an Open Source E.C.M. platform, the provided solution integrates the Pentaho Suite (http://www.pentaho.com) as the most important Open Source Business Intelligence platform. Thanking to the use of Pentaho Data Integration (http://community.pentaho.com) and Pentaho Report Designer (http://community.pentaho.com) the solution is a scalable and generic Reporting System with an open window on the Business Intelligence world. A.A.A.R. is published since 2014 in the official Pentaho Marketplace.

AAAR_MarketplaceInfo

Description of the solution >>

I like A.A.A.R.

52 thoughts on “A.A.A.R. – Alfresco Audit Analysis and Reporting”

  1. Anthony Duriez -

    Hi !
    You made a very good job, but when a content is moved by script, we can’t have any audit of it,

    Do you now why ?

    Anthony

    Reply
    • Francesco Corti
      Francesco Corti -

      Thank you for the feedback, Vince.

      To reply to your question: it depends from the Alfresco audit trail. By default it doesn’t track the IP address but in positive case, need to modify the import batch to store it in the data mart.

      Summarizing: today the IP address is not tracked but modifying the audit trail it could track and could be imported.

      Reply
  4. Francesco Corti
    Francesco Corti -

    Hi Vince,

    Thank you for your interest in AAAR.

    Due to a relevant improvement of the front-end I’m working on (AAAR will be presented tomorrow in the Pentaho Community Meeting and in november at the Alfresco Summit) I cannot plan to work on this task during the next weeks.

    If you think to help me, me and the community will appreciate very much and I think will be easy for me to develop the feature sooner.
    A huge help for me could be to answer to this question: how to store the IP address you need in the Alfresco audit trail?
    Having the answer to this question it’s clear for me what (and how) to do to extend the AAAR.

    If interested, please write privately and we will discuss on it (fcorti at gmail).

    Thank you in advance.

    Reply

  5. Pingback: Zweimal Portugal: Pentaho Partner Summit und Community Meeting in Sintra | Business Open Source Blog

  6. Vincent Giacomini -

    just – manually – insatlled CDA, CDE and AAAR…

    passed the configuration

    but AAAR_Extract.sh seems not working :
    error messages are :
    Unable to load task because no repository found
    Unable to continue because task can’t be loaded

    below the content of my repository : /root/.kettle/repositories.xml

    AAAR database
    localhost
    POSTGRESQL
    Native
    aaardb
    5432
    aaar
    Encrypted 2be98afc86aa7f2e4cb79ce10bec1aec8

    FORCE_IDENTIFIERS_TO_LOWERCASEN
    FORCE_IDENTIFIERS_TO_UPPERCASEN
    IS_CLUSTEREDN
    PORT_NUMBER5432
    PRESERVE_RESERVED_WORD_CASEN
    QUOTE_ALL_FIELDSN
    SUPPORTS_BOOLEAN_DATA_TYPEY
    SUPPORTS_TIMESTAMP_DATA_TYPEY
    USE_POOLINGN

    KettleDatabaseRepository
    aaar
    pentaho on behalf aaar
    AAAR database

    Any idea ?

    Reply
    • Francesco Corti
      Francesco Corti -

      Hi Vincent,

      I see that you installed Pentaho as root.
      Other users in the past days told me about problems with the root user.
      I suggest you to use a different user because is preferable for security reasons.

      Let us know how it goes.

      Reply
  7. Ricardo -

    Hi,
    Do you know if this works on alfresco 4.0.e? because all reports show always “no data”

    Thanks in advance.

    Reply
  8. Francesco Corti
    Francesco Corti -

    Hi Saran, always check the (great) catalina.out log file of the Pentaho installation. In this file you always find all the detailed informations about execution and possible problems.

    Reply
    • Saran -

      Hi Corti,

      Dash boards and free analyses are your future release ? when it will be realized ? any license required for that?

      Thanks,
      Saran

      Reply
  9. Francesco Corti
    Francesco Corti -

    Hi Saran,
    Thank you for the interest in AAAR.
    They will be released in the future but I cannot say the date now.
    I don’t plan licenses for that but for any kind of support, write me privately.
    Thanks, Saran.

    Reply
  10. Sulyman Korj -

    Dear Francesco,

    I am Sulyman I am new in Alfresco But I like it, I need your help, I need to export metadata of content to csv file from table view on Document Library.
    I have some custom metadata I can view it on table view but how I can export it to csv file.

    Regards,

    Reply
  12. Zeal4living2 -

    Is AAAR dependent on Pentaho or does it run independently and just using Pentaho components? We are using Alfresco but do not want to deploy Pentaho.

    Reply
    • Francesco Corti
      Francesco Corti -

      Bonjour Julien,

      I have it in my todo list but I don’t have it yet.
      I would appreciate if you could work on it (together with me of course).
      If you can’t do it now, I can give you support to develop it by yourself (it’s quite easy to do).

      Greetings,

      -F

      Reply
  15. jservajean -

    Sure I can help, as soon as I get AAAR working! 😉
    For now extraction is running (long long run…) but still 0 documents in the analytics…
    Seriously, you could give me the script and I can work on a dedicated project code that will come along with the A.A.A.R component.
    The only thing to consider is that I work on analytics only 2 days a week at a customer’s place, and among other tasks, so I can’t ensure any schedule/deadline…
    Julien

    Reply
  16. daimone -

    Hi Francesco,
    Thank you for your great job! Do you have any plan to bring AAAR to Alfresco 5.0b? I’m experiencing some problem with it and I think it is because they moved some url…

    Reply
      • Francesco Corti
        Francesco Corti -

        Hi all,
        I have a good news and a bad news!
        The good news is that I’m developing an upgrade of the AAAR to the last CMIS 1.1 with Apache Chemistry v0.12.
        The bad news is that the error 500 is clearly related to the stability CMIS query on Alfresco Community 5.0.b. (changing the query it works).
        I’ll write a post on that issue as soon as possibile.
        PS: On Alfresco 5.0.a the same CMIS query with CMIS 1.1 works perfectly.
        The exception in catalina.out is: ERROR [solr.core.SolrCore] [http-bio-8543-exec-11] org.alfresco.service.namespace.NamespaceException: Namespace prefix content@s__size@{http is not mapped to a namespace URI

        Reply
  18. daimone -

    Great, great work Francesco! Thank you a lot.
    I will look forward for the new version and for the post about the exception (I’m not sure I understood what you mean)

    Reply
  19. Ricardo Mendes -

    Hi,

    When I tried to perform Data extraction, I got:

    2015/03/17 17:32:06 – RepositoriesMeta – Reading repositories XML file: /root/.kettle/repositories.xml
    Processing stopped because of an error:
    Error connecting to the repository!

    Error occurred while trying to connect to the database

    Invalid JNDI connection AAAR_Kettle : FATAL: password authentication failed for user “postgres”

    ERROR: Kitchen can’t continue because the job couldn’t be loaded.
    Extraction complete!

    It consults the file /opt/data-integration/simple-jndi/jdbc.properties,
    and the password is right.

    Reply
  20. Francesco Corti
    Francesco Corti -

    Hi Ricardo,

    The authentication login and password are stored in different places during the installation task.
    It could happen if you install AAAR with some settings and later you change them, making the whole settings unrelated.
    I suggest you to use the configuration dashboard to set up the correct login and password and then re-install AAAR. You can re-install it using the same dashboard.
    https://youtu.be/MjGfenlzKfo?list=UUY9DkuEGxxI9K4M7anL8rgg

    If you cannot erase the data mart, write me privately and I’ll drive you through all the settings to develop it one by one.

    I hope this will help you.

    Reply
  21. Sandeep Reddy -

    Hi Francesco,
    I am very glad to have such an amazing report generating technology.Using it we generated the reports for not logged in users into alfresco.I am working as a Middleware Engineer at Taashee Linux Services, India.I appreciate your work that you have contributed to the community.
    Thank you Francesco Corti.

    Sandeep Vemuganti,
    (sandeep@taashee.com)
    Taashee Linux Services,
    Hyderabad,Telangana State,
    INDIA.

    Reply
  22. Pablo Vásquez -

    Hi Francesco,

    The AAAR tool has been of great help in generating reports and dashboards based on workflows and digital asset management. Thank you for your contribution to the community.

    Greetings,
    Pablo Vásquez,
    Smart Solutions & Services (S3Chile),
    Software Engineering,
    Santiago, Chile,
    pbvasquez@s3chile.cl

    Reply
  23. Julio Coto -

    Hello Francesco,

    Good job and thanks for your contribution in this application/module. We are testing the A.A.A.R. for managing the audit in the Alfresco side. We hope to generate others reports to know more about the application and its components.

    Happy new year.
    Julio Coto (julio.coto@alkaid.cr)
    ECM & Software Engineer
    Alkaid – Software Company

    Reply
  24. Victor Muchica -

    Hi Francesco

    AAAR is a wonderful tool, we use it to audit Alfresco, in order to have some metrics about users, files,etc. It is really helpful
    Also your howtos are well explained, It guides you very well to have a working AAAR.
    If you have some trouble with AAAR do not hesitate to contact Francesco, He really helps you.

    Best Regards
    Victor Muchica
    Job title: CTO
    Country: Peru

    Reply
  25. Rosi -

    The link “https://sourceforge.net/projects/aaar/files/latest/download” not work.
    Help me, please.

    Reply
    • Francesco Corti
      Francesco Corti -

      The link works for me.
      Few days ago there were some problems between the Pentaho Marketplace and Sourceforge but on Sunday the issue has been solved.
      Please try again.

      Reply
  26. Ethan -

    Hi Francesco,

    We are a newbie in Alfresco, currently still using Community Edition 5.2 and our many site users are heavy on storing contents. We are looking for an appropriate activity reporting tool to understand the extend of growth and usage of what had been stored.

    Can you please recommend what or where we can look at to quickly be able to look at the user’s activities?

    Appreciate your response.

    Kind regards

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.