Powershell
Powershell + HTML + Replace COLOR for a ROW
It will color the whole row in a table with the text “rejected” in the end.
SSH-COPY-ID for Windows
type $env:USERPROFILE\.ssh\id_rsa.pub | ssh {IP-ADDRESS-OR-FQDN} “cat >> .ssh/authorized_keys”
Powershell + string to array
An array is created with the -split operator. Like so, $myString=”Four score and seven years ago” $arr = $myString -split ‘ ‘ $arr # Print output Four score and seven years ago When you need a certain item, use array index to reach it. Mind that index starts from zero. Like so, $arr[2] # 3rd […]
MDT + Script for joining to a domain
$strUser = “domain\user” $strDomain = “domain.local” $strPassword = ConvertTo-SecureString “password” -AsPlainText -Force $Credentials = New-Object System.Management.Automation.PsCredential $strUser, $strPassword $strOU = “OU=Computers,DC=domainn,DC=local” Add-computer -DomainName $strDomain -Credential $Credentials -OUPath $strOU
MDT + Script for renaming a PC according to his IP
powershell.exe -noprofile -command “Set-ExecutionPolicy Bypass LocalMachine” -force $strPrefix=”WS” # Get IP and make the name $IP=(Get-WmiObject win32_networkadapterconfiguration | Select-Object -Property @{name=’IPAddress’;Expression={($_.IPAddress[0])}} | Where IPAddress -NE $null).IPAddress $a,$b,$c,$d = $IP.split(‘.’) $strComputerName=$strPrefix+$c+”-“+$d # Rename $computer=gwmi Win32_computersystem $computer.rename($strComputerName)
Exchange 2010 + Powershell + Search and delete specific mail
Task: Find and delete all the e-mail that contains specific attachment. 1. Estimate and debug our query: Get-Mailbox -ResultSize Unlimited | Search-Mailbox -SearchQuery ‘attachment:”My file example*”‘ -TargetMailbox “my.mailbox” -TargetFolder “MyFolder” -Logonly -Loglevel Full | Select DisplayName, ResultItemsCount | where-object {$_.ResultItemsCount -ne “0”} and check the folder for the report or Get-Mailbox -ResultSize Unlimited | Search-Mailbox […]
Fix All Failed Exchange Database Content Indexes
Source:https://practical365.com/exchange-server/fix-all-failed-exchange-database-content-indexes/ One of the issues that my Get-DAGHealth.ps1 script alerts for is failed content indexes on database copies in a database availability group. Note: for failed content indexes on servers that are not DAG members refer to this article instead. Failed content indexes can easily go unnoticed when everything else is working fine however they […]
Windows 10 + HP2055 + Duplex printing
Windows 10 setup universal hp driver for HP2055DN and every time reset Duplex printing module to “Not installed”. I’ve added a startup script in scheduler to set this property to “Installed”. set-printerproperty “HP2055DN” -PropertyName Config:DuplexUnit Installed
Powershell + Sign a script
Set-AuthenticodeSignature my.ps1 @(Get-ChildItem cert:\CurrentUser\My -codesign)[0]
Powershell + Add a user to a group to a local workstation
Invoke-Command -ComputerName S1, S2 -ScriptBlock {add-LocalGroupMember -Group “Administrators” -Member username }