Reporting: Asset Custom Fields Table
We're looking to build a report using the custom SQL functionality within Kace. After adding custom fields to an Asset type, we're having trouble finding the tables and columns that contain the assets' values.
Answers (1)
Top Answer
So there are a few elements to pull together to get to the right data here, they are the ASSET table, the ASSET_TYPE table and the individual asset type table.
The core data including the Asset ID reside in the ASSET table, so the id, name etc and then every asset type you create will have an ASSET_TYPE.ID also shown in the ASSET table. Every Asset type will also have its own table, showing its ID in the name and in that table is found the custom fields you created.
So for example if you create a new Asset type, check the type ID in the ASSET_TYPE table i.e 10205, you will have an ASSET_DATA_10205 table created to hold your custom data and your core data will be in the Asset table.
