News:

Dear forum visitors, if the support forum is not available, please try again a few minutes later. Thanks!

Main Menu
Support-Forum

Download logs filtering

Started by digitalRASC, 28.08.2019 17:49:39

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

digitalRASC

Hi,

Is there a way of filtering the download logs using MySQL or the raw logs data?

The Download admin panel interface display the total downloads for a file. I would like to find out how many times the file was downloaded in a certain period by maybe running an SQL statement.

I have check but the number I get for a file using the alias and whats on the download interface is not the same.

I am referring to a file where the data was logged and stored in the DB from the upload date (logs DB table has not been cleared)

Regards,
Kisten
  •  

ColinM

Hi
The logging of downloads is in the database table __jdownloads_logs.  For a Download the type field is 1Other entries include the Download title, the Download id and the actual filename together with the date-time of the downloading and,if logged in, the user id.
So you could readily execute a suitable SQL query to find what you need.
Colin
Colin M
  •