This question was originally posted on DCIM Support by Ed Tarento on 2015-11-02
Hi Support team,
DCO 7.5 SP2 ETL Export configuration_item_relation table
How do I identify if a patch panel connection is to the front or the rear of a patch panel port?
I can see some info in cir_id and one end of the module name.
This answer was originally posted on DCIM Support by Vigneron Guillaume on 2015-11-04
I'd say, if the connection is between two patch panels, then it's on the rear. I would need to create a setup and export it to identify precisely whether the "Rear" information is directly available. Maybe you have an export database I can connect to check? 😀
This comment was originally posted on DCIM Support by Ed Tarento on 2015-11-04
Thread taken off line
This answer was originally posted on DCIM Support by Ed Tarento on 2015-11-04
DCO 7.5 SP3 appends "true" to cir_id in configuration_item_relation, e.g.
select cir_id, ci_id_a, ci_id_b
where cir_id like '%true';
appears to give you all the rear to rear connections
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!