Thanks to automation, migration between NetEye 3 and NetEye 4 can be easily performed for a lot of entities such as hosts and services. But additional elements like parent-child relationships can be missed. So we implemented a procedure for mass-migration of this information from the old platform to the new one.
In the NetEye 3 appliance, create a folder ParentChild/, and inside it create the file parentchild.sql with the following query:
select child.name AS c_name, child.address AS c_ip, GROUP_CONCAT(parent.name) AS p_name, GROUP_CONCAT(parent.address) AS p_ip from host_parent h_p join hosts AS child using(host_id) join hosts AS parent on parent.host_id=h_p.parent_id GROUP BY c_name,c_ip;
This query exports the data from Monarch DB, the old NeteEye 3 database, into a CSV file that can easily be managed by users:
mysql monarch < parentchild.sql | sed 's/\t/|/g' > parentchild.csv
The generated file looks like the table below, where the columns are:
If no changes were made to the hostnames we can proceed with the automation.
If the hostnames are different, you’ll have to properly modify the CSV file, perhaps editing it directly in Excel. You can then add/remove/update dependencies as desired in order to obtain the target hierarchy.
Here we have a classic situation where the export provides this situation:
Next, copy the CSV file to the Fileshipper directory, then configure the automation.
The first step is to create the first Import Source called, for example, ParentChild Import:
Then define two modifiers, one for the ID and one for the list of parents:
Once the Import source is defined, create a Sync Rule called “ParentChild Rule”, which updates only those existing hosts that match the object name. In order to avoid re-creation of hosts, create the rule with the “Update Policy” set to “Update only”:
Add two basic properties to the Sync Rule to complete the host update:
The result of “Check for Changes” and “Trigger this Sync” is the following, where the parent dependency is added to the child.
For example the host child3.neteyelocal is updated with its two parents:
This simple automation method for the mass import of dependencies from NetEye 3 into NetEye 4 is very easy to implement and can speed up the process of migration between the two environments. This solution does require a bit of attention about the host names used between the two installations. If host names were modified in NetEye 4, then you must edit the CSV/XLXS file in order to prevent the possible loss of information. For this reason, we choose a more conservative migration strategy via CSV and not directly via the DB.