Hello all. I thought I'd cut my teeth on this forum with a question.
Products: Orion 8.5.1 SLX on Win Srv 2003 r2 sp2; MS SQL 64-bit 2005 Std on Win Srv 2003 64-bit sp2.
In an attempt to give some organization to the many nodes on our network, I used Orion's SQL Database Manager to change the data in the location fields as per office location. I shut down Solar Winds services before making database changes. This is the query I used (in Read Only mode):
Select IP_Address, SysName, Location
From Nodes
where IP_Address > '10.1' and IP_Address < '10.1.999'
Order by IP_Address
And the edit string (in read/write mode):
Update Nodes
set Location = 'PDX'
where IP_Address > '10.1' and IP_Address < '10.1.999'
After applying the changes, searching again shows the changes were made. Then, I shut down the database administrator and start up Orion again. But then Orion updated the Location field with SNMP data, overwriting my manually entered changes. Is there a manner to ensure that SNMP won't overwrite my manual database changes?
Thanks in advance for your input.
Eric, Network Administrator, TriQuint Semiconductor
