LDAP view

SELECT     displayName, mail, telephoneNumber, physicalDeliveryOfficeName, title, department, RIGHT(LEFT(manager, CHARINDEX(',', manager) - 1), LEN(RIGHT(manager,
                      CHARINDEX(',', manager) - 1)) - 3) AS Expr1, CN, SAMAccountName, accountExpires, manager
FROM         OPENQUERY(ADSI,
                      'SELECT mail, displayName,givenname,distinguishedName, SAMAccountName, CN, physicalDeliveryOfficeName,department,title,telephoneNumber,manager,userAccountControl, accountExpires,maxPwdAge
FROM ''LDAP://domain''
WHERE objectCategory = ''Person'' AND objectClass = ''user''
')
                       AS derivedtbl_1
WHERE     (userAccountControl = 512) OR
                      (userAccountControl = 66048)