The attribute canonicalName has been problematic for us previously. I had hoped this would now just work, but alas that attribute does not seem to translate via KiX.

Has anyone been able to use an ADO LDAP query to return canonicalName?

 Code:
$ADS_SCOPE_SUBTREE = 2

$objConnection = CreateObject('ADODB.Connection')
$objCommand = CreateObject('ADODB.Command')
$objConnection.Provider = 'ADsDSOObject'
$objConnection.Open('Active Directory Provider')

$objCommand.ActiveConnection = $objConnection
$objCommand.CommandText = "SELECT distinguishedName, canonicalName, cn, employeeID, department FROM 'LDAP://dc=domain,dc=pheaa,dc=org' WHERE objectCategory='user' and sAMAccountName='user1'"
$objRecordSet = $objCommand.Execute()

$distinguishedName = $objRecordSet.Fields('distinguishedName').Value
;$canonicalName     = $objRecordSet.Fields('canonicalName')        ;script error
$canonicalName     = $objRecordSet.Fields('canonicalName').item(0) ; 0
;$canonicalName     = $objRecordSet.Fields('canonicalName').Value   ;script error
$cn                = $objRecordSet.Fields('cn').Value
$employeeID        = $objRecordSet.Fields('employeeID').Value
$department        = $objRecordSet.Fields('department').Value

"var=" + vartype($canonicalName)

? $distinguishedName
? $canonicalName
? $cn
? $employeeID
? $department
?


 Code:
var=8204
CN=Bullock\, Howard A (P609154),CN=Users,DC=domain,DC=pheaa,DC=org

ERROR : Error in expression: this type of array not supported in expressions.!
Script: C:\data\Automation\LogonScript\test.kix
Line  : 22

Edited by Howard Bullock (2013-11-27 04:55 AM)
_________________________
Home page: http://www.kixhelp.com/hb/