Tech Tip: UIM - How can I merge QOS data after making an IP Address change for a network device that I already have QOS for in the SLM database

Document created by danst04 Employee on Mar 13, 2017
Version 1Show Document
  • View in full screen mode

Document ID:  TEC1969571
Last Modified Date:  03/03/2017
Show Technical Document Details

Summary:

I have a network device which had been discovered in discovery server/agent and snmpcollector with IP Addr A and it now needs to be monitored on IP Addr B. Do I have to delete, then rediscover, or can I update somehow? And how do I clean-up or merge the QOS data?


Merge QoS for Renamed Robot.zip

qos_merge_by_host_variation_probe_and_source.txt

qos_merge_oldest_to_newest.txt

 

Background:

In a case like this you would need to remove the existing entry from the db using the discovery_server callback 'remove_master_devices_by_cskey

 

- This call requires the cs_key from the cm_computer_system table
- Rediscover the device via the discovery_agent using the new ip
- Delete the old profile from snmpcollector
- Re-import the device from the discovery_server in snmpcollector (Query discovery_server ...) and let the templates reapply

 

As the device will have a new dev ID you will likely need to merge the QoS data from the old entry to that of the new entry. This can be done using 'Tools -> database status', selecting the matching QoS then selecting merge IF there is a small set of QOS data. If there is a significant amount of QOS data, please refer to the attached scripts.

Environment:
- UIM 8.x
Instructions:

See attached sample scripts.

 

IMPORTANT WARNING:  USE AT YOUR OWN RISK!

 

Note that these scripts to bulk merge QOS data are only offered as examples for you to use and you MUST test the results in a TEST/DEV environment first. We recommend that you work with your DBA as well. We also recommend after reviewing and editing the scripts, that you test it to see the results BEFORE using it in a Production environment. Test it on a small scale then review the data to make sure you get the expected results.

1 person found this helpful

Attachments

    Outcomes