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?
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.
I didn't know that. Pretty cool... But I have to check 250 Routers so do you have an idea how to do this?
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:
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.
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;
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.
I've already seen that but when I try this the edit mode also changes the SNMP Community String... I don't want that..
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.