Hi all,
I need reports like following scenarios :
any HELP ?
1)
Audit data for a document
e.g. Document Name: Testout.txt
Number User Name Download time
1 | Joe 01/04/2008 HH:MM
S
2 | Joe 11/02/2008 HH:MMS
3 | Smith 09/03/2008 HH:MMS
4 | Laura 10/03/2008 HH:MMS
2)
Document access for selected User
e.g. Document Accessed by Joe
Name Of Document Number of time accessed Last Accessed time
Testout.txt 10 04/01/2008
mySql.doc 2 03/11/2008
3)
Top 10 downloaded/clicked/viewed documents
Document Rank Document Name Number of times downloaded
1 Doc.txt 167
2 S3d.doc 101
3 Testout.txt 3
4 Setup.txt 1
Here all are fine but How do I major followings :
1) Number of times downloaded
2) Number of times accessed
3) Downloads
4) Login / Logout time
Please help for these FTLs.
Thanks
I need reports like following scenarios :
any HELP ?
1)
Audit data for a document
e.g. Document Name: Testout.txt
Number User Name Download time
1 | Joe 01/04/2008 HH:MM
S2 | Joe 11/02/2008 HH:MM
S3 | Smith 09/03/2008 HH:MM
S4 | Laura 10/03/2008 HH:MM
S2)
Document access for selected User
e.g. Document Accessed by Joe
Name Of Document Number of time accessed Last Accessed time
Testout.txt 10 04/01/2008
mySql.doc 2 03/11/2008
3)
Top 10 downloaded/clicked/viewed documents
Document Rank Document Name Number of times downloaded
1 Doc.txt 167
2 S3d.doc 101
3 Testout.txt 3
4 Setup.txt 1
Here all are fine but How do I major followings :
1) Number of times downloaded
2) Number of times accessed
3) Downloads
4) Login / Logout time
Please help for these FTLs.
Thanks
Audit data for a document
e.g. Document Name: Testout.txt
Number User Name Download time
1 | Joe 01/04/2008 HH:MM
2 | Joe 11/02/2008 HH:MM
3 | Smith 09/03/2008 HH:MM
4 | Laura 10/03/2008 HH:MM
You should get your ideas from the show-audit.ftl audit template shipped with Alfresco. If the number you want to show is only a incremented number, you can do it using a freemarker variable like this:
<#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 User
e.g. Document Accessed by Joe
Name Of Document Number of time accessed Last Accessed time
Testout.txt 10 04/01/2008
mySql.doc 2 03/11/2008
As the entry point to get the audit trail is the node, you should directly use an SQL request to query the audit facts on the user name. Here is the SQL request to use:
SELECT store_protocol, store_id, node_uuid FROM alf_audit_fact WHERE user_id = 'YOUR_LOGIN_HERE';You sould mind that there might be audit facts that corresponds to no existing node as they might have been deleted. You can embed the SQL query and result presentation in a custom Freemarker root object. Here is the documentation on how to do this:
http://wiki.alfresco.com/wiki/Template_Guide#Custom_Root_Objects
3)
Top 10 downloaded/clicked/viewed documents
Document Rank Document Name Number of times downloaded
1 Doc.txt 167
2 S3d.doc 101
3 Testout.txt 3
4 Setup.txt 1
Here all are fine but How do I major followings :
1) Number of times downloaded
2) Number of times accessed
3) Downloads
4) Login / Logout time
The number of downloads is the number of ContentService.getReader audit facts for the document. You should be aware that this is the number of downloads from the server… and there may be caching on your network making it different from the number of clicks on the link.
For the login and logout times you should audit the AuthenticationService.authenticate method and AuthenticationService.deleteAuthentication methods.
I hope this could help you
