CI created through Asset import spreadsheet, but Asset not showing up

[Luiz Lucena]

Hello everyone, 

Few weeks ago, I was given the task to import 200 new laptops to the Asset table (alm_hardware), which I used the Excel template for it. 
Before importing, I created the Product Model. 
Then, imported the data into the Asset table, CI's were created as expected but the Assets were not appearing. Only 6 records are being shown.
In the Workstation table (cmdb_ci_computer) I can see the 200 computers, like below example.
The first column above is the Configuration Item, if I search in the Asset table for those CI's, nothing is showing up.

I'm planning to use this script as example and modify accordingly to link the CI's to Assets. 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1216072 

But would like to check with the community to see if someone has a better approach or knows what could have
happened.

EDIT: forgot to mention, checking the Workstation table, the Asset column shows empty values, but when trying to filter to show only those Ci's with no Asset I get no record. 

[k_lutz]

Hello Luiz,

I would suggest checking two things first. On the model, what is the field "Asset tracking strategy" set to? There is a dropdown that says "Don't create assets". Make sure this is not set and is set to an option like "Leave to category." The other thing is then checking the model category on the model. The model category will determine what CI and/or asset record gets created (or not). If the model category only has a CI class, then no asset record would get created.

[Luiz Lucena]

Hi @k_lutz 

Yes, is set to Leave to Category.
For the model category, is set to CI and Asset, like this.

[k_lutz]

Luiz,

On that model category, can you verify if the "Enforce CI verification" is checked or not? Also, were you using a transform map or the RTE?

[Luiz Lucena]

Hi @k_lutz 

No, that checkbox is unchecked. 


Regarding the transform map, I'm not sure, was just using the import data ootb. You know, when we click the column header and choose Import.