Need to correct this AD script

Question

Hi,

I make this script. This script counts how many users have each OU into the two Principal OU's ( RDS Funcional and VDI Funcional). The script works fine but i need to remove the total count of this two principals OU's. In the Image wants to remove the line RDS Funcional,"723". There an other line with this VDI Funcional,"295"

I need to remove both lines

Also remove the double quotes

Exemple in the image This line is fine -> 4127 Transportes Corporativos,16

Thanks :)

Script:

 $log = @()  
          "OU=RDS Funcional,DC=esofitec,DC=loc","OU=VDI Funcional,DC=esofitec,DC=loc" | ForEach-Object {  
              Get-ADOrganizationalUnit -Filter * -SearchBase $_ | ForEach-Object {  
                  $log += "Processsing {0}" -f $_.distinguishedname     
                 [array] $users = Get-ADUser -Filter "Name -notlike 'test*' -and Name -notlike 'adm*'" -SearchBase $_.distinguishedname  
                  if ($users -ne $null) {  
                      $log += "{0} has {1}" -f $users.name, $users.count  
                      [PSCustomObject]@{  
                          OU    = $_.name  
                          Users = "{0}" -f $users.count  
                      }  
                   }  
              }  
          } | Export-Csv -Path c:\\ExportUsers.csv -NoTypeInformation -Delimiter ','  
          $log  

Example in an Image:

Answer 1

Does this fix your script?

$log = @()
"OU=RDS Funcional,DC=esofitec,DC=loc", "OU=VDI Funcional,DC=esofitec,DC=loc" | 
    ForEach-Object {
         $baseou = $_
        Get-ADOrganizationalUnit -Filter * -SearchBase $_ | 
            ForEach-Object {
                if ($_.distinguishedname -ne $baseou){
                    $log += "Processsing {0}" -f $_.distinguishedname   
                    [array] $users = Get-ADUser -Filter "Name -notlike 'test*' -and Name -notlike 'adm*'" -SearchBase $_.distinguishedname -SearchScope OneLevel
                    if ($users -ne $null) {
                        $log += "{0} has {1}" -f $_.name, $users.count
                        [PSCustomObject]@{
                            OU    = $_.name
                            Users = $users.count
                        }
                    }
                }
            }
    } | Export-Csv -Path c:\\ExportUsers.csv -NoTypeInformation -Delimiter ','
$log

EDIT: Move Export-CSV cmdlet.

Answer 2

Hi RichMatheisen-8856 ,

In your Fix, runs well but only counts the OU "VDI Funcional", the other OU "RDS Funcional" didn't appear.

Can you fix both principal OU's?

Thanks!

Best.

Answer 3

Hi Rich!!

Works fine :)

Thank you very much :)

Best!