Query Details
Language Demo Just For Fun And Demo Pattern Replace
Query
print a=' 🐋🐨🐠🐾🐀🐧😚😥👲💭💢💜💬💾🤑🍔🍋🍙🚙👙'
| extend a=extractall('(.)', a)
| mvexpand a
| extend a=substring(base64_encodestring(strcat('abracadabra', a)), 19)
| summarize Message=replace(@'[+]', ' ', replace(@'[[",\]]', "", tostring(makelist(a))))
Explanation
The query takes a string of emojis and characters and performs several operations on it.
First, it extracts each individual character from the string. Then, it expands the extracted characters into separate rows. Next, it concatenates the extracted characters with the string 'abracadabra' and encodes the resulting string in base64. After that, it takes a substring of the encoded string starting from the 19th character. Finally, it replaces certain characters in the resulting list and concatenates them into a single message.
Details
Rod Trent
Released: March 26, 2020
Tables
No table name is mentioned in the query.
Keywords
Devices,Intune,User
Operators
print,a,=,' 🐋🐨🐠🐾🐀🐧😚😥👲💭💢💜💬💾🤑🍔🍋🍙🚙👙',|,extend,a=extractall('(.)',,a),|,mvexpand,a,|,extend,a=substring(base64_encodestring(strcat('abracadabra',,a)),,19),|,summarize,Message=replace(@'[+]',,',',' ',,replace(@'[[",\]]',,"",,tostring(makelist(a)))),.