KQL Search

Query Details

HomeAI ToolsDevice Query

Replace Strings Malfunction

Query

print
    replace_strings(
        "00000006-0000-0ff1-ce00-000000000000 , 04b07795-8ddb-461a-bbee-02f9e1bf7b46",
        dynamic(["00000006-0000-0ff1-ce00-000000000000"]),
        dynamic(["test"])
    ),
    replace_strings(
        "00000006-0000-0ff1-ce00-000000000000 , 04b07795-8ddb-461a-bbee-02f9e1bf7b46",
        dynamic(["00000006-0000-0ff1-ce00-00000000000"]),
        dynamic(["test"])
    ),
    replace_strings(
        "00000006-0000-0ff1-ce00-000000000000 , 04b07795-8ddb-461a-bbee-02f9e1bf7b46",
        dynamic(["0000006-0000-0ff1-ce00-000000000000"]),
        dynamic(["test"])
    ),
    replace_strings(
        "00000006-0000-0ff1-ce00-000000000000 , 04b07795-8ddb-461a-bbee-02f9e1bf7b46",
        dynamic(["00000006-0000-0ff1-ce00-000000000000 , 04b07795-8ddb-461a-bbee-02f9e1bf7b46"]),
        dynamic(["test"])
    )
// Real output
// 00000006-0000-0ff1-ce00-000000000000 , 04b07795-8ddb-461a-bbee-02f9e1bf7b46    test0 , 04b07795-8ddb-461a-bbee-02f9e1bf7b46    0test , 04b07795-8ddb-461a-bbee-02f9e1bf7b46    test
// Desired output
// test , 04b07795-8ddb-461a-bbee-02f9e1bf7b46    test0 , 04b07795-8ddb-461a-bbee-02f9e1bf7b46    0test , 04b07795-8ddb-461a-bbee-02f9e1bf7b46    test

Explanation

The query is using the replace_strings function to replace specific strings in a given text.

The text being replaced is "00000006-0000-0ff1-ce00-000000000000 , 04b07795-8ddb-461a-bbee-02f9e1bf7b46".

In each replace_strings function, a different string is being replaced with the word "test".

The desired output is "test , 04b07795-8ddb-461a-bbee-02f9e1bf7b46 test0 , 04b07795-8ddb-461a-bbee-02f9e1bf7b46 0test , 04b07795-8ddb-461a-bbee-02f9e1bf7b46 test".

Details

Jose Sebastián Canós profile picture

Jose Sebastián Canós

Released: November 15, 2023

Tables

There is not enough information provided to determine the name of the table or tables used in the query. The code snippet provided only includes a print statement and a function call to `replace_strings`but it does not specify the source of the data or the table name.

Keywords

Devices,Intune,User

Operators

replace_stringsdynamic

Actions