Explanation of one script

Hi,

I have one script (from my collegue) where is stored:

(memberof=CN=XXX,OU=YYYY,OU=ZZZZZ,DC=server,D=local) -l

Can you please explain me what does mean
- CN
- OU
- OU in this script...

DC=server,D=local means local domain name

Thnx

Minx
Tue Aug 05 10:12:41 PDT 2008

"Minx" <minx@mymail.com> wrote in message
news:ulYM4Wx9IHA.3480@TK2MSFTNGP03.phx.gbl...

And another thing - I need to add separator which will exclude users from
specific Department (field in AD) - which command should I use?

Thnx

Marcin
Tue Aug 05 11:37:09 PDT 2008

Minx,
refer to
http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/distrib/dsbb_act_kjpw.mspx?mfr=true

hth
Marcin

"Minx" <minx@mymail.com> wrote in message
news:ulYM4Wx9IHA.3480@TK2MSFTNGP03.phx.gbl...
> Hi,
>
> I have one script (from my collegue) where is stored:
>
> (memberof=CN=XXX,OU=YYYY,OU=ZZZZZ,DC=server,D=local) -l
>
> Can you please explain me what does mean
> - CN
> - OU
> - OU in this script...
>
> DC=server,D=local means local domain name
>
> Thnx
>

Minx
Tue Aug 05 13:11:53 PDT 2008

"Marcin" <marcin@community.nospam> wrote in message
news:unxXMpy9IHA.4952@TK2MSFTNGP03.phx.gbl...
> Minx,
> refer to
> http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/distrib/dsbb_act_kjpw.mspx?mfr=true
>
> hth
> Marcin


Thank you very much for this useful link. Figure 1.10 very detailed
describes my question.

Well, can you please check my second post under the same thread: how to make
script which can include/exclude users from specific field in AD -
"Department".

Thnx.

Marcin
Tue Aug 05 13:48:04 PDT 2008

That woud depend to large extent on the logic and format of the script you
are using...
Do you want to post it content?

Marcin

"Minx" <minx@mymail.com> wrote in message
news:OOm0Cez9IHA.3544@TK2MSFTNGP06.phx.gbl...
> "Marcin" <marcin@community.nospam> wrote in message
> news:unxXMpy9IHA.4952@TK2MSFTNGP03.phx.gbl...
>> Minx,
>> refer to
>> http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/distrib/dsbb_act_kjpw.mspx?mfr=true
>>
>> hth
>> Marcin
>
>
> Thank you very much for this useful link. Figure 1.10 very detailed
> describes my question.
>
> Well, can you please check my second post under the same thread: how to
> make script which can include/exclude users from specific field in AD -
> "Department".
>
> Thnx.
>

Minx
Tue Aug 05 14:19:26 PDT 2008

"Marcin" <marcin@community.nospam> wrote in message
news:eJwcWyz9IHA.2064@TK2MSFTNGP02.phx.gbl...
> That woud depend to large extent on the logic and format of the script you
> are using...
> Do you want to post it content?
>
> Marcin


Here is curently script which is very useful for my current wishes. But, I'd
like to add just one more detail there, and it is field "Department" from
AD...

@echo off
echo TEXT
csvde -s domain.local -f export.csv -r
(memberof=CN=XXXX,OU=YYYY,OU=ZZZZ,DC=domain,DC=local) -l
mailnickname,samaccountname,mail,displayname,msexchhomeservername -u

Thnx..

Marcin
Wed Aug 06 07:20:52 PDT 2008

if you want to exclude members of a particular department from the export,
use the following in your filter string
"(&(memberOf=...)(!(Department="enter name of the department here")))

hth
Marcin

"Minx" <minx@mymail.com> wrote in message
news:OqtWyD09IHA.5756@TK2MSFTNGP05.phx.gbl...
> "Marcin" <marcin@community.nospam> wrote in message
> news:eJwcWyz9IHA.2064@TK2MSFTNGP02.phx.gbl...
>> That woud depend to large extent on the logic and format of the script
>> you are using...
>> Do you want to post it content?
>>
>> Marcin
>
>
> Here is curently script which is very useful for my current wishes. But,
> I'd like to add just one more detail there, and it is field "Department"
> from AD...
>
> @echo off
> echo TEXT
> csvde -s domain.local -f export.csv -r
> (memberof=CN=XXXX,OU=YYYY,OU=ZZZZ,DC=domain,DC=local) -l
> mailnickname,samaccountname,mail,displayname,msexchhomeservername -u
>
> Thnx..
>

Minx
Wed Aug 06 10:21:51 PDT 2008

"Marcin" <marcin@community.nospam> wrote in message
news:erkas%2389IHA.2064@TK2MSFTNGP02.phx.gbl...
> if you want to exclude members of a particular department from the export,
> use the following in your filter string
> "(&(memberOf=...)(!(Department="enter name of the department here")))
>

Hi Marcin,

please advice more details because I'm not able to get useful information
from script.

Well, once again, here is my currently scrpit (that script made my friend):


@echo off
csvde -s domain.local -f export.csv -r
(memberof=CN=SOMETHING,OU=SOMETHING,OU=SOMETHING,DC=DOMAIN,DC=LOCAL) -l
mailnickname,samaccountname,mail,displayname,msexchhomeservername -u
pause


That script works very well, but for a moment I need to add just one more
column called DEPARTMENT and then I'll sort it in Excel.
I've tried like
(&(memberof=CN=SOMETHING,OU=SOMETHING,OU=SOMETHING,DC=DOMAIN,DC=LOCAL)(Department=*))
but it doesnt work.

Please advice.

Thanks!!

Marcin
Thu Aug 07 04:33:19 PDT 2008

Here you go:

csvde -s domain.local -f export.csv
-r
"(&(memberof=CN=SOMETHING,OU=SOMETHING,OU=SOMETHING,DC=DOMAIN,DC=LOCAL)(Department="enter_department_name_here"))"
-l mailnickname,samaccountname,mail,displayname,msexchhomeservername -u

hth
Marcin

"Minx" <minx@mymail.com> wrote in message
news:eBsKsj%239IHA.3884@TK2MSFTNGP05.phx.gbl...
> "Marcin" <marcin@community.nospam> wrote in message
> news:erkas%2389IHA.2064@TK2MSFTNGP02.phx.gbl...
>> if you want to exclude members of a particular department from the
>> export, use the following in your filter string
>> "(&(memberOf=...)(!(Department="enter name of the department here")))
>>
>
> Hi Marcin,
>
> please advice more details because I'm not able to get useful information
> from script.
>
> Well, once again, here is my currently scrpit (that script made my
> friend):
>
>
> @echo off
> csvde -s domain.local -f export.csv -r
> (memberof=CN=SOMETHING,OU=SOMETHING,OU=SOMETHING,DC=DOMAIN,DC=LOCAL) -l
> mailnickname,samaccountname,mail,displayname,msexchhomeservername -u
> pause
>
>
> That script works very well, but for a moment I need to add just one more
> column called DEPARTMENT and then I'll sort it in Excel.
> I've tried like
> (&(memberof=CN=SOMETHING,OU=SOMETHING,OU=SOMETHING,DC=DOMAIN,DC=LOCAL)(Department=*))
> but it doesnt work.
>
> Please advice.
>
> Thanks!!
>

Minx
Thu Aug 07 12:24:06 PDT 2008

Marcin, MANY MANY THANKS!!!! it is working!



"Marcin" <marcin@community.nospam> wrote in message
news:e%23%23NyFI%23IHA.4156@TK2MSFTNGP02.phx.gbl...
> Here you go:
>
> csvde -s domain.local -f export.csv
> -r
> "(&(memberof=CN=SOMETHING,OU=SOMETHING,OU=SOMETHING,DC=DOMAIN,DC=LOCAL)(Department="enter_department_name_here"))"
> -l mailnickname,samaccountname,mail,displayname,msexchhomeservername -u
>