Concatenation of computer name and AD Path

Hello,

I am attempting to concatenate the first three characters of the Computer Name property, and add them to a another value. In this case, part of the OU level 3 and 4 from active directory path. I’m actually using this to set the Advertisement list for relays. I just need to better understand the Concatenation function to perform this process.

Can someone please provide the code that would perform this query and, if possible, some explanation on how this works.

Thank you!

Hi Matt,

Does this sequence help you out? Hopefully it’s self-explanatory, but if not let me know.

q: computer name
A: SEYMOUR
T: 0.207 ms
I: singular string

q: first 3 of computer name
A: SEY
T: 0.274 ms
I: singular substring

q: concatenation of ("test"; first 3 of computer name)
A: testSEY
T: 0.358 ms
I: singular string
1 Like

Sean,

Perfect thanks!