Forum Discussion
advanced hunting query join
hi guys, I got a problem on the query. if I want to join two tables like this in | join IdentityInfo on $left.InitiatingProcessAccountUpn==$right.AccountUpn it always say error. I ...
I'm not familar with the advanced hunting schema. Have you tried to make sure the column types match? You should be able to use
| getschema
to see what the table/query schema is. You may need to use a
| extend SomeColumn = tostring(SomeColumn)
to get them to match.