topic Method behind the madness in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/method-behind-the-madness/m-p/310515#M263645 <HTML><HEAD></HEAD><BODY><SPAN>Hey fcorti,</SPAN><BR /><BR /><SPAN>I'm going through each report that comes with the AAAR install and there are a couple of questions I have on the query results defined by the scripts that are running.</SPAN><BR /><BR /><SPAN>In particular:</SPAN><BR /><BR /><SPAN>audit_details.prpt</SPAN><BR /><SPAN>audit_creation.prpt</SPAN><BR /><SPAN>folder_types.prpt</SPAN><BR /><BR /><BR /><SPAN>The results come back with data that has 'unknown' or 'surf-config'. My question is what are these results suppose to tabulate? To me they don't represent anything as far as actual audits of documents. Which could make the reporting inaccurate. Thoughts?</SPAN><BR /><BR /><SPAN>Also, In the login report I've tested on a fresh install of Alfresco and had only logged in once with the main admin account and when I ran the report I got a result of about 83 logins from the admin account. My assumption is that it is counting server side processes that alfresco does with the database using the admin account. (Is that right?)</SPAN><BR /><BR /><SPAN>I wonder if there is a way to get an actual login count from that user. If not I would just have to exclude that account from audits altogether.</SPAN></BODY></HTML> Thu, 30 Oct 2014 18:52:09 GMT eswbitto 2014-10-30T18:52:09Z Method behind the madness https://connect.hyland.com/t5/alfresco-archive/method-behind-the-madness/m-p/310515#M263645 Hey fcorti,I'm going through each report that comes with the AAAR install and there are a couple of questions I have on the query results defined by the scripts that are running.In particular:audit_details.prptaudit_creation.prptfolder_types.prptThe results come back with data that has 'unknown' or Thu, 30 Oct 2014 18:52:09 GMT https://connect.hyland.com/t5/alfresco-archive/method-behind-the-madness/m-p/310515#M263645 eswbitto 2014-10-30T18:52:09Z Re: Method behind the madness https://connect.hyland.com/t5/alfresco-archive/method-behind-the-madness/m-p/310516#M263646 <HTML><HEAD></HEAD><BODY><SPAN>Hi ESWBitto,</SPAN><BR /><BR /><SPAN>The 'unknown' and 'surf-config' are probably related with the accessed documents.</SPAN><BR /><SPAN>The 'unknown' value is a "dummy value" that is used when the action is not referred to any document: for example a login (failed or not).</SPAN><BR /><SPAN>In this way you can choose to include or exclude those kind of actions from your analytics. <span class="lia-unicode-emoji" title=":winking_face:">😉</span></SPAN><BR /><BR /><SPAN>For the 'surf-config'… probably some kind of accesses to a wrong url?</SPAN><BR /><BR /><SPAN>About the 83 logins from the admin account: congratulations, you are one of the firsts that observe this behavior. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN><BR /><SPAN>Those are the accesses during the extraction process (AAAR_Extract) because you (correctly) use the admin account.</SPAN><BR /><SPAN>My suggestion is to define a "analytic" user in alfresco (with administrator privileges) and use this in the AAAR extractions.</SPAN><BR /><SPAN>Using this user you could choose to ignore the accesses, developing a filter in the reports queries.</SPAN><BR /><BR /><SPAN>Good job ESWBitto: your questions indicates you are really using AAAR in the right way, focusing the work on the data quality.</SPAN><BR /><SPAN>I have some ideas about the check of the "data quality"… but I don't know when they will be ready. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></BODY></HTML> Sun, 02 Nov 2014 15:29:42 GMT https://connect.hyland.com/t5/alfresco-archive/method-behind-the-madness/m-p/310516#M263646 fcorti 2014-11-02T15:29:42Z