Passer au contenu principal

Number of times 'Downloads' have been downloaded in the user portal - Base de connaissances / Developer & Reporting / DPQL Examples - Deskpro Support

Number of times 'Downloads' have been downloaded in the user portal

Liste des auteurs

Question

 

I would like to know if there is a way to track how many times files are downloaded from our support portal?

 

Answer

 

You can build a custom report to get this information: Reports > Stat Builder > Add. Enter a title and description for your report and the following query:


SELECT downloads.id, downloads.date_created, downloads.title, downloads.num_downloads

FROM downloads

ORDER BY downloads.num_downloads

 

 

You can also add downloads.num_ratings to the SELECT line if you want to see number of ratings per download too.

 

There is a full list of download schema here.

Utile Peu Utile

41 personnes sur 76 ont trouvé cette page utile

Ajouter un commentaire

Veuillez vous connecter ou vous enregistrer pour soumettre un commentaire.

Besoin d'un rappel de mot de passe?