UNIX for Beginners Questions & Answers

ldapsearch -x -LLL -E pr=200/noprompt -h abc-loc.somecompany.com -D "account@somecompany.com" -w password -b "ou=End Users,ou=Accounts,dc=abc,dc=somecompany,dc=com" -s sub '(distinguishedName=CN=Bob\\, Billy J,OU=End Users,OU=Accounts,DC=abc,DC=somecompany,DC=com)' displayName saMAccountName telephoneNumber mail department departmentNumber l st

dn: CN=Bob\, Billy J,OU=End Users,OU=Accounts,DC=abc,DC=somecompany,DC=com
l: sometown
st: somestate
telephoneNumber: (123)456-7890
displayName: Bob, Billy J
department: Handform
sAMAccountName: b123456
mail: billy.j.bob@somecompany.com
departmentNumber: 5432

Bob, Billy J|b123456|(123)456-7890|billy.j.bob@somecompany.com|Handform|5432|Somestate|Sometown

ldapsearch ... | 
awk -F: '
NR == 1 {n = split (FLDS, T)
        }
        {OUT[$1] = substr ($2, 2)
        }
END     {for (i=1; i<=n; i++)   {printf "%s%s", ODL, OUT[T[i]]
                                 ODL = "|"
                                }
         printf RS
        }
' FLDS="displayName:sAMAccountName:telephoneNumber:mail:department:departmentNumber:l:st"
Bob, Billy J|b123456|(123)456-7890|billy.j.bob@somecompany.com|Handform|5432|sometown|somestate

1) ldap | 
2) awk -F: '
3) NR == 1 
4) {n = split (FLDS, T)
        }
5)        {OUT[$1] = substr ($2, 2)
        }
6) END     
7) {for (i=1; i<=n; i++)   {printf "%s%s", ODL, OUT[T[i]]
8)  ODL = "|"
    }
9)         printf RS
}
10) ' FLDS="displayName:sAMAccountName:telephoneNumber:mail:department:departmentNumber:l:st"