ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to retrieve list of all devices sending FLOW to multiple NFA harvesters

book

Article ID: 133086

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

How can we find the devices which are sending flow to multiple harvesters ?

Cause

Causing duplication 

Environment

Release : 9.3

Component : NQRPTA - REPORTERANALYZER

Resolution

Go to your NFA Console and open the mysql from CMD

 - type: mysql

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