Tip: You need to wait until the EMC Avamar Backup client finishes the backup. An easy way to do that is to check if the processes avtar and avvss are running.
|
1 2 3 4 |
do { Start-Sleep -Seconds 1 } while (Get-Process -Name avtar, avvss -ErrorAction SilentlyContinue) |
Tip: You can use the cmdlet New-TimeSpan to convert days, hours, minutes, seconds. Convert days : New-TimeSpan -Days 1 Convert hours : New-TimeSpan -Hours 24 Convert minutes : New-TimeSpan -Minutes 1440 Convert seconds : New-TimeSpan -Seconds 86400
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 |