Re: CSDVE Query

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

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: CSDVE Query
    ... > ObjectClass is not indexed and will be slower. ... >> I was wondering if someone could help me out on a query on CSDVE. ... >> 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)
  • 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)
  • 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)
  • 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)