Bulk CI import through excel

[Community Alums]

Hi folks,

I've a requirement to load CI's with different classes.

I'm passing Class label (windows server, Application service etc..,) in excel, after import i've noticed class is being set as 'configuration Item' . I know that we should pass class name(cmdb_ci_win_server), as i've many classess and it's not possible to create field map script or use GlideRecord to retreive backend name.

Is there any otherway to import CI's using Class label ?

[Mark Manders]

This can be done by creating a field map script or use GlideRecord to retrieve the backend name. Why can't you use that? 

[Community Alums]

@Mark Manders 

we've different classes, I can't hard code everything, and glidding CMDB_CI table it takes a lot of response time.

is there any otherway to acheive this ?

[Mark Manders]

It's either doing it once in ServiceNow so you can reuse it in the future, or do make the changes in the excel and you need to do that every time, like Sohail already mentioned. There are no shortcuts here.

[Sohail Khilji]

in short, Use gliderecord to query the class lables thats the easy way to go,.. or do excel manual work and then load them...