Which attribute to store record role ?

sylvain8
Tera Contributor

Dear community, 

We're migrating our legacy CMDB to serviceNow. 

Multiple discovery are in place and we already defined several endpoint using flow designer to fetch specific data from the legacy system. 

 

We have 1 attribute called "Role" in our legacy system for which we want to be visible and used in ServiceNow.

this attribute contains the main activity of the CI like SQL, Security, Network,...

 

I see some attributes in let's say cmdb_ci_server table which eventually can be used to store such information like Category, subcategory, classification or justification.

However they contain already some choices (except subcategory) which does not fit our values.

 

I am new in Snow world, do you have any recommendation on how to achieve this ? 

Using subcategory, creating a new attribute, using another mechanism ootb to achieve such thing ?

 

Thanks for your input, any feedback is appreciated

sylvain

 

1 ACCEPTED SOLUTION

@sylvain8 Ideally, it should not be a problem. However, I recommend making this change on a Sandbox or Dev instance first, analyse the impact and if everything works fine then move the changes to the higher instances. 

View solution in original post

5 REPLIES 5

Sandeep Rajput
Tera Patron
Tera Patron

@sylvain8 The way you described the role field, it seems to me that they are more of categories. Best way would be to migrate the unique roles you have in your legacy CMDB to the Category field on ServiceNow. If due to some reason the Category field doesn't fit in your case then I recommend creating a custom field for this purpose. 

Thanks for the input, you're right ! category sounds better however, there is a dynamic value using : gs.include("CMDBItem");var item = new CMDBItem(current);item.setCategory();

which I am not able to explain, do you ?

@sylvain8 It looks like you are referring to the Dynamic filter 

Screenshot 2024-06-05 at 5.17.28 PM.png

But this value will only get populated by default, in your case you will be migrating this value from your legacy system to your ServiceNow instance, which should not pose a problem in your case.

so Sandeep, if I understand this script, at initialization time of a new record, it will read cmdb_categories table and for cmdb_ci_server insert for category : hardware and subcategory : computer right ?

do you know if there is any purpose of such value ?

If no, is it safe then at dictionary level of category to add choice like SQL, network, security ?

 

many thanks again for your support !