Active Directory Query returning empty fields where it shouldn't

Question

I've been facing this problem and it doeen't seems to have an end, hope you can help me.

I'm making an LDAP query against Active Directory within a Powershell script. Getting right to the point this is my code:

$objDomain = New-Object System.DirectoryServices.DirectoryEntry("LDAP://OU=ivegotusers,DC=global,DC=foo,DC=com")

$objSearcher = New-Object System.DirectoryServices.DirectorySearcher
$objSearcher.SearchRoot = $objDomain
$objSearcher.PageSize = 1000
$objSearcher.Filter = $strFilter
$objSearcher.SearchScope = "Subtree"

#Write-Host $objSearcher

$colProplist = "name", "sn", "whenCreated", "whenChanged", "createTimeStamp", "modifyTimeStamp", "displayName", "mailNickName"
foreach ($i in $colPropList){
    $objSearcher.PropertiesToLoad.Add($i)
}

$colResults = $objSearcher.FindAll()

foreach ($objResult in $colResults){
    $objItem = $objResult.Properties;
    Write-Host -NoNewLine $objItem.name
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem.displayName;
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem.sn;
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem.whenCreated;
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem.createTimeStamp;
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem.whenChanged;
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem.modifyTimeStamp;
    Write-Host "|";
}

I've checked the data in the ADSI Edit and a lot of users had that data; nevertheless, the output was

name1||sn1||||
name2||sn2||||
name3||sn3||||
name4||sn4||||
name5||sn5||||

for those same users, and there's not a single line that has more than these two fields seted.

Can anyone help me figuring out what's happening in here?

Note: Due to server set-ups, I'm not able to use the ActiveDirectory import on Powershell.

Regards and thanks for your time! Vlad

serialhobbyist · Accepted Answer · 2013-05-05 07:44:18Z

1

I got bitten by this one a while ago: you've got two choices:

propertyNames in lower case:

foreach ($objResult in $colResults){
    $objItem = $objResult.Properties;
    Write-Host -NoNewLine $objItem.name
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem.displayname
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem.sn;
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem.whencreated;
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem.createtimestamp;
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem.whenchanged;
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem.modifytimestamp;
    Write-Host "|";
}

or use the .NET collection Item property style syntax:

foreach ($objResult in $colResults){
    $objItem = $objResult.Properties;
    Write-Host -NoNewLine $objItem.name
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem["displayName"]
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem.sn;
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem["whenCreated"];
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem["createTimeStamp"];
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem["whenChanged"];
    Write-Host -NoNewLine "|";
    Write-Host -NoNewLine $objItem["modifyTimeStamp"];
    Write-Host "|";
}

answered May 5, 2013 at 7:44

serialhobbyist

4,8375 gold badges45 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vladimir Over a year ago

Can't believe it worked! Just the all-lower-case properties names did the trick. And of course, I'm now wondering how I managed not to try this before myself. Thank you very much!

Collectives™ on Stack Overflow

Active Directory Query returning empty fields where it shouldn't

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related