Not all interfaces items are shown in dashboards/reports for a device even though they are present in inventory

Products

• Network Observability
• CA Performance Management

Issue/Introduction

In CA Performance Management (CAPM), when looking at a device's interfaces in either Inventory or Component views (Under the interface MF), not all are listed.  The interfaces are missing and do not show.  You can see them in the Monitored Devices Interface view however they are not available to be selected in the Metric Family view for monitoring.

For example, device has 26 interfaces, but when generating a report, only 7 interfaces are shown. Specifically, in this example, interface Gi0/0/0 is not shown in the dashboard report, but the component is present and being polled:

Environment

DX NetOps CAPM all currently supported releases

Cause

"Not Present" interface items are being sync'd from the DA to Portal

Resolution

On the Portal server, login to the MySql netqosportal DB and search dst_interface for localid='<DA ItemID>':

mysql> select SourceID, Itemname, IfName, ItemID from dst_interface where LocalID=14948551;

+---------|----------|---------|---------+
|SourceID | ItemName |  IfName | ItemID  |
+---------|----------|---------+---------+
|       3 | G10/0/0  |  NULL   | 959242  |
+---------|----------|---------+---------+
1 row in set (1.64 sec)

Take the ItemID and use it to search t_interface to see if it exists:

mysql> select SourceID, ItemName, IfName, ItemID from t_interface where itemID=959242;

+----------+----------+--------+--------+
| SourceID | ItemName | IfName | ItemID |
+----------+----------+--------+--------+
|     NULL | Em0/0    | Em0/0  | 959242 |
+----------+----------+--------+--------+
1 row in set (0.00 sec)

If it does, take the t_interface item name and search for it under either Inventory->Interfaces or  under the device->Interface MF->Interface Components:

If we don't see it, check dst_interface where ItemID=<portal itemid from previous call> and see if there is more than 1 port coming from DA sourceID for same interface.  

That means there are  "Not Present"  interfaces being synced and these interface/s need to be removed from the DA to see the active one and report on it.

The process to remove them is to either uncheck the "sync not present items" on the Data Aggregator (DA) Data Source OR use DA REST API to DELETE /rest/retired/<ItemID>  using ItemID of the not present interface. In the above example, this is 959242

Additional Information

On the DA is a script called remove_not_present_items.sh. It can be used to manually delete all not present if you don't wish to have them. There is also a nightly job to delete not present interfaces with no data for a specified period of time.

This is detailed in our TechDocs:

TechDocs : DX NetOps CAPM 24.3 : Delete Components That Are Not Present