For auditing, I use the [Denodo Monitor](https://community.denodo.com/kb/view/document/Denodo%20Monitor%20timings?category=Performance+%26+Optimization) tool, which is a command-line based utility that logs information about Denodo Platform servers. "vdp-queries.log" contains information about queries' durations in milliseconds.
To get the list of queries that took longer than 800 seconds (800,000 milliseconds), I would do it one of these ways:
* Create a [delimited data source](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources) over "vdp-queries.log" and then a view. Then, execute a query such that it has a filter on "duration" column.
* Alternatively, the Denodo Monitor logs can be used with [Diagnostic & Monitoring Tool](https://community.denodo.com/docs/html/browse/latest/vdp/dmt/introduction/introduction). To achieve your scenario, I would create first create a [diagnostic](https://community.denodo.com/docs/html/browse/latest/vdp/dmt/creating_diagnostics_and_diagnostic_intervals/creating_diagnostics/creating_diagnostics), and then in the diagnostic's ["Requests"](https://community.denodo.com/docs/html/browse/7.0/vdp/dmt/monitoring/monitoring_servers/monitoring_requests) tab, add the "Duration" column and specify a filter such that it returns log information where the duration of the query is greater than 800 seconds.
* Lastly, if you are a valid Support user, you can use [Denodo Monitor Reports](https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Monitor%20Reports%20-%20User%20Manual) which can be downloaded from the DenodoConnects section of the [Support Site](https://support.denodo.com/). This is a web application that generates graphical reports based on the Denodo Monitor logs. These reports also return information on queries' durations.
Hope this helps!