获取域用户sql代码

最新推荐文章于 2023-02-10 13:56:36 发布

qianjunxian

最新推荐文章于 2023-02-10 13:56:36 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.csdn.net/qianjunxian/article/details/4317579

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