topic Re: Audit trail in Alfresco Archive

Audit trail

yusuf — Wed, 25 Jun 2008 10:44:53 GMT

Hi all,Is it possible to see who has accessed a document, not for editing but just for reading.And if so how is it done?Thanksin advance,Yusuf

Re: Audit trail

skorde — Mon, 28 Jul 2008 10:52:05 GMT

do changes in auditConfig.xml

<Service name="ContentService" mode="none">
        <Method name="getWriter" mode="all"/>
      <Method name="getReader" mode="all" auditInternal="true"/>
        <Method name="transform" mode="all"/>
    </Service>

Re: Audit trail

sumitweirminera — Fri, 01 Aug 2008 11:00:44 GMT

Hi,

I have added the code mentioned in the post, please advice on how to veiw the audit infomration.

Thank you

Re: Audit trail

sumitweirminera — Tue, 05 Aug 2008 10:38:14 GMT

Can somebody send me the screen shot of audit report, please????

Re: Audit trail

rbergstrom — Tue, 19 Aug 2008 18:07:13 GMT

Can somebody send me the screen shot of audit report, please????

I can't send you a screenshot, however if you change the custom view of a space to show_audit.ftl, you can see the audit information for that space. Using the template as a guide, you could do something more sophisticated.

// RAB

Re: Audit trail

skorde — Mon, 15 Sep 2008 13:00:06 GMT

Why don't u try this one

<#– Shows some general audit info about the current document –>
 <#if document?exists>
   <h4>Current Docuement Audit Info</h4>
   <b>Name:</b> ${document.name}
   <br>
   <br>
   <table border="1" width='100%' cellspacing="1" cellpadding="4">
   <tr align="left" class="rowheader">
          <th>Date</th>
        <th>User</th>          
       <th>User Address</th>
      <th>Action</th>
          
                    
   </tr>

<#list document.auditTrail as t>
<#if t.auditMethod?exists>
<#if t.auditMethod == "createNode" || t.auditMethod == "create" ||  t.auditMethod == "getWriter" || t.auditMethod == "checkout" || t.auditMethod == "unlock" || t.auditMethod == "lock" || t.auditMethod == "copy"  || t.auditMethod == "checkin" || t.auditMethod == "move" || t.auditMethod=="getReader">

<tr>
          <td>${t.date}</td>
          <td>${t.userIdentifier}</td>
          <td>${t.hostAddress}</td>
          <#– Shows some USER FRINDLY info based on method  –>
       <#if t.auditMethod?exists>
           <#if t.auditMethod == "create">
             <td>Created</td>
           </#if>
          <#if t.auditMethod == "createNode" && t.methodArgumentsAsStrings[1] == "{http://www.alfresco.org/model/content/1.0}contains">
             <td>Create</td>
         </#if>
     
      <#if t.auditMethod == "getWriter">
             <td>Edit</td>
         </#if>
      <#if t.auditMethod == "getReader">
             <td>Read</td>
         </#if>
      <#if t.auditMethod == "checkout" || t.auditMethod == "unlock">
             <td>Check-Out</td>
         </#if>
      <#if t.auditMethod == "copy">
             <td>Copy</td>
         </#if>
      <#if t.auditMethod == "checkin" || t.auditMethod == "lock">
             <td>Check-In</td>
         </#if>
      <#if t.auditMethod == "move">
             <td>Paste</td>
         </#if>
      <#if t.auditMethod == "createNode" && t.methodArgumentsAsStrings[2]== "{http://www.alfresco.org/model/forum/1.0}discussion">
             <td>Discussion Create</td>
         </#if>
         
         <#else>
             <td> </td>
        </#if>          
          
          
</tr>
</#if>
</#if>           
</#list>
</table>
<#elseif space?exists>
   <h4>Current Space Audit Info:</h4>
   <b>Name:</b> ${space.name}<br><br>
   <table border="1" width="100%" cellspacing="1" cellpadding="4">
   <tr align="left" class="rowheader">
          <th>Date</th>
         <th>User</th>
          <th>User Address</th>
         <th>Action</th>
         <th>Type</th>
         <th>Name</th>
         
                    
   </tr>
 
   <#list space.auditTrail as t>
  <#if t.auditMethod == "create" ||  t.auditMethod == "getWriter" || t.auditMethod == "checkout" || t.auditMethod ==  "copy"  || t.auditMethod == "checkin" || t.auditMethod == "move" || t.auditMethod=="getReader" ||t.auditMethod=="createNode" >
   <tr>
           <td>${t.date}</td>
<td>${t.userIdentifier}</td>
          <td>${t.hostAddress}</td>

<#– Shows some USER FRINDLY info based on method  –>
<#if t.auditMethod?exists>
<#if t.auditMethod == "create">
<td>Created </td>           

<#if t.methodArgumentsAsStrings[2]=="{http://www.alfresco.org/model/content/1.0}folder">
<td> Folder </td>           
<td>${t.methodArgumentsAsStrings[1]}</td>           
<#else>
<td> File </td>           
<td>${t.methodArgumentsAsStrings[1]}</td>           
   </#if>
</#if>
<#if t.auditMethod == "getWriter">
         <td>Edit</td>
         <td>File</td>
      </#if>
<#if t.auditMethod == "getReader">
          <td>Read</td>
          <td>File</td>
      </#if>
<#if t.auditMethod == "checkout">
             <td>Check-out</td>
             <td> File</td>
      </#if>
<#if t.auditMethod == "copy">
             <td> Copy</td>
             <td> File</td>
             <td><#assign i = t.methodArgumentsAsStrings[2]?last_index_of("}") >
                 ${t.methodArgumentsAsStrings[2]?substring(i+1)}</td>
      </#if>
<#if t.auditMethod == "checkin">
             <td>Check-in</td>
             <td> File</td>
      </#if>
<#if t.auditMethod == "move">
<td> Paste</td>
 <#if t.returnObjectAsString?exists>
 <#assign fileinfo = t.returnObjectAsString >
 <#if fileinfo?contains("true")><td>Folder</td> <#else><td>File</td> </#if>
</#if>
             <td><#assign i = t.methodArgumentsAsStrings[2]?last_index_of("}") >
             ${t.methodArgumentsAsStrings[2]?substring(i+1)}</td>
      </#if>
<#if t.auditMethod == "createNode">
<#if t.methodArgumentsAsStrings[2]?exists>
<td> Created</td>
<td> File</td>
             <td>
             <#assign i = t.methodArgumentsAsStrings[2]?last_index_of("}") >
             ${t.methodArgumentsAsStrings[2]?substring(i+1)}
              </td>
       </#if>
      </#if>
<#else>
       <td> </td>
</#if>         
</tr>
</#if>
</#list>
</table>
</#if>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Note:this is my modified show_audit.ftl just copy and past the code.

Re: Audit trail

skorde — Thu, 18 Sep 2008 13:46:10 GMT

Hi
I have enable auditing in my production copy(Alfresco2.1+oracle9i),it is working fine and storing a required information in database except some of the field like CLIENT_ADDRESS,MESSAGE etc.
my question is

Why this field is null,specially CLIENT_ADDRESS?
Why alfresco not stored the data in this filed?
is auditing still in under development stage?

Thanks in Advanced

Re: Audit trail

skorde — Fri, 10 Oct 2008 06:30:46 GMT

Hi
I have enable Audit Trail on Alfresco 2.1 Community version
But I don't understand why it creating multiple entries for example
When I create file it's showing in there template it has been created(create method) and edit(get Writer method).
When I edit file through CIFS it will created multiple entries in database for the same operation like read several times,edit etc.

Thanks in Advanced

Re: Audit trail

norgan — Fri, 10 Oct 2008 10:22:14 GMT

Hi Skorde,
I would guess that is related to the CIFS protocoll for accessing filesystems. If you do a webdav or an FTP, that should be different as well. If you want to try webdav, you (probably) need to reactivate the webdav function in windows.

-> c:\windows\system32\webfldrs.msi
and7or use the "Open as Webfolder" Extension for firefox

Regards, Norgan

Re: Audit trail

skorde — Fri, 10 Oct 2008 11:03:53 GMT

Thanks for post

Yea! It’s actually the problem exists with CIFS protocol, but we don't want to disable this feature,
We want solution, how we can restrict alfresco for storing this unnecessary information (several times read, create temp file) in Audit table

Re: Audit trail

ingcarloshud — Tue, 16 Dec 2008 20:15:46 GMT

Hello…I'm trying to get the audit report when some user delete any space or content but….it doesn't work, it shows processTemplate…I'm working community2.1
I made an upgrade to community 2.9b wishing that this bug dissapear, but!!! the same problem goes on.
Does anybody solve this bug???? I really really appreciate if you can help me with that.
Regards!!!

Re: Audit trail

carol — Tue, 17 Mar 2009 10:54:13 GMT

Hello everyone

We want to save on the audit the folders and contents that have been consulted by the user, we have to set the 'config audit' leaving only the method 'get reader', but through the 'show audit', we find that the method is only saved ' process template.

Could someone please help?

Thank you so much.

Carol

Re: Audit trail

chandu7ee — Tue, 16 Feb 2010 13:07:36 GMT

Can somebody send me the screen shot of audit report, please????

here is the screen shot for auditing in alfresco

http://aboutalfresco.blogspot.com/2009/12/audit-configuration-in-alfresco.html

thanks & Regards
Chandu

Re: Audit trail

miudon — Sat, 27 Feb 2010 22:41:14 GMT

Hi skorde
First of all, thanks a lot to share your code.
Did you get the 'delete' , 'rename' 'move' methods with your template?

Hi chandu7ee
Thanks a lot for your tutorial

thanks & Regards

Re: Audit trail

fagiano — Mon, 06 Sep 2010 09:55:54 GMT

I use Alfresco 3.3
If i use show_audit.ftl the function "start advanced workflow" doesn't work. is this a known issue?
how can i overcome the problem?
please advise thank you