<div>
Hi<br />
Try the sort.<br />
C:\&gt; dsquery user -limit 0 &quot;OU=XXX,DC=XX,DC=XXX&quot; | sort | dsget user -ln -fn -mi -c
</div>


Hi
Try the sort.
C:\> dsquery user -limit 0 "OU=XXX,DC=XX,DC=XXX" | sort | dsget user -ln -fn -mi -c

<div>
That worked, Thanks.<br />
<br />
Do you know if it would also output this way.<br />
<br />
LASTNAME, FIRSTNAME MI<br />
<br />
All in one cell with the comma after the lastname.
</div>


That worked, Thanks.

Do you know if it would also output this way.

LASTNAME, FIRSTNAME MI

All in one cell with the comma after the lastname.

<div>
interesting followup &nbsp;not sure, you can add an extra comma<br />
<br />
adfind -b &quot;OU=xxx,dc=xxx,dc=xxx&quot; -f &nbsp;&quot;&amp;(objectcategory=person)(<wbr />objectclas<wbr />s=user)&quot; &nbsp;sn %,% givenname initials -csv -nodn &gt;&nbsp;c:\users.csv <br />
&nbsp;...but I'm not sure about all in one cell<br />

</div>


interesting followup  not sure, you can add an extra comma

adfind -b "OU=xxx,dc=xxx,dc=xxx" -f  "&(objectcategory=person)(objectclass=user)"  sn %,% givenname initials -csv -nodn > c:\users.csv
 ...but I'm not sure about all in one cell


<div>
All it did was create a %,% column.
</div>


<div>
<div class="content wysiwyg-content">
I need a script that will output in a xls file the -LN, -FN -MI<br />
<br />
I am using this but it will not output -LN, -FN -MI<br />
<br />
C:\&gt; dsquery user -limit 0 &quot;OU=XXX,DC=XX,DC=XXX&quot; | dsget user -ln -fn -mi -c<br />
<br />
It outputs -FN -MI -LN, How do I get it in the order that I need it in?
</div>
</div>


I need a script that will output in a xls file the -LN, -FN -MI

I am using this but it will not output -LN, -FN -MI

C:\> dsquery user -limit 0 "OU=XXX,DC=XX,DC=XXX" | dsget user -ln -fn -mi -c

It outputs -FN -MI -LN, How do I get it in the order that I need it in?

Dsquery User | Dsget User

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.

Windows Batch

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.