Data Load into Telecom Network Inventory Classes

HaseebR · 3 weeks ago

Hi everyone, I am trying to understand the relationship between the "Set inventory attributes" in servicenow TNI. I know the TNI classes are extended from the base CMDB classes but to create that TNI relationship we use the "Set inventory attributes"

I was wondering, if I was to import data using xlsx file, how would I mimick that "Set Inventory Attribute" ui action.

Maybe im looking at it the wrong way and I'd love any assistance, thank you!

Vishnu-K · 3 weeks ago

Hi @HaseebR ,

So the key thing to understand here is that "Set Inventory Attributes" isn't writing to the standard TNI CI table , it's actually creating a record in a separate Attribute Pack table (extending sn_attribute_pack_base) and linking it back to the CI. That's why a simple XLSX import into the TNI table won't replicate it.

To mimic this via import, you'll need two steps first import into the pack table to create the attribute records, then a second import into the CI table to set the reference back to those pack records. An onAfter transform script in the second map makes the linking pretty straightforward.

A couple of docs that should help:

Hope that clears it up , let me know if you want help with the transform script logic

If it helped you please do mark it as helpful and accept the solution

Thanks,

Vishnu