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.
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.
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.
Pingback: 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:
https://www.youtube.com/watch?v=gF2NXUvyaSA
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?
Hi Francesco,
You made good job, Great Francesco.
AAAR Reports Very much useful for generating reports.
I did it from following link (http://fcorti.com/alfresco-audit-analysis-reporting/). Thank you so much Francesco
Regards,
Sandeep Reddy,
TLS,India.
Thank you Sandeep.
Feel free to suggest improvements or new features.
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.
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.
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.
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.
Thank you Sandeep.
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
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
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
The link “https://sourceforge.net/projects/aaar/files/latest/download” not work.
Help me, please.
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.
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
Hi Ethan,
Welcome into the Alfresco World!
In your message you are talking about two different business elements: content and activities.
Both can be faced with Alflytics (the rebranded version of AAAR).
In the following link you can find all the bundle reports available: http://fcorti.com/alfresco-audit-analysis-reporting/aaar-reports-dashboards-extractions/
Here you can see the business elements available: http://fcorti.com/alfresco-audit-analysis-reporting/aaar-data-marts/
You can find further details at: https://github.com/fcorti/Alflytics/blob/master/documentation/Alflytics-Manual.pdf
Cheers.