SQL Server中的LDAP链接服务器
问题描述:
我在尝试查询LDAP以获取用户帐户的列表以及他们的帐户何时发生更改以及由谁添加或删除了哪些内容?SQL Server中的LDAP链接服务器
系统规格:
的Microsoft Windows Server 2012的R2
的Microsoft SQL Server 2008 R2
目前我能拉很多的信息方面占到期。我们正在尝试审核发生在AD中的管理员更改并每天向我们的主管发送更改...
谢谢!
Current Query:
SELECT * INTO #TMP_LDAP FROM OPENQUERY
( ADSI,'SELECT
uSNDSALastObjRemoved,
countrycode,
mail,
cn,
msexchmailboxsecuritydescriptor,
msexchuseraccountcontrol,
adspath,
mailnickname,
lockouttime,
msexchhomeservername,
homemta,
msexchhidefromaddresslists,
msexchalobjectversion,
msexchmailboxguid,
usncreated,
pwdlastset,
objectguid,
logoncount,
msexchrequireauthtosendto,
codepage,
whenchanged,
NAME,
usnchanged,
accountexpires,
legacyexchangedn,
displayname,
primarygroupid,
userprincipalname,
badpwdcount,
admincount,
badpasswordtime,
instancetype,
objectsid,
msmqdigests,
objectcategory,
mdbusedefaults,
samaccounttype,
distinguishedname,
whencreated,
lastlogon,
givenname,
useraccountcontrol,
textencodedoraddress,
msmqsigncertificates,
lastlogontimestamp,
samaccountname,
homemdb
FROM ''LDAP://SER.SERVER.local/OU=Accounting,DC=SERVER,DC=LOCAL'''
答
有我在LDAP的语法时才错误查找
FROM ''LDAP://SER.SERVER.local/OU=Accounting,DC=SERVER,DC=LOCAL'''
改为正确的查找服务器
FROM ''LDAP://SERVER.local/OU=Accounting,DC=SERVER,DC=LOCAL'''
问题是什么? – Kramb