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, 2024 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

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

Edited March 13 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, 2024 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