As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
Audit data for a documente.g. Document Name: Testout.txtNumber User Name Download time1 | Joe 01/04/2008 HH:MMS2 | Joe 11/02/2008 HH:MMS3 | Smith 09/03/2008 HH:MMS4 | Laura 10/03/2008 HH:MMS
<#assign counter=1/> <#list document.auditTrail as trail> <td>${counter}</td> <td>show the other audit informations here</td> <#assign counter = counter + 1/> </#list>
2)Document access for selected Usere.g. Document Accessed by Joe Name Of Document Number of time accessed Last Accessed timeTestout.txt 10 04/01/2008mySql.doc 2 03/11/2008
SELECT store_protocol, store_id, node_uuid FROM alf_audit_fact WHERE user_id = 'YOUR_LOGIN_HERE';
3)Top 10 downloaded/clicked/viewed documents Document Rank Document Name Number of times downloaded1 Doc.txt 1672 S3d.doc 1013 Testout.txt 34 Setup.txt 1Here all are fine but How do I major followings :1) Number of times downloaded 2) Number of times accessed3) Downloads4) Login / Logout time
Content of /Platform/Education and training on 2009-06-06 15:06:43 (Fri) Project count: 1,872 Result count: 692 Content count: 379 Content of /Platform/Education and training on 2009-51-06 15:51:11 (Fri) Project count: 2,347 Result count: 1,266 Content count: 398 Content of /Platform/Education and training on 2009-21-06 16:21:48 (Fri) Project count: 2,347 Result count: 1,266 Content count: 398
<#macro recurse_macro node depth> <#if !node.type?ends_with("systemfolder")> <#if node.type?ends_with("project")><#assign projectCount= projectCount +1> <#elseif node.type?ends_with("result")><#assign resultCount= resultCount +1> <#elseif node.type?ends_with("content")><#assign contentCount= contentCount +1> </#if> <#if node.isContainer> <#list node.children as child> <#if node.children?size != 0 > <@recurse_macro node=child depth=depth+1/> </#if> </#list> </#if> </#if> </#macro> <#assign projectCount= 0> <#assign resultCount= 0> <#assign contentCount= 0> <#assign datetimeformat="yyyy-mm-dd HH:mm:ss (EEE)"> Content of <b>${space.displayPath}/${space.name}</b> on ${date?string(datetimeformat)}</br> <#list space.children as child> <@recurse_macro node=child depth=0/> </#list> Project count: <b>${projectCount}</b></br> Result count: <b>${resultCount}</b></br> Content count: <b>${contentCount}</b></br>