06-18-2019 09:08 AM
I have two DHCP members – both in HA. Both DHCP members are serving different networks without any failover association configured.
If one DHCP member completely fails – meaning both HA nodes go down – I need to quickly assign the DHCP ranges for those networks to the other DHCP member. I am not great in the programming area and would like some assistance in to:
- Needing to retrieve the grid member that has all dhcp ranges assigned to that grid member
- If it is one member, change it to the other member
Solved! Go to Solution.
06-18-2019 09:31 AM
You actually don't need any scripting or programming to accomplish this. The CSV Job Manager makes this easy to accomplish.
- Use the CSV Job Manager to export all of your networks and ranges.You can find this in the vertical toolbar on the right-hand side of the page on any screen under the Data Management tab.
- Remove all of the columns that you do not need (any required columns are noted with an asterisk).
- Update the dhcp_members and member columns. If using DHCP Failover, update the failover_association column. Save this to a new file.
- Using the CSV Job Manager, create a new CSV import job with the job type set to override.
- Browse to the updated CSV file.
- Optional: Set the "On error" action to "Skip to the next row and continue".
- Run the import.
- Restart services once the import is complete.
Note: If all your doing is changing the member assignment, the CSV syntax will look like the following:
If you only have a single Network View, that column can be ommitted. If in doubt or you have multiple Network Views, include it and specify the Network View for the networks and ranges you want to update. Navigate to Administration -> Network Views to review any existing Network Views. The Network View is selected using a dropdown menu found at the top left-hand side of your Grid Manager GUI window.
06-18-2019 02:28 PM
Sweet! I don't use the export function all that much and had forgotten about it. I tried this on a test dhcp range and it worked. Thank you, that's exactly what I was looking for.
06-30-2020 10:48 AM
i have 100 of network configured , but not associated with DHCP grid members . I want to associate all networks to grid members , is it possible to add grid members using csv , one by one i can do from GUI.
07-04-2020 07:38 AM
Yes you do this with an "override" CSV job. The CSV file should only have the columns needed to identify which networks are being changed, and the setting being changed.
You will also need to change the ranges within the network, and assign them to a member or a failover association.
For example with a single member:
Or for a failover association:
Practice on a lab appliance if you have one. Otherwise just do one network first to make sure you're happy with the results.