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:
USE Symantec_CMDB
SELECT *
FROM vCellphone vc
LEFT JOIN Inv_Camera_Details icd
ON icd._ResourceGuid = vc._ResourceGuid
Related Articles
How to create a custom resource
HOWTO83472
How to create a custom report that uses a custom resource and custom data classes
181382
How to import data into a custom resource or custom data class using a Data Connector Import Rule
HOWTO83495
Resources are unable to be saved after using SQL to change a custom data class
TECH198194
Unable to create a custom data class string attribute that is larger than 4000 characters in size
TECH176533
Related Legacy Article
How to create custom data classes using CMDB Solution 6.5
HOWTO83499