Closed davecorun closed 3 years ago
.append Keyring <| Profiles | join (Keyring | where KeyType == 'ProfileId' | project GroupId, ProfileId=toint(KeyValue)) on ProfileId | project GroupId, KeyType='Email', Email #C
.append Keyring <| Profiles | join (Keyring | where KeyType == 'ProfileId' | project GroupId, ProfileId=toint(KeyValue)) on ProfileId | project GroupId, KeyType='Email', Email #C