DX NetOps

Expand all | Collapse all

NFA change IP Domain for Harvester

Jump to Best Answer
  • 1.  NFA change IP Domain for Harvester

    Posted 09-29-2015 04:17 AM

    Hi all,

     

    I already collected data with my harvesters but one of them is in the "Default Domain" so in CAPC the Reconciliation won't work and I have duplicated elements. Now I want to get rid of the duplicates but keep all the data (NFA and PM2.0). Is there a way to fix that? I already set the right IP Domain in the Harvester but also after restarting the DM in CAPC nothing changed duplictaes are still there.

     

    Any idea how to fix that?

     

    rgds Steve



  • 2.  Re: NFA change IP Domain for Harvester
    Best Answer

    Posted 09-30-2015 04:10 PM

    The existing interfaces can be moved to the correct domain to align with CAPC and maintain historical information. Multiple interfaces made be selected for bulk edit.

    Change the Domain of Interfaces and CVIs - CA Network Flow Analysis - 9.3.2 - CA Technologies Documentation

     

    Changing the harvester IP domain affects new interfaces.



  • 3.  Re: NFA change IP Domain for Harvester

    Posted 10-01-2015 10:08 AM

    Hi Steve,

     

    I didn't know that. Pretty cool...  But I have to check 250 Routers so do you have an idea how to do this?

     

    rgds Steve



  • 4.  Re: NFA change IP Domain for Harvester

    Posted 10-01-2015 04:01 PM

    Steve,

     

    You can check and see what interfaces / routers are on which domain by running queries.

     

    This will all be done on the NFA Console Server.

     

    First to get the domain ID numbers that reference the Domain names:

     

    mysql reporter

    select * from domains;  (Note the Domain ID #)

     

    To see what routers are on a particular domain:

     

    select * from routers where domainid=#;

     

    To see what interfaces are on a particular domain:

     

    select * from interfaces where domainid=#;


    Let me know what else you are looking for to help you out.


    -Justin



  • 5.  Re: NFA change IP Domain for Harvester

    Posted 10-02-2015 04:52 AM

    Hi Justin,

     

    thanks that helped a lot to find out the routers which I need to take care of:

     

    mysql> select routerAddress from routers a,harvesters b where a.harvesterID = b.harvesterid and a.domainID != b.domainid;

     

    do you think I can do an SQL Update like the following because i have 350 routers with the wrong ipdomain:

     

    mysql>update routers set domainID = 21 where harvesterID= 5;

     

    rgds Steve



  • 6.  Re: NFA change IP Domain for Harvester

    Posted 10-02-2015 12:06 PM

    Updating just the Routers table wouldn't also trigger an update on the interface level as well.

    Updating the domain from the GUI will trigger an update every

    There is a domainID in the interfaces and agent_definitions table as well that would need to be updated and perhaps elsewhere.

     

    Missing an update to the domainID in one place could leave orphaned records and cause unforeseen problems.

     

    I would recommend the following:

     

    1. Go to the Admin->Physical & Virtual page.

     

    2.  In the search bar, search for the Harvester address for these devices.

     

    3. Expand the "Max Per Page" to 200 devices.

     

    4. Click the check box to select all displayed devices and select "Edit".

     

    5. Change the domain

     

    This will knock out 200 of your 250 devices in one shot.  Then just repeat for the other 50.



  • 7.  Re: NFA change IP Domain for Harvester

    Posted 10-05-2015 04:35 AM

    Hi Christopher,

     

    I've already seen that but when I try this the edit mode also changes the SNMP Community String... I don't want that..

     

    rgds Steve



  • 8.  Re: NFA change IP Domain for Harvester

    Posted 10-06-2015 11:01 AM

    Steve, unfortunately we wouldn't recommend updating this directly in the database. I would recommend opening an Idea on the Ideal Wall a way to do this in bulk through the UI without updating the SNMP Profile.