![[http]](/moniwiki/imgs/http.png)
User Attributes - Inside Active Directory(http://www.kouti.com/tables/userattributes.htm)
- Research LDAP* Properties for the User Object(http://www.computerperformance.co.uk/Logon/LDAP_attributes_active_directory.htm)
select
replace(substring(DistinguishedName, 1, charindex(',', DistinguishedName)-1), 'CN=', '') 企
, SamAccountName ID
, mail
, cn
, co
from OPENROWSET(
'ADsDSOObject'
, 'User ID=覃\螻;Password=れ;ADSI Flag=0x11;Page Size=10000'
, 'select SamAccountName, DistinguishedName, mail, cn, co from
''LDAP://覃/OU=れ,OU=OU,DC=覃,DC=COM'''
) a
where 1=1
and DistinguishedName like '%伎%'
User Attributes - Inside Active Directory(http://www.kouti.com/tables/userattributes.htm)Research LDAP* Properties for the User Object(http://www.computerperformance.co.uk/Logon/LDAP_attributes_active_directory.htm)