Linking DCF interfaces with device interfaces table in a query

Solved676 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 13th July 2023

1 Answer

0
15.88K 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 13th July 2023
You are viewing 1 out of 1 answers, click here to view all answers.