• You can try this SQL query:

     

    select *  FROM OPENROWSET('ADSDSOObject',

     'adsdatasource;', 'SELECT  cn, mail, co, distinguishedName, displayName

     FROM ''xxxxxxxxxxxxxxxxxx'' where objectClass = ''User'' ')

     

    Note that xxxxxxxxxxxxxxxx can be 

     GC://something.com or LDAP://something.com where something.com is an Active directory server.