Powershell script ignoring filter

Question

I'm using the following one-liner to get a list of users who aren't disabled, and whose accounts expire, with some properties:

Get-ADUser -Filter {(Enabled -eq $true) -and (accountExpires -ne 0)} -Properties name, mail, c, physicalDeliveryOfficeName, telephoneNumber, manager, title, description | select-object name, mail, c, physicalDeliveryOfficeName, telephoneNumber, manager, title, description

It works, except it grabs everyone in my domain, not just the ones whose accounts expire as indicated. Why is it ignoring the accountExpires portion of the script?

BartekB · Accepted Answer · 2013-02-25 22:10:19Z

2

The reason for wrong result is your wrong assumption, that every not-expiring account has value 0 in accountExpires attribute. In my tests that applied only to Administrator. Every other account had [int64]::MaxValue there - so you need to include this in your filter:

$Max = [int64]::MaxValue
Get-ADUser -Filter {
    (Enabled -eq $true) -and 
    (accountExpires -ne 0) -and 
    (accountExpires -ne $Max)
}

answered Feb 25, 2013 at 22:10

BartekB

8,71034 silver badges33 bronze badges

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

2 Comments

Pickle Over a year ago

Thanks, except this grabs all of the accounts that do expire; the opposite of what I want. Is there a way to reverse this?

BartekB Over a year ago

Reversing it should be easy by reversing logic of the filter ...) -and ((acountExpires -eq 0) -or (accountExpires -eq $Max))

Collectives™ on Stack Overflow

Powershell script ignoring filter

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related