How do I link network adapter to server?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-11-2017 08:59 AM
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!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-13-2017 05:31 PM
I believe the cmdb_ci_network_adapter has a Configuration Item field which is supposed to be the server or the PC.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-16-2017 07:14 AM
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'
}
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-19-2017 05:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-04-2022 11:01 PM
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.