Linking DCF interfaces with device interfaces table in a query

Solved1.07K viewsDCF Connections node-edge query
0
0 Comments

Hi!!

In the following Dataminer training we could see a very nice query where the DCF and the device interfaces table are linked to show some metrics in Node Edge component the popup

Configuring the tooltips – DataMiner Dojo

Is there any suggested configuration to achieve it?

It could normally go with a join using the interfaces IDs but they don’t match inside the element itself.

Thanks.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best

1 Answer

0
21.24K 0 Comments

Hi Edson,

You will need to use the column Dynamic PK and the Element ID in your query get the relationship between these two tables (query: Get DCF Interfaces).

From there, you can perform another inner join query using Get DCF Connections to retrieve the connections for the interfaces

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best