Forum Discussion

KMKing's avatar
KMKing
Regular Visitor
6 years ago
Solved

Getting computer OU information

I am pretty new to Power BI, but its pretty awesome! I have a work in progress dashboard that has simple active directory information. I am trying to get the computer OU information so I can display ...
Need Help
  • KMKing's avatar
    KMKing
    6 years ago

    Was able to resolve this on my own. 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

KMKing's avatar
KMKing
Regular Visitor
6 years ago

Sorry, I posted in haste.

 

I am using the Active Directory connector in Power BI to get information on servers in our domain. I would like to display the servers OU information also on this report. I can then create a filter to show a count of servers in certain OUs. I just need the OU information to be in a better format than what is in the distinguishedName colum.

 

If I add that to the report as it sits, it has all the LDAP information included.

 

Example: CN=Server123,OU=Prod,OU=Servers,DC=help,DC=me,DC=out

 

Format desired: Prod/Servers

 

Hope that makes more sense. 

  • KMKing's avatar
    KMKing
    Regular Visitor
    6 years ago

    Was able to resolve this on my own. 

    • az38's avatar
      az38
      Icon for Community Champion rankCommunity Champion
      6 years ago

      KMKing 

      please, share your solution 🙂

      • KMKing's avatar
        KMKing
        Regular Visitor
        6 years ago

        I split the column using custom delimiters to break out the information and then replaced the text.

         

        Split column

        Custom Delimiter - CN=, (left most)

        Then proceeded to do the same for the end (DC info)

        Split the new column off again - Custom Delimiter - DC=, (left most)

         

        This left me with OU=something,OU=something

         

        I replaced the text on that colum to change OU= to a "/"

         

        This left me with a column containing the OU location only. I will do this again with pictures, I know it seems a little hard to understand with just me typing it out.