I use the predefined VQL stored procedure, [GET_ELEMENTS](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/storedprocedures/predefinedstoredprocedures/getelements), for retreiving information about the elements of the server.
In the VQL shell, the below query works fine for me,
`select* from get_elements() where folder= '<foldername>'`
Please note that for the procedure to return the results, the user has to have CONNECT privilege over the database and METADATA privilege over the elements.
You could also create a VQL script by modifying the command based on your use case.
Hope this helps!