Export Usernames and Email Addresses

Hello,

I am trying to export usernames and email addresses from a
particular user group in Active Directory. I can export
users from the group using the NET GROUP command in DOS but
that doesn't include email addresses. Do I have to use a
LDAP query or is there an easier way to do it?

Many Thanks!!

Dave

"Dave B" <dbenivegna@sargentlock.com> wrote in message
news:125d01c50f8b$3413f0c0$3a01280a@phx.gbl...
> Hello,
>
> I am trying to export usernames and email addresses from a
> particular user group in Active Directory. I can export
> users from the group using the NET GROUP command in DOS but
> that doesn't include email addresses. Do I have to use a
> LDAP query or is there an easier way to do it?

Well in some sense yes but you can probably use the Win2003
DSGet command -- it is far more capable than the Net commands.

DSGet user /?

( -email = address seems promising)

You may also need to combine this with a preliminary DSQuery User
to get all of the User names for processing by DSGet.

I.E., DSQuery finds the users, DSGet displays the attributs for a
particular (set of) user(s).

DSQuery user /?

You can also look into the ADSI ScriptOMatic by searching
Microsoft for it....

Google: [ site:microsoft.com ADSI ScriptOMatic ]

(It helps (non-) programmers write useful scripts.)

On Thu, 10 Feb 2005 08:11:39 -0800, "Dave B" <dbenivegna@sargentlock.com> wrote:

>Hello,
>
>I am trying to export usernames and email addresses from a
>particular user group in Active Directory. I can export
>users from the group using the NET GROUP command in DOS but
>that doesn't include email addresses. Do I have to use a
>LDAP query or is there an easier way to do it?
>
>Many Thanks!!
>
>Dave


DSQUERY / DSGET from the Active Directory command-line tools. See tip 6820 in the 'Tips & Tricks' at http://www.jsiinc.com

See tip 7714.

Type the following at a CMD.EXE window for an example:
dsquery group -name "Domain Admins"|dsget group -members|dsget user -samid -email -display

Jerold Schulman
Windows Server MVP
JSI, Inc.
http://www.jsiinc.com

On Thu, 10 Feb 2005 08:11:39 -0800, "Dave B" <dbenivegna@sargentlock.com> wrote:

>Hello,
>
>I am trying to export usernames and email addresses from a
>particular user group in Active Directory. I can export
>users from the group using the NET GROUP command in DOS but
>that doesn't include email addresses. Do I have to use a
>LDAP query or is there an easier way to do it?
>
>Many Thanks!!
>
>Dave


Run the following, since your groups contain contacts:

@echo off
if {%1}=={} @echo Syntax: GGME Group&goto :EOF
setlocal ENABLEDELAYEDEXPANSION
set grp=%1
set grp=%grp:"=%
for /f "Tokens=*" %%a in ('dsquery group -name "%grp%"') do (
if %%a NEQ "" for /f "Tokens=*" %%x in ('dsget group %%a -samid^|Findstr /V /L /C:"dsget succeeded"') do set gdn=%%x#
set gdn=!gdn: #=!
if %%a NEQ "" for /f "Tokens=*" %%b in ('dsget group %%a -members -expand') do (
set user=%%b
set user=!user:"=!
set ok=N
set dn=
set mail=
if %%b GTR " " for /f "Tokens=1*" %%c in ('dsquery * domainroot -filter "(&(objectCategory=Person)(objectClass=User)(distinguishedName=!user!))" -attr displayName mail -L -LIMIT 0') do (
if /i "%%c" EQU "displayName:" set dn=%%d&set ok=Y
if /i "%%c" EQU "mail:" set mail=%%d
)
if "!ok!" EQU "Y" if "!dn!" NEQ "" @echo "!gdn!" "!dn!" "!mail!"
)
)
endlocal
goto :EOF


Jerold Schulman
Windows Server MVP
JSI, Inc.
http://www.jsiinc.com