Hi, I am trying to pull AD data into SQL and I've got everything working except for the employeeID attribute. I can't get the employeeid values to populate into SQL. Does anyone have any ideas on why this is not working? I have attached my code.
SELECT TOP (100) PERCENT displayName, mobile, facsimiletelephoneNumber, telephoneNumber, mail, department, physicalDeliveryOfficeName, title, givenName,
from ''LDAP://ausdc2:3268/ OU=Dynamic Systems, DC=fgi_main,DC=local''
where objectCategory = ''Person''
objectClass = ''user''
WHERE (givenName IS NOT NULL)
ORDER BY displayName