Poweshell query help

[FN-GM]

Hi,

 

Using the Quest cmdlets for powershell i would like to query users who have the attribute msExchHideFromAddressLists a "not set"

 

I use this code the find the users who have the option as true and it works.

 

get-aqduser - ldapfilter '(msExchHideFromAddressLists=TURE)

 

this doesnt work for not set

 

get-aqduser - ldapfilter '(msExchHideFromAddressLists=not set)

 

Does anyone know what i would need to put please?

 

Thanks

[DT2]

tried FALSE?

How's sunny Oz? Missing Rochdale much??

 

DT

[FN-GM]

Im back in Rochdale

 

False is a thrid option that can be set so wont work

[DT2]

EDIT: is a Null value - use * instead. Notes are always handy

 

Oh, sorry to hear that you heading back out to Oz? I'm migrating to Canada in a few weeks, another Rochdalian fleeing to better climes

Edited May 28, 2012 by DT2

[FN-GM]

I was under the impression that this was a boolean value...

 

Oh, sorry to hear that you heading back out to Oz? I'm migrating to Canada in a few weeks, another Rochdalian fleeing to better climes

 

I couldnt get a visa so im here for now

[DT2]

That's a poor do mate, sorry to hear that.

I had some family move out there, and they had a hard time of it with visas and jobs getting pulled from under them.

Canada is so much easier, it has to be said.

 

Darren

Edited May 28, 2012 by DT2

[Steve21]

Im back in Rochdale

 

False is a thrid option that can be set so wont work

 

Not exactly "pretty", but can't you do it like this:

 

(&(msExchHideFromAddressLists<>TRUE)(msExchHideFromAddressLists<>FALSE))

 

So it should only accept those who aren't true or false, aka "3rd option"

 

Steve

[FN-GM]

Not exactly "pretty", but can't you do it like this:

 

(&(msExchHideFromAddressLists<>TRUE)(msExchHideFromAddressLists<>FALSE))

 

So it should only accept those who aren't true or false, aka "3rd option"

 

Steve

 

invalid filter error

[DT2]

Apologies, with my edit it's probably been over looked: is a Null value - use * instead.

 

DT

[FN-GM]

Apologies, with my edit it's probably been over looked: is a Null value - use * instead.

 

DT

 

That gives the same results asif true was being used.

[DT2]

hmm.... what version of exchange are you running?

[FN-GM]

2010, isnt a * a wild card?

[DT2]

it's used to search for null values, being that.

 

(!msExchHideFromAddressLists=*)

 

the ldap filter to find null values is by negating ('!' is the equiv of 'not') a value of anything (e.g. '*')

 

Perhaps should read my notes fully and thoroughly

[FN-GM]

It errors out. Please see the attached.

 

Thanks

[DT2]

Failing that, try having a look at powergui.org, that's where some of my powershell notes are compiled from. Some very useful info there.

 

DT

[FN-GM]

(!(msExchHideFromAddressLists=*)) did the trick

 

Thanks for the help

[DT2]

Glad to help.

I shall add a new entry in my notes with this variation

 

Darren