SQL Widget - dcT Data Circuit Labels

data_circuit_labels - shows starting item : ending item, and label for each hop in the format ROOM:CABINET:UPOSITION:PORT. When the asset is a blade, the UPOSITION is replaced with CHASSIS UPOSITION - BLADE SLOT LABEL.

data_circuit_patch_seq - shows the patch sequence number, source device, source port a source patch and a destination patch. The source patch is formatted as follows: starting cabinet - starting U Position with the starting letter of the rails used . starting port name / ending cabinet - ending U Position with the starting letter of the rails used . ending port. The destination patch label is the reverse of the source patch label.

data_circuit_patch - shows source device, source port, source patch 1, destination patch 1, source patch 2, destination patch 2, source patch 3, destination patch 3, source patch 4 and destination patch 4. The source patch labels are formatted as follows: starting cabinet - starting U Position with the starting letter of the rails used . starting port name / ending cabinet - ending U Position with the starting letter of the rails used . ending port. The destination patch label is the reverse of the source patch labels.

data_circuit_node_patch_labels - shows the node, source device, source port, label, destination device, destination port. The label is formatted as follows: starting cabinet -  starting U Position with the starting letter of the rails used . starting port name.

data_circuit_node_labels - shows source device, source port, labels for nodes 1 -8, destination device name, destination port name. The node labels are formatted as follows: starting cabinet -  starting U Position with the starting letter of the rails used . starting port name.

 

  • Created by: Alexis Layne
  • Date Created: Tuesday, 06 October 2020
  • Supported Versions: up to 7.2.0

Download attachments:

SQL
Read 328 times

Related items