Some automated process has thrown a single space character into the
displayName and I'm hoping to construct a simple DSQUERY to find them
and then fix them.
Yes, the workaround you describe is pretty much what I am doing in lieu
of a DSQUERY filter. It's just a pain because there are over 100,000
user accounts. I am dumping the values to a temp file, then querying it
in a secondary process.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Mark Parris
Sent: Tuesday, February 07, 2006 11:57 AM
To: ActiveDir.org
Subject: Re: [ActiveDir] DSQUERY filter for space character only
What's the query for? Can you not query on all objects then export to
excel or word and look for the spaces? Crude but it should work.
Mark
-----Original Message-----
From: Sitton Glen E <[EMAIL PROTECTED]>
Date: Tue, 7 Feb 2006 11:16:53
To:[email protected]
Subject: [ActiveDir] DSQUERY filter for space character only
I need to run an obscure DSQUERY with a filter that finds displayNames
with a value of a single space character. I'm stumped. I've tried
every escape character possibility that I'm aware of. I know how to
find null values, but can't seem to query on a space character alone.
It hoses the ldap syntax.
When ADUC builds the ldap query itself, it fails:
(&(objectCategory=user)(displayName= ))
The query filter ... is not a valid query string.
I've tried:
" "
' '
%20
+
and escaping it with a \ or a ^
Any ideas?
Thanks in advance,
- Glen
List info : http://www.activedir.org/List.aspx
List FAQ : http://www.activedir.org/ListFAQ.aspx
List archive:
http://www.mail-archive.com/activedir%40mail.activedir.org/
