Queying SQL Database For Return All Parts In A Vault

Dear all friends,

Firstly, thanks for the attention! I would like to query my Enterprise PDM database and return a table with all the parts that I have inside a specific vault in my server.

Also, I would like to include in this query only the latest versions of the parts. With the columns, I want to include four metadata (Number, Description, Specification and Material).

After that, I would like to query for list only the assemblies in my vault.

I will use this report to populate our internal ERP/MRP system.

Thanks a lot for the help!

Rafael.

SolidworksSolidworks Pdm/enterprise Pdm