2 Replies Latest reply on Apr 12, 2019 2:33 PM by d09h

    Running on Primary, Backup or Tertiary Network

    deborah.cunning@adiit.com

      Okay, so here is the issue I am trying to resolve.  There are 200+ Fortinet nodes each with 9 interfaces being monitored by NPM.  Four of the interfaces have PRI in the name indicating they are the primary network interfaces.  Four of the interfaces have BCK in the name indicating they are the backup network interface.  One has TER in the name indicating the interface for the tertiary network.  Ultimately, the solution needs to be rolled out to each of 200+ nodes so ideally, it would be programmatic.

      In the case of normal operations, running on the primary network, the four with PRI in the name would be up and the four with BCK would be done.  However if the four with PRI in the name are down and the four with BCK in the name are UP then we are running on the backup network and want to be alerted.

      If all four PRI and all four BCK are down then we are running on the tertiary network and want to be alerted.

      I've tried using the following looking at one of each type interface but it still does not alert. Any ideas on how to get this working would be greatly appreciated.

       

      SELECT E0.[Uri], E0.[DisplayName]

      FROM Orion.NPM.Interfaces AS E0

      WHERE ( ( ( E0.[Node].[Caption] = 'Fortinet1' ) ) AND ( ( E0.[Caption] LIKE '%PRI%' ) AND ( E0.[OperStatus] = '2' ) AND ( ( E0.[Caption] LIKE '%BCK%' ) AND ( E0.[OperStatus] = '1' ) ) ) )