• Hi,

    i'm using

    SELECT * FROM OPENQUERY( [SERVER1],

    'SELECT sAMAccountName, userPrincipalName, company, department, Name, givenName, SN, Mail, telephoneNumber, mobile,

    l, physicalDeliveryOfficeName, postalCode, streetAddress, facsimileTelephoneNumber, msExchHideFromAddressLists, distinguishedName, info

    FROM ''LDAP://SERVER1/ DC=subsubdomain,DC=subdomain,DC=domain''

    WHERE

    objectClass = ''user''

    AND

    objectCategory = ''Person''

    AND (mobile = ''*'' OR telephoneNumber = ''*'' OR facsimileTelephoneNumber = ''*'' OR mail = ''*'' )

    ORDER BY userPrincipalName

    ')

    The difference lies in a space between "LDAP://SERVER1/" and "DC=subsubdomain,DC=subdom..."

    and in the where clause. Don't know if that will make the difference?

    regards karl

    Best regards
    karl