Working with output from ldapsearch command

who10 · 10-07-2016, 09:22 AM

Using ldapsearch, I've built the following command to get what I need.

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

Results are:

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

Now, I want to do something with this output, for example, write to a .txt file in a format such as:

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

I know I can redirect the output of the ldapsearch to a file, but I'm not sure what the best route would be to format the output into a line similar to what I've shown above. Any pointers/opinions would help at this point. Thanks!

grail · 10-08-2016, 03:01 AM

You could try awk / perl / python or any number of commands / languages to manipulate the data into the desired format.

who10 · 10-10-2016, 09:06 AM

I'll try that. Thanks.

Bhagyesh · 10-10-2016, 09:13 PM

Code:

$$ cat /tmp/temp.txt 
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

$$ cat /tmp/tt.txt | sed -r 's/\\,|,|CN=|OU*//g' |awk -F "|=|:" '{printf $2"|"}'
 Bob Billy J| sometown| somestate| (123)456-7890| Bob Billy J| Handform| b123456| billy.j.bob@somecompany.com| 5432|

who10 · 10-11-2016, 09:17 AM

Quote:

Originally Posted by Bhagyesh

Code:

$$ cat /tmp/temp.txt 
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

$$ cat /tmp/tt.txt | sed -r 's/\\,|,|CN=|OU*//g' |awk -F "|=|:" '{printf $2"|"}'
 Bob Billy J| sometown| somestate| (123)456-7890| Bob Billy J| Handform| b123456| billy.j.bob@somecompany.com| 5432|

I'll need to research sed and awk to break this down and understand what each section is doing.

pan64 · 10-11-2016, 09:23 AM

I would suggest you to use one single tool, like awk/python/perl/whatever, do not mix them! Probably you can do something like this:

Code:

awk (pseudo code)
/look for string/ { var1=$2 }
/look for another string/ { var2=$2 }
/look for final string/ { print formatted var1 var2 .... $2 } <filename>

allend · 10-11-2016, 09:54 AM

Yep, I am with pan64 on this, as it allows for changing the order of the fields.

Code:

BEGIN {FS=": "; OFS="|"}
$1 == "l" {locality = $2}
$1 == "st" {state = $2}
$1 == "telephoneNumber" {telephoneNumber = $2}
$1 == "displayName" {displayName = $2}
$1 == "department" {department = $2}
$1 == "sAMAccountName" {sAMAccountName = $2}
$1 == "mail" {mail = $2}
$1 == "departmentNumber" {
	print displayName,sAMAccountName,telephoneNumber,mail,department,$2,state,locality}

Put it in a file and use awk with the -f option.

who10 · 10-11-2016, 10:11 AM

Being a newbie, I think it would be easier for me to focus on one tool as you've stated above. I'll look at awk based on what you've shown and go from there.

grail · 10-11-2016, 02:04 PM

Here's a reference to help :- http://www.gnu.org/software/gawk/man...ode/index.html