Hi,
I have two lookup tables
lookup1:
RealName, username
Smith, J ( LDN), smithj
Andy, H (LDN),andyh
Tan, Y ( JPN), tany
Jiang, T ( JPN), jiangt
lookup2:
Group, Members
admin, CN=Smith, J ( LDN),OU=Users,OU=LDN CN=Andy, H ( LDN),OU=Users,OU=LDN
access, CN=Tan,Y ( JPN),OU=Users,OU=JPN CN=Jiang, T ( JPN),OU=Users,OU=JPN
My original search will output a username ( eg: "smithj"). I need to parse this username into lookup 1 to get the RealName. Then parse that RealName into lookup 2 to search it under "Members" field to get the Group value.
Eg: If my original search returns "joesmith" and parse it into lookup1, I need "admin" from lookup 2.
Could someone help with this search?
... View more