ETL Export - How to identify rear cable connections? module name?

[DCIM_Support]

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.

Thanks

(CID:103586488)

[DCIM_Support]

Hi Ed,

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? 😀

-Guillaume

(CID:104173748)

[DCIM_Support]

Thanks Guillaume

Thread taken off line

(CID:104173820)

[DCIM_Support]

DCO 7.5 SP3 appends "true" to cir_id in configuration_item_relation, e.g.

select cir_id, ci_id_a, ci_id_b
from configuration_item_relation
where cir_id like '%true';

appears to give you all the rear to rear connections

(CID:104173792)

[DCIM_Support]

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