SQL Query for assembly BOM?

Is there a SQL query that can do what the BOM tab does?  I assume there is a SQL query in the background to find the bom data.  Any examples out there?

SolidworksSolidworks Pdm enterprise Pdm
Answers 6
SF
SF 2015-05-18 Best Answer

Hey Mike,

If you check under Programability->Stored Procedures you'll see a BomListProcX where x is the BOMID for each BOM in that vault. That's a bit complicated to use for a report, but that's what's generating the info. If you're just trying to get at reference info you'll need to use a recursive common table expression on the xrefs table and slap a couple of variablevalue's on for the columns.

MS
MS 2015-05-18

Ok, where is Programmability -> Stored Procedures at?

SF
SF 2015-05-18

Hey Mike,

Ah it's under the vault database in SQL Server Management Studio.

MS
MS 2015-05-18

Thanks, found it. 

MS
MS 2018-03-16

Hi Mike,

I am looking for something like this. Did you manage do build a query for this?

LI
LI 2023-06-22

Looking to do this is it possible now?