How to retrieve list of all devices sending FLOW to multiple NFA harvesters
Article ID: 133086
Updated On:
Products
Issue/Introduction
How can we find the devices which are sending flow to multiple harvesters ?
Cause
Resolution
Go to your NFA Console and open the mysql from CMD
- type: mysql -unetqos -pnetqos
Type use reporter;
Execute this Query:
select deviceName, count(deviceName), harvesterID from routers group by deviceName order by count(deviceName);
Look for entries with count > 1: ( to check for Duplicates)
10.x.x.x | 2
10.2x.8x.1xx | 2
192.6x.6x.7x | 2
172.1x.1x.1x | 2
10.2x.2x.1x | 2
19x.16x.10.1x | 2
10.1x.2x.1x | 2
If you want to know, to which harvesters this devices are sending:
mysql> select deviceName, harvesterID from routers where deviceName = "10.255.192.133";
+----------------+-------------+
| deviceName | harvesterID |
+----------------+-------------+
|10.7x.6x.1x | 4 |
| 10.7x.6x.1x | 7 |
+----------------+-------------+
2 rows in set (0.00 sec)
mysql> select deviceName, harvesterID from routers where deviceName = "10.250.86.192";
+----------------+-------------+
| deviceName | harvesterID |
+----------------+-------------+
| 10.2xx.8x.1xx | 4 |
| 10.2xx.8x.1xx | 7 |
+----------------+-------------+
2 rows in set (0.00 sec)
mysql> select deviceName, harvesterID from routers where deviceName = "192.1xx.xx.7x";
+----------------+-------------+
| deviceName | harvesterID |
+----------------+-------------+
| 192.1xx.6x.7x | 4 |
| 192.1xx.6x.7x | 3 |
+----------------+-------------+
2 rows in set (0.00 sec)
mysql> select deviceName, harvesterID from routers where deviceName = "172.1xx.1x.1x";
+----------------+-------------+
| deviceName | harvesterID |
+----------------+-------------+
| 172.1x.1x.1 | 3 |
| 172.xx.x.1x | 23 |
+----------------+-------------+
2 rows in set (0.00 sec)
mysql> select deviceName, harvesterID from routers where deviceName = "10.2xx.2x.1x";
+------------+-------------+
| deviceName | harvesterID |
+------------+-------------+
| 10.2x.2x.1x | 4 |
| 10.2x.2x.1x | 3 |
+------------+-------------+
2 rows in set (0.00 sec)
mysql> select deviceName, harvesterID from routers where deviceName = "192.1xx.2xx.5xx";
Empty set (0.00 sec)
mysql> select deviceName, harvesterID from routers where deviceName = "192.1xx.1x.1x";
+---------------+-------------+
| deviceName | harvesterID |
+---------------+-------------+
| 192.1xx.1x.1x | 23 |
| 192.1xx.1x.1x | 2 |
+---------------+-------------+
2 rows in set (0.00 sec)
Here is the list of harvesters with their ID:
mysql> select harvesterID, description,address from harvesters;
+-------------+-------------------------------+-----------------+
| harvesterID | description | address |
+-------------+-------------------------------+-----------------+
| 0 | Do Not Delete | 0.0.0.0 |
| 2 | harvesters1 | 10.xx.2x.1 |
| 3 | harvesterp1 | 172.xxx.6x.1 |
| 4 | harvesterp2 | 192.1xx.xx.10 |
| 6 | dtest harvester | 10.1x.2x.1 |
| 7 | ltest harvester | 172.1xx.2x.10 |
| 8 | Itest harvester | 10.2xx.1x.10 |
| 9 | gtest01 harvester | 10.2x.2x.2x |
| 10 | htest01 Harvester | 10.3x.0.5x|
| 11 | gtest02 Harvester | 172.1xx.1x.10 |
| 12 | gtest03 Harvester | 192.1xx.2x.1 |
| 13 | gtest04 Harvester | 172.1x.2x.2x |
| 14 | gtest05 Harvester | 10.5x.2x.1x |
| 15 | gtest06 Harvester | 10.2x.2x.1 |
| 16 | gtest07 Harvester | 10.2x.2x.2 |
| 18 | gtest09 Harvester | 192.1xx.4x.2x |
| 19 | gtest12 Harvester | 192.1xx.4x.1x.1 |
| 20 | gtest13 Harvester | 192.1xx.2x.10 |
| 21 | gtest11 Harvester | 2xx.2xx.2xx.2x |
| 23 | frdtest Harvester | 1xx.1xx.1x.1x |
| 24 | gtest08 Harvester |22x.2xx.10.11 |
+-------------+-------------------------------+-----------------+
21 rows in set (0.00 sec)
Attachments
Feedback
