topic statistical analysis alfresco and docs in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/statistical-analysis-alfresco-and-docs/m-p/191816#M144946 <HTML><HEAD></HEAD><BODY><SPAN>Hello everybody, this is my first post in this forum&nbsp; as&nbsp; a newbie of alfresco. Foremost excuse me if this post is misplaced</SPAN><BR /><BR /><SPAN>I post today, so you can help me in my development .</SPAN><BR /><SPAN>Well i had to developp a small statistical tools ( i thought of a php page)&nbsp; about the use of the GED:</SPAN><BR /><BR /><SPAN>- Number of doc everywhere</SPAN><BR /><SPAN>- Increase of the this number on a period</SPAN><BR /><SPAN>-Number of download group by documents/user</SPAN><BR /><SPAN>…</SPAN><BR /><BR /><SPAN>I 've been thinking to do some MySQL queries to have access to these parameter and then to mannipulate them by graphical PhP library&nbsp; ( jpGraph)</SPAN><BR /><BR /><SPAN>However as a new member of the alfresco world lol, i tried to study the different table and database on my server Mysql but its some "chinese talk" for me i don't see the parameters which i need. </SPAN><BR /><BR /><SPAN>I would need your help in my project, please.</SPAN><BR /><BR /><SPAN>Thanks</SPAN></BODY></HTML> Tue, 03 Mar 2009 13:35:31 GMT jpsegret 2009-03-03T13:35:31Z statistical analysis alfresco and docs https://connect.hyland.com/t5/alfresco-archive/statistical-analysis-alfresco-and-docs/m-p/191816#M144946 Hello everybody, this is my first post in this forum&nbsp; as&nbsp; a newbie of alfresco. Foremost excuse me if this post is misplacedI post today, so you can help me in my development .Well i had to developp a small statistical tools ( i thought of a php page)&nbsp; about the use of the GED:- Number of doc everyw Tue, 03 Mar 2009 13:35:31 GMT https://connect.hyland.com/t5/alfresco-archive/statistical-analysis-alfresco-and-docs/m-p/191816#M144946 jpsegret 2009-03-03T13:35:31Z Re: statistical analysis alfresco and docs https://connect.hyland.com/t5/alfresco-archive/statistical-analysis-alfresco-and-docs/m-p/191817#M144947 <HTML><HEAD></HEAD><BODY><SPAN>As a common piece of advice : don't try to query Alfresco DB entries.</SPAN><BR /><BR /><SPAN>I had quite the same functionnality to implement, and I decided to create a custom aspect (search alfresco wiki for "content modelling" or "custom aspects" ) that would store, for each space,</SPAN><BR /><SPAN>- the number of content items as its direct children</SPAN><BR /><SPAN>- the total amount of content items as its children (direct children and children of its subspaces and so on …)</SPAN><BR /><SPAN>- the number of subspaces as its direct children</SPAN><BR /><SPAN>- the total amount of subspaces</SPAN><BR /><SPAN>- the memory size</SPAN></BODY></HTML> Mon, 09 Mar 2009 14:50:38 GMT https://connect.hyland.com/t5/alfresco-archive/statistical-analysis-alfresco-and-docs/m-p/191817#M144947 jayjayecl 2009-03-09T14:50:38Z