load balance devices across relays - USE WITH CAUTION

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Client Management


    COMPONENT:

    Client Management


    APPLIES TO:

    BCM >= 12.0



    QUESTION:

    How to load balance client distribution across several relays?


    ANSWER:

    Will cause issues if clients are accidentally made into relays.  Use with caution !!  

    1. Create a free query  for each one of your relays using the queries below.  Each query is increased by 1  for the value  CHAR(1))=

    Query for Relay 1

      Select DeviceName from Devices where TopologyType!= '_DB_DEVTYPE_RELAY_' and TopologyType!='_DB_DEVTYPE_MASTER_' and  
      CAST(([DeviceID]% (select COUNT(*) from Devices where Devices.TopologyType='_DB_DEVTYPE_RELAY_')+1) as CHAR(1))=1
      
    Query for Relay 2  
      Select DeviceName from Devices where TopologyType!= '_DB_DEVTYPE_RELAY_' and TopologyType!='_DB_DEVTYPE_MASTER_' and  
      CAST(([DeviceID]% (select COUNT(*) from Devices where Devices.TopologyType='_DB_DEVTYPE_RELAY_')+1) as CHAR(1))=2
      
    Query for Relay 3  
      Select DeviceName from Devices where TopologyType!= '_DB_DEVTYPE_RELAY_' and TopologyType!='_DB_DEVTYPE_MASTER_' and  
      CAST(([DeviceID]% (select COUNT(*) from Devices where Devices.TopologyType='_DB_DEVTYPE_RELAY_')+1) as CHAR(1))=3
      

    ( repeat the query just increase the CHAR(1) value if you have more relays) 

    2. From each one of these queries you would then create a device group  

    3.  You would then create an operational rule for each relay .  The operational rule would be the step 'Relay Module Setup'  that points to the specific relay the operational rule is for.    

    4.  Assign the operational rule to the device group that matches the relay it was created for  


    This will update the devices and point them to the relay that was assigned to them via the query .     For this to work correctly you have to make sure the relays you plan on using are the only relays  and you create a query for each one .     

     


    Article Number:

    000140295


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles