Any issues with adding stockroom field to cmdb_ci_computer table?

[Lon Landry4]

Howdy Community,

Any issues with adding stockroom field to cmdb_ci_computer table?

If no issues, should it be done on cmdb_ci, cmdb_ci_computer, or does it matter?

Thanks for your time,
Lon

[Sohail Khilji · Accepted solution]

Hi @Lon Landry4 

OOTB you must already be having stockroom field if not add it to cmdb_ci_computer table.which is a parent table so that you can over ride this field to its child table too;..

[Ashok Sasidhara]

It is NOT recommended to add 'Stockroom' field on any of the CMDB tables. 'Stockroom' is an asset related concept. For all CIs which have an asset associated with it, you can find the 'Stockroom' details by opening the corresponding asset record (i.e. From the 'Asset' reference field).

As CIs are operational components which are live in organization's environment, there is no need to track the stockroom directly for a CI. For a component which is both an Asset and a CI, 'Stockroom' should be tracked only on the Asset record (As the relevant use cases like keeping a device in stockroom before deployment or while awaiting repair or disposal are considered as part of Asset management and NOT as part of configuration management)

[Sumanth16]

Hi @Lon Landry4 ,

 Why duplicate the field in both places? Why not just have the field from the Asset table display on the Computer form or vice versa? . Just have it display on the asset form and extend that field on cmdb table. It cuts down on complexity and gives you a single place to manage the data. 

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda

[hugomendoza]

Adding the field will allow you to modify it in list view, usually stockroom field is tied to the status changing to In Stock, this field not being available in the Computer table has always been an issue for me.

My recommendation, is add it in cmdb_ci_computer, you will see a lot of benefit on having it there but make sure it's added to the Asset-CI sync as well