topic Re: Database Definition/Description in Alfresco Archive

Database Definition/Description

beren — Tue, 29 Sep 2009 11:58:57 GMT

I looked through the wiki and searched in these forums, but could not find any documentation that describes the structure of the database and the definitions of the columns/relationships. What's the best document to look at to better understand the database structure that Alfresco uses behind the sc

Re: Database Definition/Description

norgan — Tue, 29 Sep 2009 13:55:23 GMT

Hi,
check out the Alfresoc forge for Enterprise reports and Alfresco Audit - maybe they were faster than you ?

Norgan

Re: Database Definition/Description

beren — Tue, 29 Sep 2009 17:41:51 GMT

Sweet! WIll do - thanks!

Re: Database Definition/Description

beren — Tue, 29 Sep 2009 17:54:23 GMT

Well I did look at this and it looks definitely interesting, but not exactly what I was looking for. I want to build reports on the usage of my alfresco system itself, but I can't seem to find any details on the database and the entities in it.

This tool is an integration between a reporting platform (birt or jasper) that would allow a user to kick off report jobs from within alfresco - that is very cool - but it is also not what I was looking for.

Re: Database Definition/Description

zaizi — Tue, 29 Sep 2009 21:25:30 GMT

Take a look at the Alfresco Audit Service. You can specify which services you need Alfresco to audit and track. Next you can query the audit data to generate your reports. Here are some sample audit queries: http://wiki.alfresco.com/wiki/Audit#Sample_mysql_audit_queries_against_repo_version_1.4.x_and_on