extract names from LDAP long names

up vote
3
down vote

favorite

I have this log file which observe user actions on the network, the file contain information from LDAP, very long list like this one:

2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com

I want to extract just the cn names :

jsmith
bjones

how can I do it?

edited 46 mins ago

msp9011

3,61543862

asked 1 hour ago

Cadice

183

New contributor

add a commentÂ |Â

up vote
3
down vote

favorite

I have this log file which observe user actions on the network, the file contain information from LDAP, very long list like this one:

2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com

I want to extract just the cn names :

jsmith
bjones

how can I do it?

edited 46 mins ago

msp9011

3,61543862

asked 1 hour ago

Cadice

183

New contributor

add a commentÂ |Â

up vote
3
down vote

favorite

I have this log file which observe user actions on the network, the file contain information from LDAP, very long list like this one:

2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com

I want to extract just the cn names :

jsmith
bjones

how can I do it?

edited 46 mins ago

msp9011

3,61543862

asked 1 hour ago

Cadice

183

New contributor

I have this log file which observe user actions on the network, the file contain information from LDAP, very long list like this one:

2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com

I want to extract just the cn names :

jsmith
bjones

how can I do it?

sed

edited 46 mins ago

msp9011

3,61543862

asked 1 hour ago

Cadice

183

New contributor

edited 46 mins ago

msp9011

3,61543862

asked 1 hour ago

Cadice

183

New contributor

edited 46 mins ago

msp9011

3,61543862

edited 46 mins ago

msp9011

3,61543862

edited 46 mins ago

msp9011

3,61543862

asked 1 hour ago

Cadice

183

New contributor

asked 1 hour ago

Cadice

183

asked 1 hour ago

Cadice

183

New contributor

Cadice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a commentÂ |Â

3 Answers
3

active

oldest

votes

up vote
2
down vote

accepted

can be done with sed:

sed 's/^.*cn=([^,]*).*$/1/' file

jsmith
bjones

or grep

grep -oP '(?<=cn=)[^, ]+' file

or perl

perl -lne '/cn=(w*),/ && print $1' file

or cut & tr

cut -d'=' -f2 file | tr -d 'ou,'

edited 48 mins ago

answered 1 hour ago

Goro

7,92653776

add a commentÂ |Â

up vote
2
down vote

using sed:

sed -e 's/.*cn=(.*),ou.*/1/' file

using awk

awk -F '[=,]' 'print $2' file

awk -F 'cn=|,' 'print $2' file

answered 1 hour ago

msp9011

3,61543862

add a commentÂ |Â

up vote
2
down vote

% < input
2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com
% perl -nle 'print $1 if m/ cn=([^,]+)/' input
jsmith
bjones

on the assumptions that a comma will not appear in the record name and that cn= do not appear elsewhere in the log

answered 1 hour ago

thrig

23k12854

add a commentÂ |Â

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);

);

Cadice is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f474337%2fextract-names-from-ldap-long-names%23new-answer', 'question_page');

);

Post as a guest

Name

3 Answers
3

active

oldest

votes

3 Answers
3

active

oldest

votes

up vote
2
down vote

accepted

can be done with sed:

sed 's/^.*cn=([^,]*).*$/1/' file

jsmith
bjones

or grep

grep -oP '(?<=cn=)[^, ]+' file

or perl

perl -lne '/cn=(w*),/ && print $1' file

or cut & tr

cut -d'=' -f2 file | tr -d 'ou,'

edited 48 mins ago

answered 1 hour ago

Goro

7,92653776

add a commentÂ |Â

up vote
2
down vote

accepted

can be done with sed:

sed 's/^.*cn=([^,]*).*$/1/' file

jsmith
bjones

or grep

grep -oP '(?<=cn=)[^, ]+' file

or perl

perl -lne '/cn=(w*),/ && print $1' file

or cut & tr

cut -d'=' -f2 file | tr -d 'ou,'

edited 48 mins ago

answered 1 hour ago

Goro

7,92653776

add a commentÂ |Â

up vote
2
down vote

accepted

can be done with sed:

sed 's/^.*cn=([^,]*).*$/1/' file

jsmith
bjones

or grep

grep -oP '(?<=cn=)[^, ]+' file

or perl

perl -lne '/cn=(w*),/ && print $1' file

or cut & tr

cut -d'=' -f2 file | tr -d 'ou,'

edited 48 mins ago

answered 1 hour ago

Goro

7,92653776

can be done with sed:

sed 's/^.*cn=([^,]*).*$/1/' file

jsmith
bjones

or grep

grep -oP '(?<=cn=)[^, ]+' file

or perl

perl -lne '/cn=(w*),/ && print $1' file

or cut & tr

cut -d'=' -f2 file | tr -d 'ou,'

edited 48 mins ago

answered 1 hour ago

Goro

7,92653776

edited 48 mins ago

answered 1 hour ago

Goro

7,92653776

answered 1 hour ago

Goro

7,92653776

answered 1 hour ago

Goro

7,92653776

add a commentÂ |Â

up vote
2
down vote

using sed:

sed -e 's/.*cn=(.*),ou.*/1/' file

using awk

awk -F '[=,]' 'print $2' file

awk -F 'cn=|,' 'print $2' file

answered 1 hour ago

msp9011

3,61543862

add a commentÂ |Â

up vote
2
down vote

using sed:

sed -e 's/.*cn=(.*),ou.*/1/' file

using awk

awk -F '[=,]' 'print $2' file

awk -F 'cn=|,' 'print $2' file

answered 1 hour ago

msp9011

3,61543862

add a commentÂ |Â

up vote
2
down vote

using sed:

sed -e 's/.*cn=(.*),ou.*/1/' file

using awk

awk -F '[=,]' 'print $2' file

awk -F 'cn=|,' 'print $2' file

answered 1 hour ago

msp9011

3,61543862

using sed:

sed -e 's/.*cn=(.*),ou.*/1/' file

using awk

awk -F '[=,]' 'print $2' file

awk -F 'cn=|,' 'print $2' file

answered 1 hour ago

msp9011

3,61543862

answered 1 hour ago

msp9011

3,61543862

answered 1 hour ago

msp9011

3,61543862

answered 1 hour ago

msp9011

3,61543862

add a commentÂ |Â

up vote
2
down vote

% < input
2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com
% perl -nle 'print $1 if m/ cn=([^,]+)/' input
jsmith
bjones

on the assumptions that a comma will not appear in the record name and that cn= do not appear elsewhere in the log

answered 1 hour ago

thrig

23k12854

add a commentÂ |Â

up vote
2
down vote

% < input
2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com
% perl -nle 'print $1 if m/ cn=([^,]+)/' input
jsmith
bjones

on the assumptions that a comma will not appear in the record name and that cn= do not appear elsewhere in the log

answered 1 hour ago

thrig

23k12854

add a commentÂ |Â

up vote
2
down vote

% < input
2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com
% perl -nle 'print $1 if m/ cn=([^,]+)/' input
jsmith
bjones

on the assumptions that a comma will not appear in the record name and that cn= do not appear elsewhere in the log

answered 1 hour ago

thrig

23k12854

% < input
2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com
% perl -nle 'print $1 if m/ cn=([^,]+)/' input
jsmith
bjones

on the assumptions that a comma will not appear in the record name and that cn= do not appear elsewhere in the log

answered 1 hour ago

thrig

23k12854

answered 1 hour ago

thrig

23k12854

answered 1 hour ago

thrig

23k12854

answered 1 hour ago

thrig

23k12854

add a commentÂ |Â

Cadice is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Cadice is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Post as a guest

Name

Search This Blog

Iyfjky