DX NetOps

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

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.

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

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

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

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.

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

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.