select
- concat('ou=',categorycode) as dn,
- 'top
- organizationalUnit' as objectClass,
- categorycode as ou,
- description as description,
+ concat('ou=',c.categorycode,',dc=ffzg,dc=hr') as dn,
+ 'organizationalunit' as objectClass,
+ c.categorycode as ou,
+ c.description as description,
+ -- fake for SafeQ, we don't have numeric primary key
+ crc32(categorycode) % 1000 as objectGUID
+from categories c
- -- fake objectGUID since we don't have primary key
- crc32(categorycode) as objectGUID
-
-from categories