Forum Discussion
Crossing data in the tables alertsmanagementresources and resource
Hello, I am trying to cross these two tables trying to create a column where I can see the number of warnings alerts (Sev2) and that are fired (Fired) in the last 24 hours for each resource. I am jo...
I dont have this data to check, but have you made sure that both ID's are the same (same case and same format), maybe you need to parse one first.
e.g. if one is
/subscriptions/<guid>/resourceGroups/adds-rg/providers/Microsoft.Compute/virtualMachines/computer01
and the other is this, then they wont match in the Join
Computer01
e.g. if one is
/subscriptions/<guid>/resourceGroups/adds-rg/providers/Microsoft.Compute/virtualMachines/computer01
and the other is this, then they wont match in the Join
Computer01