我只想獲取以 nby 開頭的地址。
我有如下用戶的代理地址。
sAMAccountName,ProxyAddresses
user01,SMTP:user01@domainA.com;smtp:user01@domainA.com;smtp:nby24048@domainA.com
user02,SMTP:user02@domainA.com;smtp:user02@domainA.com;smtp:nby44048@domainA.com
....
so on
腳本 :
Get-Content "C:\Scripts\employeelist.txt" |
ForEach-Object { Get-ADUser -LDAPFilter "(mail=$_)" -Properties * } |
Select-Object sAMAccountName,mail,@{L = "ProxyAddresses"; E = { ($_.ProxyAddresses -match '^smtp:') -join ";"}} |
Export-Csv "C:\Scripts\users-output.csv" -NoTypeInformation
我想要的輸出:
sAMAccountName,ProxyAddresses
user01,[email protected]
user02,[email protected]
....
so on
uj5u.com熱心網友回復:
假設您的輸入文本檔案在單獨的行中包含電子郵件地址,您可以這樣做:
# the Where-Object is just to make sure you don't read in blank lines
Get-Content -Path "C:\Scripts\employeelist.txt" | Where-Object { $_ -match '\S' } | ForEach-Object {
Get-ADUser -LDAPFilter "(mail=$_)" -Properties ProxyAddresses |
Select-Object SamAccountName,
@{Name = "ProxyAddresses"; Expression = { ($_.ProxyAddresses -match '^smtp:nby. ') -join ";"}}
} | Export-Csv "C:\Scripts\users-output.csv" -NoTypeInformation
-Properties *PS如果您只想要一些 Get-ADUser 尚未提供的額外屬性,請不要使用。
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/518211.html
標籤:电源外壳
