We utilize the description field on network interfaces to denote server names, desk locations, and other important information about our network. It is updated regularly as new ports are connected, servers are removed/added, etc. It doesn't seem that Orion NPM automatically recognizes these changes and only keeps the values initially imported when you initially select the resources to monitor. Is there a way to have Orion NPM automatically update these values, or do I have to constantly go in and un-manage/manage resources to get updated data? Matt
I do this with a SQL Query to manually update all of the interface descriptions....I have not found a way to make SW do this on its own but the query works.
I am having this same problem. Could you please explain to me how to run the SQL Query? I am using SQL Express... I am familiar with SQL, but not know where and how to put this Query. Could you let me know what you have used and how I can implement it?
Sorry for the delay I haven't been online in a few. The query I run combines two fields to create the description. I combine the Interface Name and the Alias. The only issue is if the description is left blank by default the alias is the same as the interface name so you get a description like this fa0/0 - fa0/0.
Use with caution as you will be updating several fields in the DB. The query is ran from the interface table. Also, I didn't write this as I have limited SQL knowledge so thanks to my coworker Keith who came up with this for me.
update Interfacesset caption = IfName + ' - ' + interfacealiaswhere caption in (SELECT Caption FROM Interfaces WHERE (Caption <> IfName + ' - ' + interfacealias) AND (InterfaceAlias <> ''))
The problem I've found with using a query such as this is that it logs an "Interface Name Change" event for every interface to which the query applies (with v9 SP2). Are you guys seeing the same thing?
Based on the following post, it sounds like this is a known issue that should be resolved soon.
