How to create Routers and switches using IntegrationHub ETL

[Community Alums]

Hi ,

Please guide me how to create Routers and Switches using integrationHub ETL.

I am getting below error when the source file contains Router and Switch (for windows and Linux records it works fine)

Identification Reconciliation Engine(IRE) Processing errors->
1: In payload no relations defined for dependent class [cmdb_ci_router] that matches any containment/hosting rules: [cmdb_ci_router >> Hosted on >> cmdb_ci_logical_datacenter]. Add appropriate relations in payload for '{"className":"cmdb_ci_router","values":{"discovery_source":"SG-SolarWinds","name":"TestR1","serial_number":"10010"},"internal_id":"b981ae4d29d9d11049b8ec8e358dd7d8","sys_object_source_info":{"source_feed":"CMDB Data Load 1","source_name":"SG-SolarWinds"},"settings":{"updateWithoutDowngrade":"true"},"sys_ire_info":{},"display_values":{}}'
2: Identifier keys could not be generate based on either criterion attributes or source_name/source_native_key

Ci Class Manager , i can see the below OOB dependent Relation(Router Hosted on Logical DataCenter)

Please guide me the steps to add relation rules in the payload.

Thank you

[Community Alums]

Hi @Tamilselvan Parameswaran ,

Refer to this doc, it has everything you need in steps :https://docs.servicenow.com/bundle/tokyo-servicenow-platform/page/product/configuration-management/c...

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[#3]

My guess is that you are targeting the wrong classes.  If you look at the hierarchy for Router and Switch they both extend from Virtual Machine Object.  This means that they are both targeting cloud/virtual routers and switches.  If you are looking for a traditional router or switch they are called IP Router and IP Switch.  These are in the Hardware hierarchy.  Targeting IP Router and IP Switch will not require a dependent relationship to Logicial Datacenter.

If you are indeed trying to target cloud/virtual routers and switches you will need to ensure that the dependent relationship to Logical Datacenter is fulfilled.  That means you will need to populate a map to the Logical Datacenter class which itself has adependent relationship to Cloud Service Account.

[Community Alums]

Hi ,

Thanks for your reply.

I have tried to create a integration and able to create records on Windows server and Linux server class using IntegrationHub ETL.

Now, I wanted to understand the steps to load data for any class which is having a dependent relationship.

(Example Network Adapter)

so the source file (consider Excel sheet) do we need to have relationship type and hardware ci information also?

Please suggest some example data how we can load data to network adaptor class.

Thank you.

[#5]

You need to have data to populate both the hardware and the network adapter in the same row of data.  Oftentimes this will involve just mapping the source native key to hardware.  This has to be the same source native key value as the full hardware mapping.  See below for an example:

Hardware will have a minimal mapping involving just the source native key (mandatory) and source recency timestamp (optional):

The network adapter will be mapped as normal:

Then you will map the relationship:

The key here is using the same source native key for both the full hardware mapping and the stub hardware mapping to create the relationship.