<div>
Give adfind a try<br />
<br />
<a href="http://www.joeware.net/freetools/tools/adfind/index.htm" rel="ugc">http://www.joeware.net/freetools/tools/adfind/index.htm</a><br />
<br />
adfind -default -f &quot;&amp;(objectcategory=person)(<wbr />objectclas<wbr />s=user)&quot; samaccountname displayname department telephonenumber pager mobile &nbsp;-csv &gt;&nbsp;c:\users.csv<br />
<br />
So there I only outputted a few attributes, &nbsp;you can output any attributes you want. &nbsp;Good list of the actual attribute names here <br />
<br />
<a href="http://www.selfadsi.org/user-attributes-w2k3.htm" rel="ugc">http://www.selfadsi.org/user-attributes-w2k3.htm</a><br />
<br />
Thanks<br />
<br />
Mike
</div>


Give adfind a try

http://www.joeware.net/freetools/tools/adfind/index.htm [http://www.joeware.net/freetools/tools/adfind/index.htm]

adfind -default -f "&(objectcategory=person)(objectclass=user)" samaccountname displayname department telephonenumber pager mobile  -csv > c:\users.csv

So there I only outputted a few attributes,  you can output any attributes you want.  Good list of the actual attribute names here

http://www.selfadsi.org/user-attributes-w2k3.htm [http://www.selfadsi.org/user-attributes-w2k3.htm]

Thanks

Mike

<div>
<div class="content wysiwyg-content">
Anyone have a script to query data from AD 2003 into a CSV/XLS/TXT ?<br />
<br />
I only need data from these fields:<br />
1. logon id<br />
2. display name<br />
3. dept<br />
4. telephone no<br />
5. pager <br />
6. mobile
</div>
</div>


Anyone have a script to query data from AD 2003 into a CSV/XLS/TXT ?

I only need data from these fields:
1. logon id
2. display name
3. dept
4. telephone no
5. pager 
6. mobile

Query AD 2003 data into a file

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.