This question was originally posted on DCIM Support by Vasileios Baousis on 2017-09-19
I would like to ask the following questions regarding the DCO API
a. Is it possible to list the connections of a network appliance, server? I tried the curl command
curl -s -k -X GET --header 'Accept: application/json' 'https:/user:pass@dco_installation/api/v8.1/assets/search?q=' item and it does not list any connections..
b. If there is way to import any interconnections using the DCO API? If this is possible, does anyone managed to perform a successful bulk import ?
Thanks in advance for any help or direction
This comment was originally posted on DCIM Support by Ditte Drewer Mathiasen on 2017-09-27
Hi Vasileios Baousis, thanks for posting. Let's hope you find your answer here.
Kind regards Ditte
This comment was originally posted on DCIM Support by Vasileios Baousis on 2017-10-18
20 days now and no answer. Probably nobody has done either listing connections or successful bulk import or interconnections to DCO...
This answer was originally posted on DCIM Support by Greg Sterling on 2017-10-19
I do not believe it is possible to list network connections using REST or the web client today.
This should be possible to query the connections from an ETL export database. In that case it would be a SQL based query ... the configuration_item_relation table contains information regarding the network connection relationship info.
This query shows network connections for a specific asset.
select * from configuration_item ci, configuration_item_relation cir
where ci.ci_id = '87770769-f294-4c00-ab0b-333d26b8f745'
and ( cir.ci_id_a = ci.ci_id or cir.ci_id_b = ci.ci_id)
and cir_type = 'network_connection';
This comment was originally posted on DCIM Support by Vasileios Baousis on 2017-10-19
Hello and thanks for your answer. I have two questions :
a. How do I export the ETL database? Is there any manual for that?
b. What about the second part of my initial question? Successfully perform a bulk import of interconnections to DCO.
This comment was originally posted on DCIM Support by Greg Sterling on 2017-10-19
I have pasted a brief doc which describes how to create an export database.
The ETL framework has two different database types.
Regarding your second question, bulk import of network connections. There is a mechanism using an ETL import database to import network connections in DCO.
Using this process requires preparation as you need to define all of the assets in the import database for which you'll make connections and these assets must be logically associated to the actual assets in DCO. Meaning, if you have a rack with a server and a switch in DCO, there must already be entries defined in the import database for the server and the switch, and those entries must be associated to their DCO assets before you can use the import database to make the network connection.
I would recommend working with a member of our services team to get a better understanding of how this works.
Discuss challenges in energy and automation with 30,000+ experts and peers.
Find answers in 10,000+ support articles to help solve your product and business challenges.
Find peer based solutions to your questions. Provide answers for fellow community members!