searching for employeeId takes longer than searching for proxyaddress

[gcue]

Not sure what is happening.  If i pass through an proxyAddresses search completes quickly (0 seconds).  however if i pass an employeeid - the search takes muuuch longer (35 seconds).

I tried searching by another field (which is also digits) - ipPhone (0 seconds)

i specified the OU to see if it helped (in both queries) but it didnt.  I am searching with an actual employeeId value (might be beside the point) Thoughts?

$user = "39393"
$user = "user@company.com"

$sam_acct = Get_SamAccountNameY($user)


Func Get_SamAccountNameY($iString)

    If StringInStr($iString, "@") <> 0 Then
        consolewrite("email identified" @crlf)
        $aObjects = _AD_GetObjectsInOU("OU=People,DC=user,DC=company,DC=com", "(proxyAddresses=smtp:" & $iString & ")", 2, "sAMAccountName")
    EndIf

    If StringIsDigit($iString) Then
        consolewrite("employeeid identified" @crlf)
        $aObjects = _AD_GetObjectsInOU("OU=People,DC=user,DC=company,DC=com", "(employeeID=" & $iString & ")", 2, "sAMAccountName")
    EndIf

    If $aObjects = @error Then
        Return SetError(1)
    EndIf

    $sam_account = $aObjects[1]

    Return $sam_account

EndFunc   ;==>Get_SamAccountNameY

 

Edited April 1 by gcue
Additional testing + results

[donnyh13]

Not able to test right now, but I wonder if using Regexp would quicken things a bit for the employee ID? If i understand correctly, converting strings to numbers or testing strings if they are numbers does cause a slight delay?

For the ID you could do... 

 If Not StringRegExp($iString, "[^0-9]") Then

(If $iString doesn't contain anything other than digits, Then.)

Edit: I think i may have misunderstood where you think the problem is. Sorry. Please disregard.

Edited April 1 by donnyh13

[water]

As you can see here property "proxyaddresses" is an indexed property and "employeeID" is not.
Hence the difference in processing time.
If needed you can add property "employeeID" to the list of indexed properties.

[gcue]

makes sense. 

found _AD_GetSchemaAttributes(3) - thanks for providing this

dont see a function on the udf that provides the ability to index properties locally. i take it my only option to ask our domain team to index?

 

 

Edited April 1 by gcue

[water]

Or you create a script that runs daily/weekly/... at nighttime to extract imployeeID and SamAccountName of all users and store this information in a text file or database for faster access.

[gcue]

Sounds good thanks water! Hope you have a great rest of the week

[water]

Hi gcue,

I will. My vacation starts on Friday