Acces to the Custom Inventory Fields data from ODBC
Hello,
I've created a custom inventory field to get some information from our computer. And now i want to acces to the data of the custom inv. field from the database of the K1000 with some sql request.
In the k1000's database, I've found a CUSTOM_FIELD_DEFINITION and a CUSTOM_VIEW tables, but they don't have the data of my custom inventory field.
Where can I find in the database the data of my Custom Inventory field ?
Thanks by advance,
Best Regards
I've created a custom inventory field to get some information from our computer. And now i want to acces to the data of the custom inv. field from the database of the K1000 with some sql request.
In the k1000's database, I've found a CUSTOM_FIELD_DEFINITION and a CUSTOM_VIEW tables, but they don't have the data of my custom inventory field.
Where can I find in the database the data of my Custom Inventory field ?
Thanks by advance,
Best Regards
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
scottlutz
12 years ago
Execute
SELECT * FROM `ORG1`.`MACHINE_CUSTOM_INVENTORY`;
with MySQL Workbench will show all custom inventory data.
SELECT * FROM `ORG1`.`MACHINE_CUSTOM_INVENTORY`;
with MySQL Workbench will show all custom inventory data.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.