https://www.insidesql.org/blogs/uricken/?disp=comments de-DE http://backend.userland.com/rss 60 Mon, 06 Sep 2010 09:11:09 +0000 tosc c1021@https://www.insidesql.org/blogs/ Und es lässt sich wunderbar das AD mit OPENQUERY abfragen: SELECT l AS 'Standort', department AS 'Abteilung', sn AS 'Name', givenname AS 'Vorname', telephonenumber AS 'Telefon', facsimiletelephonenumber AS 'Fax', mobile AS 'Handy', co AS 'Land', displayName AS 'Anzeigename', 'INSIDESQL' + '\' + sAMAccountname AS 'Domain\Benutzer' FROM OPENQUERY(TOSCADSI, < ldap ://DC01/ DC=insidesql,DC=org>; (&amp;(objectCategory=Person)(ObjectClass=user)(!userAccountControl:1.2.840.113556.1.4.803:=2)); objectSID,objectGUID,displayName,givenname,middleName,sn,userPrincipalName, sAMAccountname,name,mail,company,department,title,telephonenumber, facsimiletelephonenumber,mobile,streetAddress,co,postalcode,l,dNSHostname,adspath;subtree') AS ADLDAP</ ldap> ; (&(objectCategory=Person)(ObjectClass=user)(!userAccountControl:1.2.840.113556.1.4.803:=2)); objectSID,objectGUID,displayName,givenname,middleName,sn,userPrincipalName, sAMAccountname,name,mail,company,department,title,telephonenumber, facsimiletelephonenumber,mobile,streetAddress,co,postalcode,l,dNSHostname,adspath;subtree') AS ADLDAP]]> https://www.insidesql.org/blogs/uricken/2010/08/20/verwendung-von-udf-auf-linked-server#c1021