Mixing
List disabled AD account outside certain OU only and Export to .CSV
0
I need some assistance in modifying the script below to List any AD User account that is disabled outside of the specific OU.
$filter = '(Enabled -eq $false)'
$ResultDirectory = 'C:Disabled-ADAccountOutsideOU.csv'
$domainDN = (Get-ADDomain).DistinguishedName
$excludeOUs = @(
'OU=Site1,OU=Disabled Users'
'OU=Site2,OU=Disabled Users'
'OU=SiteX,OU=Disabled Users'
) | ForEach-Object { $_ + ',' + $domainDN }
Get-ADUser -Filter $filter -Properties * |
Where-Object { ($_.SamAccountName.Length -eq 7) -and ($excludeOUs -notcontains $_.ParentContainer) } |
Select-Object -Property SamAccountName, Enabled, @{n='ParentContainer';e={$_.DistinguishedName -replace 'A.*?,(?=(CN|OU|DC)=)'}}, CanonicalName, LastLogonDate |
Export-Csv -NoTypeInformation -Path $ResultDirectory
Because at the moment, the problem is the script is exporting some of the users accounts inside the OU=SiteX,OU=Disabled Users OU and nothing is exported or listed under the Default OU CN=Users,DC=Domain,DC=com where some of the Disabled AD account is there?
powershell scripting active-directory scripting-language
edited Nov 20 '18 at 8:56
Ansgar Wiechers
141k13125185
asked Nov 20 '18 at 3:38
Senior Systems EngineerSenior Systems Engineer
282818
add a comment |
0
I need some assistance in modifying the script below to List any AD User account that is disabled outside of the specific OU.
$filter = '(Enabled -eq $false)'
$ResultDirectory = 'C:Disabled-ADAccountOutsideOU.csv'
$domainDN = (Get-ADDomain).DistinguishedName
$excludeOUs = @(
'OU=Site1,OU=Disabled Users'
'OU=Site2,OU=Disabled Users'
'OU=SiteX,OU=Disabled Users'
) | ForEach-Object { $_ + ',' + $domainDN }
Get-ADUser -Filter $filter -Properties * |
Where-Object { ($_.SamAccountName.Length -eq 7) -and ($excludeOUs -notcontains $_.ParentContainer) } |
Select-Object -Property SamAccountName, Enabled, @{n='ParentContainer';e={$_.DistinguishedName -replace 'A.*?,(?=(CN|OU|DC)=)'}}, CanonicalName, LastLogonDate |
Export-Csv -NoTypeInformation -Path $ResultDirectory
Because at the moment, the problem is the script is exporting some of the users accounts inside the OU=SiteX,OU=Disabled Users OU and nothing is exported or listed under the Default OU CN=Users,DC=Domain,DC=com where some of the Disabled AD account is there?
powershell scripting active-directory scripting-language
edited Nov 20 '18 at 8:56
Ansgar Wiechers
141k13125185
asked Nov 20 '18 at 3:38
Senior Systems EngineerSenior Systems Engineer
282818
3
This is your problem "Select-Object -Property SamAccountname, Enabled" just add all the desired properties to this coma separated list
– BaronW
Nov 20 '18 at 3:46
Yes, you are right. that does the trick :-) Thanks Baron
– Senior Systems Engineer
Nov 20 '18 at 3:57
add a comment |
0
0
0
I need some assistance in modifying the script below to List any AD User account that is disabled outside of the specific OU.
$filter = '(Enabled -eq $false)'
$ResultDirectory = 'C:Disabled-ADAccountOutsideOU.csv'
$domainDN = (Get-ADDomain).DistinguishedName
$excludeOUs = @(
'OU=Site1,OU=Disabled Users'
'OU=Site2,OU=Disabled Users'
'OU=SiteX,OU=Disabled Users'
) | ForEach-Object { $_ + ',' + $domainDN }
Get-ADUser -Filter $filter -Properties * |
Where-Object { ($_.SamAccountName.Length -eq 7) -and ($excludeOUs -notcontains $_.ParentContainer) } |
Select-Object -Property SamAccountName, Enabled, @{n='ParentContainer';e={$_.DistinguishedName -replace 'A.*?,(?=(CN|OU|DC)=)'}}, CanonicalName, LastLogonDate |
Export-Csv -NoTypeInformation -Path $ResultDirectory
Because at the moment, the problem is the script is exporting some of the users accounts inside the OU=SiteX,OU=Disabled Users OU and nothing is exported or listed under the Default OU CN=Users,DC=Domain,DC=com where some of the Disabled AD account is there?
powershell scripting active-directory scripting-language
edited Nov 20 '18 at 8:56
Ansgar Wiechers
141k13125185
asked Nov 20 '18 at 3:38
Senior Systems EngineerSenior Systems Engineer
282818
I need some assistance in modifying the script below to List any AD User account that is disabled outside of the specific OU.
$filter = '(Enabled -eq $false)'
$ResultDirectory = 'C:Disabled-ADAccountOutsideOU.csv'
$domainDN = (Get-ADDomain).DistinguishedName
$excludeOUs = @(
'OU=Site1,OU=Disabled Users'
'OU=Site2,OU=Disabled Users'
'OU=SiteX,OU=Disabled Users'
) | ForEach-Object { $_ + ',' + $domainDN }
Get-ADUser -Filter $filter -Properties * |
Where-Object { ($_.SamAccountName.Length -eq 7) -and ($excludeOUs -notcontains $_.ParentContainer) } |
Select-Object -Property SamAccountName, Enabled, @{n='ParentContainer';e={$_.DistinguishedName -replace 'A.*?,(?=(CN|OU|DC)=)'}}, CanonicalName, LastLogonDate |
Export-Csv -NoTypeInformation -Path $ResultDirectory
Because at the moment, the problem is the script is exporting some of the users accounts inside the OU=SiteX,OU=Disabled Users OU and nothing is exported or listed under the Default OU CN=Users,DC=Domain,DC=com where some of the Disabled AD account is there?
powershell scripting active-directory scripting-language
powershell scripting active-directory scripting-language
edited Nov 20 '18 at 8:56
Ansgar Wiechers
141k13125185
asked Nov 20 '18 at 3:38
Senior Systems EngineerSenior Systems Engineer
282818
edited Nov 20 '18 at 8:56
Ansgar Wiechers
141k13125185
asked Nov 20 '18 at 3:38
Senior Systems EngineerSenior Systems Engineer
282818
edited Nov 20 '18 at 8:56
Ansgar Wiechers
141k13125185
edited Nov 20 '18 at 8:56
Ansgar Wiechers
141k13125185
edited Nov 20 '18 at 8:56
Ansgar Wiechers
141k13125185
141k13125185
asked Nov 20 '18 at 3:38
Senior Systems EngineerSenior Systems Engineer
282818
asked Nov 20 '18 at 3:38
Senior Systems EngineerSenior Systems Engineer
282818
asked Nov 20 '18 at 3:38
Senior Systems EngineerSenior Systems Engineer
282818
282818
3
This is your problem "Select-Object -Property SamAccountname, Enabled" just add all the desired properties to this coma separated list
– BaronW
Nov 20 '18 at 3:46
Yes, you are right. that does the trick :-) Thanks Baron
– Senior Systems Engineer
Nov 20 '18 at 3:57
add a comment |
3
This is your problem "Select-Object -Property SamAccountname, Enabled" just add all the desired properties to this coma separated list
– BaronW
Nov 20 '18 at 3:46
Yes, you are right. that does the trick :-) Thanks Baron
– Senior Systems Engineer
Nov 20 '18 at 3:57
3
3
This is your problem "Select-Object -Property SamAccountname, Enabled" just add all the desired properties to this coma separated list
– BaronW
Nov 20 '18 at 3:46
This is your problem "Select-Object -Property SamAccountname, Enabled" just add all the desired properties to this coma separated list
– BaronW
Nov 20 '18 at 3:46
Yes, you are right. that does the trick :-) Thanks Baron
– Senior Systems Engineer
Nov 20 '18 at 3:57
Yes, you are right. that does the trick :-) Thanks Baron
– Senior Systems Engineer
Nov 20 '18 at 3:57
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53385864%2flist-disabled-ad-account-outside-certain-ou-only-and-export-to-csv%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53385864%2flist-disabled-ad-account-outside-certain-ou-only-and-export-to-csv%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
3
This is your problem "Select-Object -Property SamAccountname, Enabled" just add all the desired properties to this coma separated list
– BaronW
Nov 20 '18 at 3:46
Yes, you are right. that does the trick :-) Thanks Baron
– Senior Systems Engineer
Nov 20 '18 at 3:57