I'm trying to do simple visualization in Azure Monitor of my entities relations.

what i need

I created relations manually:

datatable(nodeId: string, SourceId: string, targetId: string)
[
"node1", "", "node1",
"node2", "node1", "node2",
"node3", "node2", "node3", 
"node3", "node4", "node3",
"node4", "", "node4",
"node5", "node1", "node5",
"node3", "node5", "node3"
]

I've got undesired result, containing proper nodes with relations and useless nodes.

what i got

Seems like nodeID should be unique, but in this case I'm not sure how to construct proper table and display all node relations in the graph.

I'm trying to do simple visualization in Azure Monitor of my entities relations.

what i need

I created relations manually:

datatable(nodeId: string, SourceId: string, targetId: string)
[
"node1", "", "node1",
"node2", "node1", "node2",
"node3", "node2", "node3", 
"node3", "node4", "node3",
"node4", "", "node4",
"node5", "node1", "node5",
"node3", "node5", "node3"
]

I've got undesired result, containing proper nodes with relations and useless nodes.

what i got

Seems like nodeID should be unique, but in this case I'm not sure how to construct proper table and display all node relations in the graph.

• azure
• graph
• kql
• azure-monitor-workbooks

• Could you post direct images instead of image links. – Balaji Commented Mar 19 at 5:56

1 Answer 1

You can try the below code in this case.

let a = datatable(nodeid: string, SourceId: string, TargetId: string)
[
    "node1", "node1","node2",
    "node2", "node1","node5",
    "node3", "node2","node3",
    "node4", "node4","node3",
    "node5", "node5","node3"
];
a

Here, the nodeid column should be Unique and for each unique node, I have given the source and target nodes.

I took the same configurations as yours in the Graph settings.

Result graph: