Skip to main content

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

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

Authors list

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.

Helpful Unhelpful

41 of 76 people found this page helpful

Add a comment

Please log in or register to submit a comment.

Need a password reminder?