If the user is disabled, I want to export them as a single line. I won't export enabled users and starting with S-1-5-21-.
e.g : CONTOSO\user11 , CONTOSO\user53 and CONTOSO\user32 are disabled.
My input file:
Permissions
CONTOSO\user11;CONTOSO\user23;CONTOSO\user53;S-1-5-21-609545082-2795152396-2074981628-14751
CONTOSO\user32;CONTOSO\user236
My desired output:
CONTOSO\user11;CONTOSO\user53
CONTOSO\user32
I have single column called 'permissions'.
Currently I am getting an console output like below. it works
https://i.stack.imgur.com/uf86v.jpg
My desired output:
If the user is disabled, I want to export them as a single line.
https://i.stack.imgur.com/CRCsl.jpg
Script :
$userList = (Import-Csv -Path C:\temp\test.csv).permissions -split ';'
foreach ($user in $userList) {
$adUser = $user -replace '.*\\' | Get-ADUser -ErrorAction SilentlyContinue -Property enabled
[PSCustomObject]@{
Identity = $user
Status = switch ($adUser) {
{ -not $_ } {
'deleted'
continue
}
{ $_.Enabled } {
'enabled'
continue
}
default {
'disabled'
}
}
}
}
EDIT :
My input file:
Permissions
CONTOSO\user11;CONTOSO\user23;CONTOSO\user53;S-1-5-21-609545082-2795152396-2074981628-14751
CONTOSO\user32;CONTOSO\user236
My desired output:
CONTOSO\user11;CONTOSO\user53
CONTOSO\user32
theo script output:
CONTOSO\user11;CONTOSO\user53;CONTOSO\user32
EDIT2:
user32 , user45 , user200 are enabled
CONTOSO\user11;CONTOSO\user53
CONTOSO\user32
CONTOSO\user45;CONTOSO\user200
CONTOSO\user43;CONTOSO\user99
My desired output:
CONTOSO\user11;CONTOSO\user53
<-- blank line
<-- blank line
CONTOSO\user43;CONTOSO\user99
EDIT 3 :
user01 , user02 : enabled user03 : disabled
Permissions
CONTOSO\user01
CONTOSO\user02
CONTOSO\user03
4 blank line is coming instead of 2 blank line
<-- blank line
<-- blank line
<-- blank line
<-- blank line
CONTOSO\user03