Linked Server für ActiveDirectiory

-- Erstellen des Linked-Servers
USE [master]

EXEC master.dbo.sp_addlinkedserver 
  @server           = N'AD_LINK', 
  @srvproduct       = N'Active Directory Service Interfaces', 
  @provider         = N'ADsDSOObject'
EXEC master.dbo.sp_addlinkedsrvlogin 
  @rmtsrvname       = N'AD_LINK',
  @useself          = N'False',
  @locallogin       = NULL,
  @rmtuser          = N'****',
  @rmtpassword      = '****'
GO

drop view V_AD_LINK

create view V_AD_LINK as
SELECT	givenName			as given_name,
		sn					as family_name,
		title				as title,
		'031 377 '+
		substring(telephoneNumber,0,3)+' '+
		substring(telephoneNumber,3,3)		
		                    as phone,
		department			as department,
		mobile				as mobile,
		mail				as email,
		userprincipalname	as user_principal_name
FROM OpenQuery ( 
  AD_LINK,  
'SELECT	employeeID,givenName,sn,title,telephoneNumber,department,mobile,userprincipalname,mail
FROM	''LDAP://DOMAIN.ch/OU=Rollen,DC=DOMAIN,DC=ch'' 
WHERE	objectClass =  ''User'' ') AS tbl
where telephoneNumber is not null;