I need to create 100 Computer CI from Excel upload via data source,but ci class is cmdb_ci

[Prince Sai]

I have created a data source to create 100 hardware records, It is uploading all the fields correctly in the alm_hardware table  except Configuration Item.

All 100 computers model category is "Computer" when i create new hardware records via data source it is creating normal CI(cmdb_ci) instead of (cmdb_ci_computer). what is problem here? Problem in model category configuration or problem is in AssetandCI script includes.

Kindly shoot your comments.

Thanks

[Dr Atul G- LNG]

Hi @Prince Sai 

I am not 100% sure, but my knowledge say, first create the CI.

means, those 100 records first come in SN and create records in computer table and from there the Asset will create via BR and scripts.

https://youtu.be/RdV6RqKFFJw

https://youtu.be/6sIr5vWcGfU

Have a look on these video. 

[Ashok Sasidhara]

Try the following steps. It should most probably help to avoid this issue:

1. Verify that the model category of Computer has 'CI class' as cmdb_ci_computer and 'Asset class' as alm_hardware. Also verify that 'Enforce CI verification' field is NOT checked.

2. List down the model names of the devices which you are planning to upload. Go to hardware models table and open these model records. Validate that 'Asset tracking strategy' field is set to the value 'Leave to category'.

3. If any of these models are not present already in the hardware models table, create those.

4. Now load the data into the cmdb_ci_computer table instead of alm_hardware table. Use integration hub etl for loading so that the CI identification rules are considered. Make sure that the data in important fields like Serial Number, Name, Model category, Manufacturer, Model etc. are entered correctly without any spelling mistakes in your data upload file. The creation of these CIs should ideally create assets in alm_hardware table if all the points mentioned above are taken care of.