Filtering Table text

[Jakuza]

Currently I have a table that shows the Organizational Unit that a computer is located in. The text displays as something like CN=ComputerName,OU=Group,OU=Blah,DC=Domain,DC=COM

Is there a way that I could get the table to display only as the "OU=Group" and hide the rest of the text in a visual?

I know that if I could somehow find a table that contained the AD container names I could just create a relationship, but I currently don't have one.

[v-huizhn-msft]

Hi @Jakuza,

As I tested, solution @Phil_Seamark postedcan achieve your requirement, please feel free to ask if you have other issue. If you have resolved your problem, please mark the helpful reply, or share your own solution.

Best Regards,
Angelia

[Phil_Seamark · Accepted solution]

Hi @Jakuza

You could split the column in the Query Editor on the comma into rows and then split again on the = sign as one approach. 

And then filter the new collum on OU=Group