topic Database Definition/Description in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/database-definition-description/m-p/236913#M190043 <HTML><HEAD></HEAD><BODY><SPAN>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. </SPAN><BR /><BR /><SPAN>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. </SPAN><BR /><BR /><SPAN>Any pointers would be appreciated.</SPAN></BODY></HTML> Tue, 29 Sep 2009 11:58:57 GMT beren 2009-09-29T11:58:57Z Database Definition/Description https://connect.hyland.com/t5/alfresco-archive/database-definition-description/m-p/236913#M190043 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 Tue, 29 Sep 2009 11:58:57 GMT https://connect.hyland.com/t5/alfresco-archive/database-definition-description/m-p/236913#M190043 beren 2009-09-29T11:58:57Z Re: Database Definition/Description https://connect.hyland.com/t5/alfresco-archive/database-definition-description/m-p/236914#M190044 <HTML><HEAD></HEAD><BODY><SPAN>Hi, </SPAN><BR /><SPAN>check out the Alfresoc forge for Enterprise reports and Alfresco Audit - maybe they were faster than you ?</SPAN><BR /><BR /><SPAN>Norgan</SPAN></BODY></HTML> Tue, 29 Sep 2009 13:55:23 GMT https://connect.hyland.com/t5/alfresco-archive/database-definition-description/m-p/236914#M190044 norgan 2009-09-29T13:55:23Z Re: Database Definition/Description https://connect.hyland.com/t5/alfresco-archive/database-definition-description/m-p/236915#M190045 <HTML><HEAD></HEAD><BODY><SPAN>Sweet! WIll do - thanks!</SPAN></BODY></HTML> Tue, 29 Sep 2009 17:41:51 GMT https://connect.hyland.com/t5/alfresco-archive/database-definition-description/m-p/236915#M190045 beren 2009-09-29T17:41:51Z Re: Database Definition/Description https://connect.hyland.com/t5/alfresco-archive/database-definition-description/m-p/236916#M190046 <HTML><HEAD></HEAD><BODY><SPAN>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. </SPAN><BR /><BR /><SPAN>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.</SPAN></BODY></HTML> Tue, 29 Sep 2009 17:54:23 GMT https://connect.hyland.com/t5/alfresco-archive/database-definition-description/m-p/236916#M190046 beren 2009-09-29T17:54:23Z Re: Database Definition/Description https://connect.hyland.com/t5/alfresco-archive/database-definition-description/m-p/236917#M190047 <HTML><HEAD></HEAD><BODY><SPAN>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: </SPAN><A href="http://wiki.alfresco.com/wiki/Audit#Sample_mysql_audit_queries_against_repo_version_1.4.x_and_on" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Audit#Sample_mysql_audit_queries_against_repo_version_1.4.x_and_on</A></BODY></HTML> Tue, 29 Sep 2009 21:25:30 GMT https://connect.hyland.com/t5/alfresco-archive/database-definition-description/m-p/236917#M190047 zaizi 2009-09-29T21:25:30Z