Hi,
It is possible to fetch the usage statistics of views by other applications by setting the user agent for a JDBC, ODBC and JMS connection. In Denodo, it is recommended to set the user agent parameter from the client applications because it will help you to identify the requests performed by particular applications.
In order to specify the useragent in JDBC client, you could perform the following steps:
* Establish a connection between Denodo Platform and client application by specifying the parameter useragent to the URL
`“jdbc:vdb://<host>:<port>/databasename?userAgent=<applicationName>”`
For ODBC client, you could follow the below steps:
* In [DSN connection](https://community.denodo.com/docs/html/browse/latest/en/vdp/developer/access_through_odbc/configuration_of_the_odbc_driver_on_windows/configuration_of_the_odbc_driver_on_windows#set-up-a-dsn-on-windows), select the datasource option which navigates to advanced option dialog where you can able to set the useragent parameter
* In DSN-less connection, you could use the below parameters:
`“DRIVER={DenodoODBC Unicode(x64)};UID=<user account>;PWD=<password of the user>;SERVER=<host name>;DATABASE=<database name>;PORT=9996;SSLmode=prefer;service=;krbsrvname=HTTP;UserAgent=<user agent>;”`
WIth these steps it is possible to collect the statistics of views executed by other applications.
Please refer to the [Setting the User Agent of an application](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/monitoring_the_virtual_dataport_server/monitoring_with_a_java_management_extensions_jmx_agent/setting_the_user_agent_of_an_application) section of the Virtual DataPort Administration Guide.
Hope this helps!
