Active Directory Powershell to fixed width txt file

Question

Trying to export 4 objects from Ad to a fixed-width txt file with no header.

I need the following columns to be the width that follows.

Employee ID    10 
Work Phone      10
Work Phone Extension    5
Work Email Address      50
User ID             20

The following gives me the best output, but doesn't size the columns the way I need. I have been digging around, and think what I need is a bit beyond what I'm comfortable with.

I'm not sure if i need to export with export-csv and then import that into reformat or if I can do out-file directly.

$DateTime = Get-Date -f "yyyyMMdd"

#// Set CSV file name
$CSVFile = "d:\scripts\workday\int002_"+$DateTime+".txt"

Get-ADGroup -Filter {(name -like "*Group Name*")} `
    | Get-ADGroupMember -Recursive | Where { $_.objectClass -eq "user" } `
    | Get-ADUser -properties * | where {$_.enabled -eq $true} `
    | select employeeid,telephoneNumber,mail,sAMAccountName  -unique | FT employeeid,telephoneNumber,mail,sAMAccountName -hidetableheaders -autosize | out-file $CSVFile

Sample Output:

8855      2122445710     [email protected]                 michalsenm

Please note that the edit UI has built-in formatting which you can use to fix the strange formatting the code has in this question. — user1531971
– user1531971, Commented Dec 18, 2018 at 18:18
What happened with the Work Phone Extension in your sample output? — user6811411
– user6811411, Commented Dec 18, 2018 at 18:44
Sorry, don't need the work phone extension extracted. I forgot to remove it from the exported information. — C. Powers
– C. Powers, Commented Dec 18, 2018 at 19:27
Why do you require fixed width output? Wouldn't a CSV output file be easier? — Bill_Stewart
– Bill_Stewart, Commented Dec 19, 2018 at 20:08

Palansen · Accepted Answer · 2018-12-19 19:16:59Z

3

You might need to do it manually...

$result = foreach($user in $users) {
    $user.employeeid.PadRight(10),
    $user.telephoneNumber.PadRight(10),
    $user.mail.PadRight(50),
    $user.sAMAccountName.PadRight(20) -join ' '
}

$result | Out-File $CSVFile

A revised version that also works if the property is not a string:

$result = foreach($user in $users) {
    '{0,-10}{1,-10}{2,-50}{3,-20}' -f
        $user.employeeid,
        $user.telephoneNumber,
        $user.mail,
        $user.sAMAccountName
}

$result | Out-File $CSVFile

edited Dec 19, 2018 at 19:16

answered Dec 18, 2018 at 18:34

Palansen

3112 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

user6811411 Over a year ago

Padding wouldn't shorten possibly too long entries, this requieres also a .Substring(0,width) and padding is IMO easier done with a -format operator for all properties. => "{0,10}{1,10}{2,5}{3,-50}{4,-20}" -f $user.employeeid, ...

Palansen Over a year ago

I'm not sure he wants it to be shortened. A shortened email is no good.

user6811411 Over a year ago

Well shortened to the width he provides, a fixed width record format broken seems even less usefull.

C. Powers Over a year ago

Shouldn't need anything shortened or truncated. Everything I output should fit in each column.

C. Powers Over a year ago

After looking, the PadRight may be all I need. Just need to play with the code to get it working properly. Currently it is outputting an empty file.

|

Collectives™ on Stack Overflow

Active Directory Powershell to fixed width txt file

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related