Guest User

Untitled

a guest
Jun 28th, 2018
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. EXEC master.dbo.sp_addlinkedserver @server = N'LDAP', @srvproduct=N'Active Directory Service Interfaces', @provider=N'ADSDSOObject', @datasrc=N'adsdatasource'
  2. EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LDAP',@useself=N'False',@locallogin=NULL,@rmtuser=N'domainLDAPQuery',@rmtpassword='########'
  3.  
  4. select displayName, userPrincipalName
  5. from 'LDAP://domaincontroller.domain.com/DC=domain,DC=com'
  6. where objectClass = 'User' and objectCategory = 'Person'
Add Comment
Please, Sign In to add comment