DX Infrastructure Manager

Expand all | Collapse all

Unify data from devices with different names with the same IP

Jump to Best Answer
  • 1.  Unify data from devices with different names with the same IP

    Posted 12-06-2019 02:30 PM
      |   view attached
    Good day Team Broadcom
    I hope you are fine.
    I need your support, I hope you can support me

    I have a list of IPs monitored by ecometer_monitor, on the client server, in the host file:
    192.168.10.67 retail1
    192.168.10.68 retail2
    192.168.12.90 retail3 …

    but the customer changed the names of their stores, which requires changing. example:
    192.168.10.67 retail_cdmx_1
    192.168.10.68 retail_cmdx_2
    193.168.12.90 retail_chih_1 …

    The question is: how can I make the change without losing the data from the previous name? example:

    In the previous graph the two teams are shown, (before and after), I want to unify the data and only see the new one.

    Stay tuned to your comments

    Regards.


  • 2.  RE: Unify data from devices with different names with the same IP

    Posted 12-06-2019 02:40 PM
    if the target is the only thing that is different you can use the slm portlet to merge qos.

    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------



  • 3.  RE: Unify data from devices with different names with the same IP
    Best Answer

    Posted 12-06-2019 02:47 PM
    David -

    You will have to merge all of the QoS data for these devices from the old entries in the S_QOS_DATA table to the new entries created when the device name changed.  The following Knowledge Document should help you with this:

    KB72808 : How can I merge a large amount of QOS data?

    ------------------------------
    Kathy Maguire
    Technical Support Engineer 4
    Broadcom
    ------------------------------



  • 4.  RE: Unify data from devices with different names with the same IP

    Posted 12-06-2019 03:13 PM
    Hello  Kathy / Gene

    Thank you very much for the information

    Indeed there are many data (approx 40 devices) each devices have 50 channels monitored.

    Seeing the information, I have mysql database, do these scripts work? since I have the impression that the script works with SQL Server

    What is required is to change the names of the devices and not the robots

    Regards