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]

Luiz,

To confirm, you were using quick import into the alm_hardware table? What columns were in your excel sheet? I was assuming you were using a custom built transform map or RTE where the data would go through the IRE to verify identication.