CMDB - Import to multiple classes in 1 time

[DavidT]

Hello,

I'm providing information to feed the CMDB from several data sources.
The ServiceNow CMDB is structured (of course) into several classes like Windows Servers, Linux Servers, ESX Servers, Switches, Routers, Backup Libraries, ...

Until now I used an intermediate repository that consolidate all data sources, to clean-up & normalize data. But it requires a too long process from my client point of view. Moreover I have to provide 'passive' assets (in stock).

So I try to speed up my update process by connecting SNC directly to data sources... Now I'm facing another type of problem: To simplify code & setup, I'd like to import in 1 time a set of CI in different classes. Is it possible?

Example 1: A list of VM with same attributes, but some should go in 'Windows' class, some in 'Linux' class, some in 'Unix' class, etc. Can I have a single import set, specifying the 'sub-class' of 'Server' class I want to feed?

Example2: A list of new asset not yet in service, again with same common attribute list (Manufacturer, Model, Serial Number, ...) but can be for 15 different classes. Can I have a single import set, or should I set up 15 different imports?

my SNC admin is out of office for some time I count on the community 🙂


best regards,
David

[ctauken]

You can set the "Type" field in the table to the type of CI you are importing. You should them update the left navigation to filter to the values you are importing.

[mbourla]

You can change the table that each record goes into using an onBefore transform map script. You just put code in there that decides which class you want that record to have, and set target.sys_class_name to the appropriate table name. It tried it once and it worked well.

[Dan Tolgyesi1]

Hi,

Did you manage to do this, I am trying to write the onBefore Script, but without any success.

Thanks,

Dan