Forum Discussion

saivina2920's avatar
saivina2920
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

How to split specific character from Widows AD Name

I want to display Active Directory user name in my dashboard using label or textbox. How to get current AD name and display in label or textbox...? For Example my current Windows AD name would be "...
Need Help
  • PC2790's avatar
    PC2790
    4 years ago

    Here you go:

     

    UNam =
    VAR Finddelimiter =
    FIND ( "@", USERPRINCIPALNAME (), 1 )
    VAR DomainName =
    MID ( USERPRINCIPALNAME (), 1, Finddelimiter - 1 )
    VAR FindDelimiterDot =
    FIND ( ".", DomainName, 1 )
    VAR FirstName =
    MID ( DomainName, 1, FindDelimiterDot - 1 )
    VAR LastNameInitial =
    MID ( DomainName, FindDelimiterDot + 1, 1 )
    RETURN
    UPPER ( LEFT ( FirstName, 1 ) )
    & RIGHT ( FirstName, LEN ( FirstName ) - 1 ) & " "
    & UPPER ( LastNameInitial )

PC2790's avatar
PC2790
Icon for Community Champion rankCommunity Champion
4 years ago

You can connect to Windows AD, refer this 

saivina2920's avatar
saivina2920
Icon for Post Prodigy rankPost Prodigy
4 years ago

Thanks for the guidance.

I want to read only specific name who has logging in to the system which means AD user name..

Now i am getting "ct1net\201980" from logging into the system.

Using this id, i want to get the name of the specific user....

How to do this...?

  • PC2790's avatar
    PC2790
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Ok, Try this:

     

    UName = VAR FindSlash = FIND("\",USERNAME(),1)
return
MID(USERNAME(),FindSlash+1,LEN(USERNAME()))
    • saivina2920's avatar
      saivina2920
      Icon for Post Prodigy rankPost Prodigy
      4 years ago

      Ok..You are correct to get windows user name (It is windows user account id). But, It doesn't contain any user full name.

      If we want to get user name from AD, I think "sn" is the field name.

      Or

      we can user userprincipalname. It contains mail id along with domain.

      For example, USERPRINCIPALNAME is "[email protected]".

      To get final user name we can use this mail id and split the name of the mail id.

      Final Name is " Joseph J" is the result...

      Is is possible from mail id ("[email protected]")  to get the above name "Joseph J").

      I think the above step is easy way to get the name of the user..

      What is you suggestion pls...?

      • PC2790's avatar
        PC2790
        Icon for Community Champion rankCommunity Champion
        4 years ago

        You can try this if it solves your purpose:

         

        UNam = VAR Finddelimiter = FIND("@",USERPRINCIPALNAME(),1)
        return
        MID(USERPRINCIPALNAME(),1,Finddelimiter-1)