1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| SELECT
displayName as 'Name',
givenName as 'Given Name',
sn as 'Family Name',
personalTitle as 'Name Prefix',
l as 'Location',
'* Professionnel' as 'E-mail 1 - Type',
mail as 'E-mail 1 - Value',
sAMAccountName as 'IM 1 - Value',
'Mobile' as 'Phone 1 - Type',
mobile as 'Phone 1 - Value',
'Work' as 'Phone 2 - Type',
telephoneNumber as 'Phone 2 - Value',
'Professionnel' as 'Address 1 - Type',
extensionAttribute6 as 'Address 1 - Formatted',
'Ma Structure' as 'Organization 1 - Name',
title as 'Organization 1 - Title',
department as 'Organization 1 - Department'
FROM csvde_ldap_export |