- Description of the solution
- Howto install A.A.A.R.
- Use A.A.A.R.
- Advanced configurations
- Custom properties and types
- A.A.A.R. data mart
- Reports, dashboards and extractions
- F.A.Q. – Frequently asked questions
- Change log
- What can you do for the project?
”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.
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 now published in the official Pentaho Marketplace.
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
Hi Anthony,
Thank you for the feedback.
It depend for sure from the settings of the audit service ‘alfresco-access’.
I suggest you to try two different ways: alter the Alfresco Audit settings in the xml described here (http://wiki.alfresco.com/wiki/Auditing_(from_V3.4)#Audit_Configuration_and_Environment) or develop you own DataExtractor and DataGenerator.
If you’ll try the second way, let me know and I’ll tell you how to import the audits in the AAAR (it’ll be very easy to do).
If you have problems, write me a private email…
Hi Francesco!
Bravo.
Thank you very much. You made a very good job,
Thank you very much Mehmet.
This project looks great.
Do you know if it can log the IP address for successful/failed logins?
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.
Alright, if you put out a new release that tracks IPs let me know I’d be very interested.
Hey Francesco,
Just checking up to see if you have any plans for integrating IP addresses into A.A.A.R.
Thanks!
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.
Zweimal Portugal: Pentaho Partner Summit und Community Meeting in Sintra | Business Open Source Blog
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_LOWERCASE
NFORCE_IDENTIFIERS_TO_UPPERCASE
NIS_CLUSTERED
NPORT_NUMBER
5432PRESERVE_RESERVED_WORD_CASE
NQUOTE_ALL_FIELDS
NSUPPORTS_BOOLEAN_DATA_TYPE
YSUPPORTS_TIMESTAMP_DATA_TYPE
YUSE_POOLING
NKettleDatabaseRepository
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.
Hi,
Do you know if this works on alfresco 4.0.e? because all reports show always “no data”
Thanks in advance.
Hi Ricardo,
AAAR works on Alfresco 4.0.e.
Everything is empty because the AAAR_Extract has not been executed (or fails).
how to check AAAR_EXtract.exe is working or not,,always shows no records only
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
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.
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.
Yes, try to take a look here: http://wiki.alfresco.com/wiki/Web_Scripts
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.
Thank you Francesco. Will it be sufficient to use the community version with an enterprise implementation of Alfresco?
Yes!
They are two separated environments.
Ciao francesco,
In the video provided here (https://code.google.com/p/alfresco-audit-analysis-reporting/), I can see a drop-down menu in Alfresco, allowing direct access to AAAR.
Do you provide any AMP for Alfresco along with AAAR ?
Thanks
Julien
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
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
Yep, let’s make it work! 😉
Don’t worry about the duration… it depends on the amount of documents/folders.
I’ll write you privately.
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 daimone,
I’m checking and I’ll be back soon with some news. Thank you for the hint.
Thank you! However I get this error while running AAAR_Extract:
Request failed 500 /solr4/alfresco/cmis?wt=json&fl=DBID%2Cscore& ;rows=100&df=TEXT&start=0&locale=en_US&alternativeDic=DEFAULT_DI CTIONARY&cmisVersion=CMIS_1_0&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON &fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON
and here you can see also the alfresco log http://s000.tinyupload.com/index.php?file_id=56816256763973647999
and maybe also this can be helpful:
https://issues.alfresco.com/jira/browse/ALF-21134
I have the same problem with Alfresco Community 5.0.b
Still working on the migration of the whole system on CMIS 1.1… a little bit of patience and I’ll be back with an upgrade.
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
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)
Thank you Daimone.
Take a look here:
http://fcorti.com/2014/11/11/alfresco-5-0-b-bug-solr4-cmis-1-1/
It’s an Alfresco bug in the 5.0.b version, probably caused by Solr4.