Re: CSDVE Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Al,

As you suggested I used objectCategory=Person and -r
"(&(objectCategory=Person)(telephonenumber=*))" and it gave me the exact list
that I wanted!

Many Thanks,
Dales

"Al Mulnick" wrote:

> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnactdir/html/efficientadapps.asp
>
> ObjectClass is not indexed and will be slower. Using a not operator will
> also be slower, but might be the way to do this.
>
> Use -r objectCategory=Person to get user objects.
>
> Since you know that you only want objects that have telephone numbers (this
> is a phone book) you *could* modify that a bit.
>
> -r (&(objectCategory=Person)(telephonenumber=*)) to narrow it a bit. To
> make it better you *could* also index the telephonenumber attribute if
> needed.
> Unless you've marked the administrator accounts, there's no way I can think
> of to efficiently remove them. You may have to come up with a way in your
> environment that works for you. Or just remove their telephone number from
> the directory?
>
> Let us know if that helps. I know there are also some examples of queries
> out on the web that would help out as well.
>
> Al
>
>
> "Dales" <Dales@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:7A9146CF-1B88-422F-B70C-6842C692959B@xxxxxxxxxxxxxxxx
> > Hi,
> > I was wondering if someone could help me out on a query on CSDVE. I am
> > using
> > CSDVE to create a phone list of all users in the AD.
> >
> > I want to get a list of all users (not computers or Admin users) .
> >
> > I can use the below command to list all users - but it returns all admin
> > users and other logins that i dont want :
> >
> > "CSVDE -d " DC=mydomain,dc=org" -r objectClass=user -l
> > "givenname,telephoneNumber,department" -f adRawFile1.csv"
> >
> > So I thought that i could just list the departments(OUs) that i want users
> > from e.g.
> >
> > "CSVDE -d "OU=HR, OU=Finance, DC=mydomain,dc=org" -r objectclass=user -l
> > "givenname,telephoneNumber,department" -f adRawFile1.csv"
> >
> > ...but it doesnt work when i include more than one OU in the command!
> >
> > Q. Does anyone know how to list more than one OU in a CSVDE command?
> > or
> > Q. Is it possible to exclude objectclass that i dont want e.g.
> > objectclass!=computer?
> >
> > Thanks,
> >
> >
> >
>
>
>
.

Relevant Pages

  • Re: Using LDIFDE to Import and Export Groups
    ... The log file sometimes gives a better clue on where the script is failing. ... >>> I have been able to export the groups in my domain using this command: ... >> The attributes groupType and sAMAccountName are mandatory for group>> objects. ... >> objectClass, cn, sAMAccountName, and groupType. ...
    (microsoft.public.win2000.active_directory)
  • Re: LDAP be killing me. I need a good step by step
    ... Just a really good tried and true website reference for setting up ldap. ... I have a file of names, phone numbers, etc. that has the following format that is used at my work: ... #Here it checks if there are 3 command line arguments. ... #objectclass: organization ...
    (Fedora)
  • Re: CSDVE Query
    ... ObjectClass is not indexed and will be slower. ... > I can use the below command to list all users - but it returns all admin ... > Q. Is it possible to exclude objectclass that i dont want e.g. ...
    (microsoft.public.windows.server.active_directory)
  • CSDVE Query
    ... I was wondering if someone could help me out on a query on CSDVE. ... I want to get a list of all users (not computers or Admin users). ... I can use the below command to list all users - but it returns all admin ... Q. Is it possible to exclude objectclass that i dont want e.g. ...
    (microsoft.public.windows.server.active_directory)
  • Adding IF statement to custom function (VBA)?
    ... I have a custom function I created here in VBA and I need to add some ... ObjectClass, ObjectCat) As String ... Dim CycleNumber As Integer ... Ive tried adding it in with my own knowledge, but I dont know how to do ...
    (microsoft.public.excel.programming)