How to Create a Custom Data Class
Custom data classes can be created by using CMDB Solution. These can be assigned to out of box resources or to custom resources to add new fields for data.
The following instructions describe how to create custom data classes. Other related articles are also referenced, as the user may also need to create custom resources, Data Connector Import Rules and custom reports.
Click on the resource's "Save changes" button.
How Custom Data Classes Work with Assets and in SQL
Custom data classes will create tables of the same name. These appear as "Inv_<custom data class name). For example, if the name of a custom data class is "Camera Details", this then appears as "Inv_Camera_Details", with underscore characters in-between each word. All attributes (columns) in the data class will appear in the table too.
In the database, this appears as the table Inv_Camera_Details. Its _ResourceGuid column will contain the GUID of the asset record it's related to. The following example SQL script could be used to view an asset and its custom data class:
FROM vCellphone vc
LEFT JOIN Inv_Camera_Details icd
ON icd._ResourceGuid = vc._ResourceGuid
How to create a custom resource
How to create a custom report that uses a custom resource and custom data classes
How to import data into a custom resource or custom data class using a Data Connector Import Rule
Resources are unable to be saved after using SQL to change a custom data class
Unable to create a custom data class string attribute that is larger than 4000 characters in size
Related Legacy Article
How to create custom data classes using CMDB Solution 6.5