Sample collector discovery queries

You can use queries similar to these examples to monitor devices discovered using the collectors.

Sample: Determining the directionality of connections between layer 1 devices discovered by collectors

The following example shows how to check that the collector has retrieved directionality of connections between devices. Allowed values for connection directionality are as follows:
  • 0 for bidirectional (two-way link)
  • 1 for unidirectional (one-way link)
select * from CollectorLayer1.returns;
go
....
{
               m_UniqueAddress='10.1.1.18';
               m_Name='OpticalNE1';
               m_ManagerId='localhost:8081_1';
               m_HaveAccess=1;
               m_Protocol=1;
               m_UpdAgent='CollectorLayer1';
               m_LocalNbr={
                       m_InterfaceId='STS 1';
                       m_LocalNbrName='OpticalNE1';
               };
               m_RemoteNbr={
                       m_RemoteNbrName='OpticalNE2';
                       m_InterfaceId='PTP 1';
                       m_Unidirectional=1;
               };
       }

       {
               m_UniqueAddress='10.1.1.20';
               m_Name='OpticalNE3';
               m_ManagerId='localhost:8081_1';
               m_HaveAccess=1;
               m_Protocol=1;
               m_UpdAgent='CollectorLayer1';
               m_LocalNbr={
                       m_InterfaceId='STS 2';
                       m_LocalNbrName='OpticalNE3';
               };
               m_RemoteNbr={
                       m_RemoteNbrName='OpticalNE1';
                       m_Unidirectional=1;
               };
       }
This result fragment shows two devices.
Device 10.1.1.18
This device has a local neighbour named OpticalNE1 and a remote neighbour named OpticalNE2.
Device 10.1.1.18 has a unidirectional link to its remote neighbour OpticalNE2; that is, a one-way link in the direction 10.1.1.18 –> OpticalNE2.
Device 10.1.1.20
This device has a local neighbour named OpticalNE3 and a remote neighbour named OpticalNE1.
Device 10.1.1.20 has a unidirectional link to its remote neighbour OpticalNE1; that is, a one-way link in the direction 10.1.1.20 –> OpticalNE1.