PowerShell to look up details between 2 user accounts that are similarly named / contains same substring - using split & calculated property

ADuser.cross.lookup.ps1

<#

Nicholas Leader

10.03.2022

script to:

    pull AD accounts with a preceding 'a-', that are enabled

    using '-ResultPageSize 1000' to avoid an AD DC server side error message 'invalid enumeration context'

    using 'split' to return the normal user AD samaccount name and return the associated 'company' value on the normal user account

 

#>

 

#date stamp in string

$DateStamp = get-date -Format MM.dd.yyyy.mm

 

 get-aduser -filter {(samaccountname -like 'a-*') -and (enabled -eq "TRUE") } -properties company -ResultPageSize 1000 |

  select-object name,samaccountname, enabled,@{ name = 'NONaCompany'; expression = {(get-aduser -properties company ((get-aduser $_).samaccountname -split( "-"))[1]).company }} |

  export-csv -NoTypeInformation "a-report.$DateStamp.csv"

 

 

 

#example splitting of 'a-' account to return normal account

# ((get-aduser a-exampleUser).samaccountname -split( "-"))[1]