How do I link network adapter to server?

ztking
Kilo Explorer

In order to correlate SNOW CMDB data with some other tools, I'm trying to get relevant server info out of the tool over the API. I'm currently working with the following tables:

  • cmdb_rel_ci
  • cmdb_ci_network_adapter
  • cmdb_ci_server

I'm unable to deduce how to link the network adapter to the server. I thought I used the cmdb_rel_ci table and that the linking was a relationship captured there, but when I find a network adapter sys_id and look for it in the rel_ci table, it's absent. If I list all relationships with a server's sys_id, I don't find any relationship to what appears to be a network adapter.

What am I missing here? Is there some other table I should be looking at? How do I pair a network adapter with its associated server? Thanks!!

6 REPLIES 6

ruzzty06
Tera Expert

I believe the cmdb_ci_network_adapter has a Configuration Item field which is supposed to be the server or the PC.


It doesn't seem to. Here's what I'm getting. There's an ID for the adapter, but I don't see any ID for the server that it was found on. When I look for any relationships with this adapter's sys_id as child or parent, I get no results.



{


'table': 'cmdb_ci_vmware_nic'


,'sys_id': 'c8352521db39cb84672af5871d961927'


,'data': {


        'sys_class_name': {


                  'display_value': 'VMware Network Adapter'


                  ,'value': 'cmdb_ci_vmware_nic'


                  }


        ,'name': {


                  'display_value': '00:50:56:88:01:03'


                  ,'value': '00:50:56:88:01:03'


                  }


        ,'operational_status': {


                  'display_value': 'Operational'


                  , 'value': '1'


                  }


        ,'business_criticality': {


                  'display_value': 'Normal'


                  ,'value': '3'


                  }


        ,'support_group': {


                  'display_value': None


                  ,'value': None


                  }


        ,'location': {


                  'display_value': 'Data Center'


                  , 'value':'655cf96b1336960ceb633598d144b0bf'


                  ,'title': 'Data Center'


                  }


        , 'u_environment': {


                  'display_value': 'Production'


                  ,'value': 'production'


                  }


        ,'u_corporate_supported': {


                  'display_value': 'true'


                  ,'value': '1'


                  }


        ,'ip_address': {


                  'display_value': '10.34.116.74'


                  ,'value': '10.34.116.74'


                  }


        }


,'metadata': {


        'sys_updated_on': {


                  'date_calendar_short': '10-13 20:16'


                  ,'display_value': '2017-10-13 20:16:43'


                  ,'value': '2017-10-14 01:16:43'


                  }


        ,'display_title': '00:50:56:88:01:03'


        ,'display_value': '00:50:56:88:01:03'


        }


}


The OOB implementation has the field so I don't know if you did something to your instance.


find_real_file.png


find_real_file.png


Can you check the form first to see if the Configuration Item field is really not there? Or check with the Network Table itself.


Gary Ables
Kilo Explorer

Financial Services Operations is a broad term covering a number of functional areas including fund administration, risk management, cash management, data management, and relationship management – all which are meant to increase value for customers and reduce operating costs.

MyCFAVisit