Hi,
In order to get the VQL of a view, I would make use of the [**DESC VQL VIEW <view name>**](https://community.denodo.com/docs/html/browse/latest/vdp/vql/describing_catalog_elements/describing_catalog_elements#describing-catalog-elements) Command.
Then, to obtain only user defined procedures, you can use the [**GET_ELEMENTS()**](https://community.denodo.com/docs/html/browse/latest/vdp/vql/stored_procedures/predefined_stored_procedures/get_elements#get-elements) Stored Procedure with condition like :
> select name from GET_ELEMENTS() where type = 'storedProcedure' and subtype = 'user defined';
Lastly, if I want to fetch the queries of a particular database, I would create a Custom Data source with the [**Denodo Log Custom Wrapper**](https://community.denodo.com/kb/view/document/Reading%20the%20VDP%20logs%20with%20Denodo%20Log%20Custom%20Wrapper?category=Custom+Elements) or by creating a Delimited Datasource which points to the **vdp-queries.log** file under the "<DENODO_HOME>\logs\vdp" directory.
After creating the views from this data source, I would put the necessary WHERE conditions for retrieving the queries from specific databases.
Hope this helps!
