Download, links counter

🍱 Features & apps
1

Hello support, is there any counter for Admin part in Nextcloud? I need to count how many times users will download specific link.

2

Downloads as in shared files?

3

yes, any shared files

4

There are no app. But can be made with some sql queries on the right sql table.

5

Please can you help, and show that query in the right table just like an example?
Thank you

6

Here is a good one

You can also see recent download activity from other users with a link like the following: https://yournext.cloud/apps/activity/?filter=by

7

Install this app: https://apps.nextcloud.com/apps/files_downloadactivity

And then you can use something similar to this:

select file,count(*) from oc_activity where subject LIKE "%downloaded%" group by file;