ETL Import / Export database / Port configuration table

[DCIM_Support]

Hi, I have been working with the ETL export/import databases for a few months, and in our current data center we have thousands of devices with multiple port configurations. I can locate in the export database if a port is in use in the “public_relation_endpoint_property” table; however, there doesn’t appear to be any table(s) that provide information on the port start, and port count in relation to the port module name. For example, I can see that a device’s port module name (It can have multiple) has ports 3,6, and 8 has a connection, but there is values with the start port and port count for that module name.

So, there doesn’t appear to be a method to check if a device already has a particular port module name, and what the start port, and port count is. We are attempting to automate the process of creating network connections, but not being able to A. Search for a device, then B. Get the name of each port, and subsequent start port and port count is for that device. Also, another way to phrase this is in the import database, there is a port configuration table, but no table in the export database that has that information that I can extract.

(CID:106203896)

[DCIM_Support · Accepted solution]

Will port_configuraiton help?

Whilst not specified at https://dcimsupport.apc.com/display/DCIMDEVELOPER/ETL+Export+Database

export_cables=# \d port_configuration
 Table "public.port_configuration"
 Column | Type | Modifiers 
-------------------------+------------------------+-----------
 ci_id | character varying(255) | not null
 connector_type | character varying(255) | not null
 module_name | character varying(255) | not null
 start_port | integer | not null
 port_count | integer | 
 port_speed | character varying(255) | 
 state_flag | character varying(16) | 
 state_last_synchronized | bigint | 
 state_last_updated | bigint | 
Indexes:
 "port_configuration_pkey" PRIMARY KEY, btree (ci_id, connector_type, module_name, start_port)

(CID:106203898)

[DCIM_Support]

export_cables=# select connector_type,module_name,start_port,port_count,port_speed from port_configuration where ci_id='0ea32ec3-76a3-4196-a4f5-1660d72632d3';; connector_type | module_name | start_port | port_count | port_speed ------------------+-----------------------------+------------+------------+------------ RJ45_REGULAR | module A | 1 | 24 | 1 Gbps RJ45_REGULAR | module B | 1 | 24 | 1 Gbps FIBER_SC_REGULAR | EdTestDiffTypesOnSameModule | 1 | 1 | 1 Gbps FIBER_ST_REGULAR | EdTestDiffTypesOnSameModule | 4 | 1 | 1 Gbps RJ45_REGULAR | EdTestDiffTypesOnSameModule | 7 | 1 | 1 Tbps

(CID:106203899)

[DCIM_Support]

Thanks for the reply Ed. I don't think I phrased my question right. Basically, I need to somehow get all of our port configuration information that already exists in DCO, loaded into the Import port_configuration table. The export database gives us ports already in use in the “public_relation_endpoint_property” table, for example in the “cir_id” column: “00e11ff5-10b1-4383-a585-f11c672bd937#CP-Q2NZA-TT05-2#13#RJ45_REGULAR#false”, but that doesn’t tell what the start port and port count is for “CP-Q2NZA-TT05-2”. It just tells me that port 13 is in use on module name CP-Q2NZA-TT05-2. We have thousands of devices in our Data center, and I’m unable to manually add all that information to the import database.

(CID:106203904)

[DCIM_Support]

Hi again Thomas, you want to get all DCO port info loaded into an ImportDB table called port_confugration. On my DCO 7.5 SP4. I have an Export DB table called port_configuration (same name as a table in my Import DB) If you have same table in your export DB then you can transfer. Can you see the table in your Export DB?

(CID:106203905)

[DCIM_Support]

Hmm, no I can't see that table in my export DB. I only see these tables in the screen shot

List of Export Tables.JPG

(CID:106203907)

[DCIM_Support]

Perhaps it has to with an export job? These are the only options I see in DCO

DCO Export Jobs.JPG

(CID:106203909)

[DCIM_Support]

Hi Thomas I think Ed is on the right track here. There is a port_configuration table in the ETL Export database that provides (as far as I understand) the information you need. What is missing is perhaps that it is only part of the service packs, not the original 7.5 release. So if you install service pack 5 - currently the newest one - you should then be able to see the table. (I will reach out to you on email so you can get the service pack). Furthermore I will look into updating the documentation.

(CID:106203915)

[DCIM_Support]

Ohhh, that would be great. That makes sense. It didn't occur to me that could be the case. I appreciate the help Ed and Niels, and I look forward to the email.

(CID:106203917)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.