Extract Information Using SQL Query Analyzer

[Anonymous]

Trying to extract drawing information - data like Author, Part Number, Description and so on - directly from the tables on SQL server using Query Analyzer.  I can't find ANY of this information in the tables.

Every table I query that starts with "BOM" is empty.  How can I have a Bill Of Materials in Inventor and have the BOMComponent table in the database be empty?

The goal is to get the data in to some SSRS reports

Can anybody point me in the right direction?

Thanks

[bradeneuropeArthur]

Are you talking about the vault database?

[Anonymous]

Yes, the Vault database(s).

[bradeneuropeArthur]

The Bill of material is only updated when Vault-Items are created.

So you cannot rely on that information when it is provided in vault without using items.

So the information is not or partly written to the vault on check in.

I have programmed this too using the Vault API, but it this is not the same BOM as inventor.

if you need further support please let me know.

Tip:

Use the Vault API to do this. because this is safer and supported by autodesk.

reading directly into the tables is not a good idea and will never be supported by Autodesk.

Regards,

Regards,

Autodesk Software: Inventor Professional 2018 | Vault Professional 2018 | Autocad Mechanical 2018
Programming Skills: Vba | Vb.net (Add ins Vault / Inventor, Applications) | I-logic
Dimension Component! | Partlist Export! | Derive I-properties! | Vault Prompts Via API! | Vault Handbook/Manual!
Drawing Toggle Sheets! | Vault Defer Update!

! For administrative reasons, please mark a "Solution as solved" when the issue is solved !

[Anonymous]

It's not only BOM information I'm looking for.  Item information - Author, Date Created etc - would also be useful.  It's a database, the information has to be in the tables somewhere.

I'm not trying to alter or insert any data - just find it so I can put it on to SSRS forms and reports.

[bradeneuropeArthur]

You wrote:
"Trying to extract drawing information - data like Author, Part Number, Description and so on - directly from the tables on SQL server using Query Analyzer. I can't find ANY of this information in the tables.
Every table I query that starts with "BOM" is empty. How can I have a Bill Of Materials in Inventor and have the BOMComponent table in the database be empty?"

As I tried to explain this BOM information isn't there and is not updated.

You can read properties and information and the BOM structure ofcourse.
this can be easily don with the Vault API.

Is that what you need?
What version of Vault are you using?
What information do you need to be read?

[Anonymous]

I don't need BOM information - I was just using that as an example.  How can there be no data in the BOM tables?  I find this confusing....

I need Item information and I MUST pull that information using an SQL query. NOT the Vault API.  When I look for Item information in the tables I find a bunch of empty tables - I don't see how that is possible....

[bradeneuropeArthur]

Yes that is confusing, but this data isn't available at or is partly available.
It is only updated if you are using items.
The table will be there already, but not filled with data.
I don't excatly know why this is as it is but..

if you are searching for invormation in the Vault, the vault Api is the easiest and the safest way.

Regards,

[bradeneuropeArthur]

Read this:

http://justonesandzeros.typepad.com/blog/2012/11/the-bom-pipeline.html