Hi Sirs,
How can I get which Items has not associated files. Could I have a sql query?
Thanks,
Solved! Go to Solution.
Solved by smilinger. Go to Solution.
Hi,
SQL queries against the databases are not supported or recommended. Vault does support a public API that could be used to gather this information, however some amount of programming knowledge would be required. Here is some information on installing the SDK used to communicate with the Vault API (https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles...).
Hope this helps,
Paul
You can check the Provider property of the item, for an item created from Inventor it will get "Inventor" as the value, if the item is not linked to file any more, the value will be cleared.