I have a Notes database will a table full of common names used for mailing purposes. To avoid picking up names from users private NAB’s I’d like to create an agent to convert all these Common Names to their Canonical counterpart. I can’t seem to find a view on the system NAB to perform a lookup. Anyone have an idea how I might perform this task?
Thanks
Subject: Common Name to Canonical Name
Are you using multiple OU’s? If so, users w/ the same CN will be more of a challenge- if you don’t use multiple OU’s try concatenating in a formula-NewName := NameField + “/OU/O”
Subject: RE: Common Name to Canonical Name
Yes, unfortunately it’s multiple OU’s
Subject: RE: Common Name to Canonical Name
Then you have problems. If you have two John Smiths with different OU’s, then your common name entry could refer to either one. If you do a lookup in the ($Users) view you’ll find there are two, with no way to know which one’s correct.
Subject: Common Name to Canonical Name
The view you’re looking for in the NAB is called ($Users). It contains all variations of the name, shortname and internet address for lookup.
Subject: RE: Common Name to Canonical Name
I just looked at this view and it uses a catagorized distinguished name in the 1st column. How can I key on this?
Subject: RE: Common Name to Canonical Name
($Users) has every name format for each user, including common name.
Subject: Common Name to Canonical Name
($Users)
Of course if you have two “Bob Smith” in the company with different OU, well you’re not going to be able to resolve those.
Good Luck