unknown for model
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2022 01:19 PM
I am doing a simple transform map. I have a staging table with two fields 'name;, 'time type'. Transform map target table is 'cmdb_ci_computer'. I did two field maps name and time type with coalescing on the name. The created records are pointing 'model name' to unknown. I guess business rules are running which is updating the model. I checked two records which both point to an 'unknown' model with the same sysid for the model. Is it right way to do. I am glad that it is not creating hundreds of 'unknown' models. I guess it is using the same model with the name 'unknown' model for all 355 records it imported. Appreciate it if I am on the right path
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2022 03:10 PM
Hi, your screenshot does not show\explain how model is mapped in your transform?
There are a number of 'unknown' models configured OOB and if you are creating new CI records and you have no model being imported\mapped then it may be OOB behavior for the model to be 'unknown'; As the model field is mandatory for Assets, and unless you have disabled the OOB functionality creation of a CI would result in the creation of an Asset (probabaly with an unknown model), this model value would then be replicated back into the newly created CI.
The unknown models can be seen in a PDI
/cmdb_model_list.do?sysparm_query=nameSTARTSWITHunknow&sysparm_view=
If you are not importing model values for your CI, you could set a default via a beforeTransform script.
Or you could update your instance to stop the auto creation of Assets, which I suspect is where the model value comes from.
https://docs.servicenow.com/bundle/rome-it-asset-management/page/product/asset-management/concept/c_ManagingAssets.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-25-2022 04:17 AM
Thanks Tony for taking time to reply. I don't have any mapping for the model. One thing It seems doing is, it is not creating new model 'unknown' for each record. All records are pointing to 'unknown' model with same sysid.
You recommended to set default before Transform script. Could you please elaborate what value and how typically set?
I can disable 'business rules' for transform map, but don't know what else it does so that I don't want to do it.
I will ask the other team what is the model name. If they provide, do I need a field map with sysid of that model? Appreciate it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-28-2022 06:02 AM
@Giri6 Were you able to resolve this issue? We are experiencing the same issue, we are importing the data, and our model ID & Assets are also showing "Unknown"
Thanks,
G