获取域用户sql代码

CREATE VIEW [dbo].[V_ADUser] AS SELECT CAST(objectGUID AS uniqueidentifier) AS GUID, displayName AS DisName, sAMAccountName AS LogName, REPLACE(SUBSTRING(distinguishedname, CHARINDEX('OU=', distinguishedname), CHARINDEX('DC=', distinguishedname) - CHARINDEX('OU=', distinguishedname) - 1), 'OU=', '') AS OU FROM OPENQUERY(ADSI, 'SELECT objectGUID,displayName, sAMAccountName,distinguishedname,canonicalName FROM ''LDAP://hdhb.bj.cn/DC=hdhb,DC=bj,DC=cn'' WHERE objectCategory = ''person'' AND objectClass = ''user'' ') AS derivedtbl_1 WHERE (displayName IS NOT NULL) AND (CHARINDEX('OU=', distinguishedname) > 0) GO