Tip: You can identify the headers duplicated in a CSV file. It can happen if someone save as CSV an Excel file and some duplicates were repeated multiple times by mistake. When trying to import the CSV, we can only see the first duplicate found but not all of them (SamAccountName and Department). Here we can see… Read More »
Tip: You can extract the OU (Organizational Unit) from DN (Distinguished Name) in Active Directory. For example, someone sent you one report with DN only and you need to extract the OU.
|
1 2 3 4 5 6 7 8 9 10 |
$distinguishedName = 'CN=SMITH John,OU=Managers,OU=EMEA,DC=contoso,DC=com' # Solution 1 [regex]::match($distinguishedName,'(?=OU)(.*\n?)(?<=.)').Value # Solution 2 $distinguishedName.Substring($distinguishedName.IndexOf('OU=')) # Solution 3 (([ADSI]"LDAP://$distinguishedName").parent).Substring(7) |
Tip: You can extract the CN (Common Name) from DN (Distinguished Name) in Active Directory. For example, someone sent you one report with DN only and you need to extract the CN.
|
1 2 3 4 5 6 7 |
$distinguishedName = 'CN=SMITH John,OU=Managers,OU=EMEA,DC=contoso,DC=com' # Solution 1 $distinguishedName -replace "(CN=)(.*?),.*",'$2' # Solution 2 ($distinguishedName -split ',*..=')[1] |
Tip: You can get the start time and end time of the current day :
|
1 2 |
$beginDay = Get-Date -Hour 0 -Minute 00 -Second 00 $endDay = $beginDay.AddDays(1).AddSeconds(-1) |
Tip: You can get the total size amount of RAM installed.
|
1 |
[Math]::Round((Get-WmiObject -Class Win32_ComputerSystem).TotalPhysicalMemory/1GB) |
Tip: You can list the headers of a CSV file.
|
1 |
Import-Csv -Path .\services.csv | Get-Member -MemberType NoteProperty | Select-Object -ExpandProperty Name | Sort-Object |
Tip: You can use the parameter ReadCount of Get-Content cmdlet to increase the number of lines sent to pipeline. The default value is 1 (each line is sent to pipeline to the next command at a time). The value 0 sends all of the content at one time (when working with large items, it can speed… Read More »
Tip: You can test if a path is a file or a folder using Test-Path cmdlet:
|
1 2 3 4 5 6 |
# Check if file (works with files with and without extension) Test-Path -Path 'C:\Demo\FileWithExtension.txt' -PathType Leaf Test-Path -Path 'C:\Demo\FileWithoutExtension' -PathType Leaf # Check if folder Test-Path -Path 'C:\Demo' -PathType Container |
Tip: You can remove multiple whitespaces from a string.
|
1 2 3 4 5 6 7 |
$test = 'one two three' # Solution 1 $test -replace '\s+', '' # Solution 2 (slower) $test.Split('',[System.StringSplitOptions]::RemoveEmptyEntries) -join '' |
Tip: You can remove empty elements in an array.
|
1 2 3 4 5 6 7 8 |
# Solution 1 $array.Where({ $_ -ne "" }) # Solution 2 $array | Where-Object {$_} # Solution 3 $array.Split('',[System.StringSplitOptions]::RemoveEmptyEntries) |