1 |
|
|
2 |
select |
select |
3 |
concat('uid=',trim(userid)) as dn, |
concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr') as dn, |
4 |
'person |
'person |
5 |
organizationalPerson |
organizationalPerson |
6 |
inetOrgPerson |
inetOrgPerson |
16 |
surname as displayName, |
surname as displayName, |
17 |
rfid_sid as pager, |
rfid_sid as pager, |
18 |
email as mail, |
email as mail, |
19 |
-- categorycode as memberOf, |
categorycode as memberOf, |
20 |
categorycode as department, |
categorycode as ou, |
21 |
concat('/home/',borrowernumber) as homeDirectory |
concat('/home/',borrowernumber) as homeDirectory |
22 |
from borrowers |
from borrowers |
23 |
|
|