Jul 17 2020
03:36 AM
- last edited on
Apr 08 2022
10:33 AM
by
TechCommunityAP
Jul 17 2020
03:36 AM
- last edited on
Apr 08 2022
10:33 AM
by
TechCommunityAP
Hi
Anyone have a Solution on how to extract Common name from Distinguished Name In Kusto I have tried parse, split, Sub string and what ever, but haven´t have a success with VB and Power Shell it is simple and a lot of examples to grab
From a table called Member Name containing
CN=test test, OU=something, OU=Something, OU=Something
would like to display only the Name in output table
Test Test
Jul 17 2020 05:36 AM
Solution
Here are two ways, I prefer Parse to split in this case:
let MemberTable = datatable (cn:string)
[
"CN=test test, OU=something, OU=Something, OU=Something"
];
MemberTable
| parse cn with * "CN=" strcnName "," *
| project split(split(cn,",").[0],"=").[1] , strcnName
Jul 23 2020 01:08 AM
Thanks for your reply, had parse and split in the loop, but could not get a clean output
got something like [cn=Name Name]
instead of Name Name
Jul 23 2020 05:24 AM
Maybe this a JSON rather than a string?
Could you copy & paste one line of the real output from the real table? Please remove any PII but leave the format!
e.g.
MemberTable
| limit 1
Jul 24 2020 02:33 AM
table name is MemberName
the string from the table to retrieve
CN=Name Name,OU=Users,OU=org,OU=O_City,OU=NN,OU=XX_ABC,OU=Group,DC=Domain,DC=com
Name Name
Tried this but have a "wrong" Column name would like MemberName instead
Jul 24 2020 02:45 AM
Hi Clive
Thanks for the inputs it triggered some thoughts and I got the right output with a small alteration in the added script
Jul 17 2020 05:36 AM
Solution
Here are two ways, I prefer Parse to split in this case:
let MemberTable = datatable (cn:string)
[
"CN=test test, OU=something, OU=Something, OU=Something"
];
MemberTable
| parse cn with * "CN=" strcnName "," *
| project split(split(cn,",").[0],"=").[1] , strcnName