Database Definition/Description

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-29-2009 07:58 AM
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 scenes.
What I was trying to do is build up some simple reports using Jasper(a dashboard I suppose) that could show me some statistics on how people are using alfresco. A lot of the relationships are fairly simple, but then I saw some other things and wondered what their purpose was, for example the alf_audit_*** tables.
Any pointers would be appreciated.
What I was trying to do is build up some simple reports using Jasper(a dashboard I suppose) that could show me some statistics on how people are using alfresco. A lot of the relationships are fairly simple, but then I saw some other things and wondered what their purpose was, for example the alf_audit_*** tables.
Any pointers would be appreciated.
Labels:
- Labels:
-
Archive
4 REPLIES 4
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-29-2009 09:55 AM
Hi,
check out the Alfresoc forge for Enterprise reports and Alfresco Audit - maybe they were faster than you ?
Norgan
check out the Alfresoc forge for Enterprise reports and Alfresco Audit - maybe they were faster than you ?
Norgan

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-29-2009 01:41 PM
Sweet! WIll do - thanks!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-29-2009 01:54 PM
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.
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-29-2009 05:25 PM
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
