We use Solarwinds to monitor many of the Public Library Branch Equipment in addition to our server environment. I have struggled with an effective way to monitor these devices as they have Dynamic IPs and are constantly being taken off the network for repair.
I run a Network Discovery to find any new equipment every day. The discovery finds the nodes and assigns a static IP.
In order to modify the nodes, I am running a TSQL Update on the database after the Network Discovery jobs complete. Fortunately the nodes that I want to make Dynamic have a standard naming convention.
UPDATE SolarwindsOrionDatabase.dbo.NodesData
SET DNS = SysName,
DynamicIP = 1
WHERE (
SysName LIKE '%PUB%'
OR SysName LIKE '%REF%'
OR SysName LIKE '%CIR%'
OR SysName LIKE '%SMM%'
OR SysName LIKE '%SCO%'
OR SysName LIKE '%CAT%'
OR SysName LIKE '%DED%'
OR SysName LIKE '%SHR%'
OR SysName LIKE '%PRT%'
);