Need to produce a pretty report on all disabled users and their OU
- From: "Spin" <Spin@xxxxxxxx>
- Date: Mon, 19 Sep 2005 01:59:07 -0400
Gurus,
What I need is a script which will query my Windows Server 2003 AD for all
disabled users and I need it to tell me what OU they are in. So basically I
need two easy columns as shown below.
Account Name OU Name
Per a previous post I can output this info, using "dsquery user -disabled".
But, it returns the CN of the user as part of the complete ADSI path. So
the output looks like:
CN=Doe\, John,OU=Sales,DC=Domain,DC=COM
I can't get Excel to break the above single-line result into two columns.
Reason is their is no semi-colon separator. Example, as above, after John
there is a comma, right before OU. I really need that to be a semi-colon as
I can then easily tell Excel to use that as the column break. What I am
looking for is output like:
John.Doe Sales
Management will read this report. Is this clear as mud? :-)
.
- Follow-Ups:
- Prev by Date: Re: FRS nto Stable [WP]
- Next by Date: Re: creating domain and isa server
- Previous by thread: Re: Windows 2003 Domain Controller
- Next by thread: Re: Need to produce a pretty report on all disabled users and their OU
- Index(es):
Relevant Pages
|
