Logins from AD to SQL table

• kd11

  Hall of Fame

  Points: 3447

  More actions

  August 10, 2010 at 8:54 am

  #146505

  Does anyone know a way to extract names from Active Directory into a sql table? Using a package, script, etc.

• simens1986

  Newbie

  Points: 7

  More actions

  October 4, 2012 at 12:03 pm

  #1545720

  USE [master]

  GO

  sp_configure 'show advanced options',1

  GO

  reconfigure with override

  GO

  sp_configure 'Ad Hoc Distributed Queries',1

  GO

  reconfigure with override

  GO

  SELECT Name,displayName,givenname,sn,telephoneNumber,mobile,mail,distinguishedName,SAMAccountName,'description'

  FROM

  OPENROWSET('ADSDSOObject','adsdatasource' ,

  'SELECT Name, displayName,givenname,sn,distinguishedName,

  SAMAccountName,mail,mobile,telephoneNumber,description

  FROM ''LDAP:// DC.domain.com/OU= ,OU=,DC=''

  WHERE objectClass = ''user''')

  !!!! limit 1000 users!!!!