Windows/PowerShell Notes

Windows/PowerShell/AddCsvEmailToAdGroup

Load context

foreach($server in (get-content 'C:\Downloads\pilot_dev_servers.txt')){Get-ADComputer -Identity $server | select -ExpandProperty DistinguishedName}

Missing powershell commands

e.g. get-content missing, search https://docs.microsoft.com/en-us/powershell/module/Microsoft.PowerShell.Management/Get-Content?view=powershell-7
- its in Import-Module Microsoft.PowerShell.Management

Get info on a machine by id

#Powershell > import-module activedirectory
              Get-ADComputer -Identity "abcd" | select -ExpandProperty DistinguishedName

test tcp connectivity to port

PS C:\Users\Administrator> tnc 10.233.1.47 -port 443
ComputerName     : 10.23.1.47
RemoteAddress    : 10.23.1.47
RemotePort       : 443
InterfaceAlias   : Ethernet 2
SourceAddress    : 10.23.8.186
TcpTestSucceeded : True

Err

> Get-ADComputer -Identity "abcd" | select -ExpandProperty DistinguishedName
Get-ADComputer : The term 'Get-ADComputer' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:1 char:1

Reason missing admin module get-module -listavailable
Fix
- http://blog.technotesdesk.com/active-directory-module-and-cmdlet-missing-upon-patching
  - RSAT tool https://www.microsoft.com/en-us/download/details.aspx?id=45520
    - After install still got import error
```
> import-module activedirectory
WARNING: Error initializing default drive: 'Unable to find a default server with Active Directory Web Services
running.'.
```

PowerShell view user certificates

> Get-ChildItem -Path "Cert:\CurrentUser\My"


   PSParentPath: Microsoft.PowerShell.Security\Certificate::CurrentUser\My

Thumbprint                                Subject
----------                                -------
...

PowerShell windows update on remote computer

Have to do it through a job

ServerData = "<ServerName>"
invoke-WUJob -ComputerName $ServerData.Value -Script { Import-Module PSWindowsUpdate ; Install-WindowsUpdate -AcceptAll -SendReport -IgnoreReboot -PSWUSettings @{From='xy';Port=25;SmtpServer='xy';To='xy'} | Out-File C:\install\PSWindowsUpdateLog.txt -Append} -Confirm:$false -verbose -RunNow

PowerShell add admin user

net user mylocaladmin p@ssw0rd! /add /expires:never
net localgroup administrators mylocaladmin /add

PowerShell unlock user

 Set-LocalUser -name '<userid>' -PasswordNeverExpires $true

PowerShell reset user password e.g. Administrator

net user USERNAME NEWPASS

PowerShell update host file with dns entry

Add-Content -Path $env:windir\System32\drivers\etc\hosts -Value "`n127.0.0.1`tlocalhost" -Force
#

Scripts to manipulate host files https://github.com/TomChantler/EditHosts