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

alfresco speakingpentaho speaking PCM13

”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 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 that exposes a lot of (potentially) useful informations.

AAAR

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.

AAAR Analytics - Details on audit actions

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 now published in the official Pentaho Marketplace.

AAAR_MarketplaceInfo

Description of the solution >>

I like A.A.A.R.

Francesco Corti

Advertisements

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

  1. 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

    • 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.

  2. 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.

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

  4. 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 ?

    • 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.

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

    Thanks in advance.

  6. 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.

    • Hi Corti,

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

      Thanks,
      Saran

  7. 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.

  8. 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,

    • Hi Sulyman,
      Alfresco is not able to export what you want with a bundled feature.
      I suggest you to take a look to the webscripts (Java developer approach) or the CMIS Input plugin (Pentaho developer approach) here:

      I hope this helps you,

      • Dear Francesco,
        Thank you for your reply I can develop by JavaScript but are you have any idea or from where I can start.

  9. 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.

    • Hi,
      AAAR runs on a Pentaho server so it depends on it.
      You can install Pentaho on a separate server respect to Alfresco, with AAAR on board.
      I hope this help you.

    • 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

  10. 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

  11. 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…

      • 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

  12. 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)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s