topic Re: Finding number of files being downloaded in Alfresco Forum

Finding number of files being downloaded

sanketmohite — Thu, 22 Mar 2018 10:21:14 GMT

I am using Alfresco 4.0 community version. How can I know number of file being downloaded form afresco for a given day? Is there any postgres query available to get this count?

Re: Finding number of files being downloaded

afaust — Thu, 22 Mar 2018 10:47:47 GMT

Downloads are - by default and without any customisations - not tracked in Alfresco and as a result you cannot query for that information.

Re: Finding number of files being downloaded

mehe — Thu, 22 Mar 2018 15:41:05 GMT

if you use a reverse proxy or load-balancer in front of alfresco, you could filter and count the access-logs for the download urls - just a thought

Re: Finding number of files being downloaded

afaust — Fri, 23 Mar 2018 11:16:47 GMT

Be aware though that Alfresco supports byte-range downloads, which means - depending on the client (i.e. Adobe PDF) you can end up with multiple entries in the access logs for the same file because the client downloaded the file in chunks instead of "as a whole". Also, a browser can also trigger two (or more) requests on the download URL, i.e. if you use "View in Browser" - one to determine the mimetype so that the browser can check wether to show it directly or present a download popup, and the remaining entries for the download (which again can be in chunks).