How do I enable all monitored nodes in my environment use DHCP instead of their static IP? I know how to change this manually 1 by 1 but need an automated way to do this. See attached screenshot for enabling DHCP.
You can't. I just tested by going to settings -> Manage nodes -> (Group by vendor) -> Windows -> Select All -> And List Resources is greyed out. Since the DHCP setting is part of the list resources page I do not believe this is possible to do in mass. Theoretically you could delete everything and turn on auto discovery maybe?
That being said if you are monitoring servers, switches, routers, etc. Why is everything DHCP? Those devices should be statically configured. Or are you monitoring endpoints?
So you can update them by running a query via Database Manager.
- From your Orion server
- Go to Start > All Programs > SolarWinds Orion > Database Manager
- Click "Add default server" and expand to your database
- Right-click to your database and hit "New Query ..."
- Copy and paste the SQL query below
UPDATE NodesData SET DynamicIP = 1
WHERE DynamicIP = 0
- Highlight both entries and hit execute query
I stand corrected. You are right. However I'm still wondering why. Typically I've found Solarwinds is better used for infrastructure side monitoring, which typically means the systems its monitoring have standard IPs. He must be updating a mass amount of workstatiosn
