Neidio i'r brif gynnwys

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

Rhestr o awduron

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.

Defnyddiol Annefnyddiol

Roedd 41 o 76 o bobl yn teimlo bod y dudalen hon yn ddefnyddiol

Ychwanegu sylw

Mewngofnodwch neu cofrestrwch i gyflwyno sylw.

Angen atgofiad am eich cyfrinair?