export a list of all users including the value of the "pager" field

Hi everyone,

I want to export a list of all users including the value of the "pager"
field, so that I can edit it with Excel for example.
Does anyone know how to? Ithink it can be done with an LDAP query?

Many thanks,
Remco.

Richard
Tue Mar 25 19:04:33 PDT 2008

Remco wrote:

> I want to export a list of all users including the value of the "pager"
> field, so that I can edit it with Excel for example.
> Does anyone know how to? Ithink it can be done with an LDAP query?

You can use ADO in a VBScript program to retrieve the sAMAccountName and
pager attributes of all users. sAMAccountName is the NT names of the users,
also called the "pre-Windows 2000 logon name". You could retrieve
distinguishedName instead. For info on using ADO see this link:

http://www.rlmueller.net/ADOSearchTips.htm

You can also use Joe Richards' adfind command line tool. Your filter would
be:

(&(objectCategory=person)(objectClass=user))

Your list of attributes would be:

sAMAccountName,pager

If you output the values in one comma delimited line per user you can import
into Excel.

--
Richard Mueller
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
--

Ken
Fri Mar 28 08:33:12 PDT 2008

Hello,

If you want to try a solution that does not involve scripting you could look
at DSRAZOR for Windows to generate your report.
DSRAZOR can list all users and the attributes you want to report on for each
user. You could export this to a CSV and modify it in Excel. Also, once
you're done modifying it in Excel you can import the information back into
Active Directory to update the users.
There is a simpler way, though. DSRAZOR provides a way to easily update
attributes for users. You could generate a simple report that lists all
users and their pager numbers. Then you could select a user (or multiple
users), press a button, enter in the new pager number, press OK, and it will
update the pager number on any selected user(s). DSRAZOR can do this with
most attributes. While this solution may be easier than other scripted
solutions offered here, it is not free, you have to buy the product.

--
Ken Aldrich
DSRAZOR for Windows
Visual Click Software, Inc.
www.visualclick.com

"Remco" <veralloinjamaica@hotmail.com> wrote in message
news:a5a8b$47e93992$541f1cbd$18130@cache2.tilbu1.nb.home.nl...
>
> Hi everyone,
>
> I want to export a list of all users including the value of the "pager"
> field, so that I can edit it with Excel for example.
> Does anyone know how to? Ithink it can be done with an LDAP query?
>
> Many thanks,
> Remco.
>