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 🙂