Custom List Field on cmdb_ci_appl

[LouisG]

Hello Experts, 

I was wondering if anyone has ever had trouble with a custom list field on the cmdb_ci_appl table?

I created a few custom list fields named Application Server, Database Server, and Web Server on the cmdb_ci_appl table at the request of a customer because they wanted to know what Servers our Customer Applications are hosted on. 

Very few of these have entries for more than 1 server on a single list field, but for whatever reason, all three of these custom list fields are only able to take 1 value and it will not save any value after the first entry. 

I've tried extending the max length on these list fields on the table itself, but I am unable to. I also have a few custom list fields on a few other tables, and I havent run into this issue. 

Can anyone point me in the right direction?

Thank you for your time and help. 

[Ravi9 · Accepted solution]

Hi Louis

Can I ask why did you create custom fields ? are you having problems using CI relationships ? That would be the OOB way of doing it and probably a better option !

[LouisG]

Hey Ravi,

Is CI Relationships this item?

I went a custom field route, mostly because I was unfamiliar with this and my customer was wanting a specific label for the fields, but if this is the OOB solution and would make more sense, I'll definitely go down this route. 

[Ravi9]

Yes ! and there are multiple ways of maintaining the data

Few options are

if you have any discovery tool such as SCCM or ServiceNow discovery - it will automatically maintain the data for you , you need to setup the automation though

If you dont have any system in place yet - you can go for mass upload route via spreadsheet (data source and transform map in SN lang) but obviously they would require some sort of effort to verify and validate data pre and post import

SN Doc site has detailed pointers around this , do go through and let us know if you have more queries

Cheers

[LouisG]

Thank you so much for your help and direction with this issue, Ravi! 

I'll definitely be utilizing this and I will most likely opt for the mass upload route. I'll be sure to read the related documentation for the process. 

I appreciate you!