Useful PowerShell Commands

Get-ComputerInfo

Accessing the properties of a command

Get-Computerinfo -Properties csusername
Get-Computerinfo -Properties csusername | Get-Member
Get-ComputerInfo | Format-List OsType,osName,csusername

Write output to the screen, like Echo

Write-Output "Hello World" 

Read Text file

Get-Content filename.txt

Rename-Computer
Restart-Computer
Get-Date
Get-TimeZone

Import csv file The pipe it to another function

import-csv .\filename.csv | 

Rename Files using csv list / excel file (exported to CSV)

If you execute the script in the same directory as the files, you don't have to add the full path, but if it's in a different directory the the full path is needed

You can start with an excel file. Header has to be Path and NewName Then export the file as CSV

Sample Excel File

Path	NewName
cat.jpg	cat01.jpg
dog.jpg	dog02.jpg
rat.jpg	rat03.jpg

Path refers to the Old Filename and NewName is the New Filename

The reason why we add the Path, and NewName is because the Rename-Item function accepts a Path string and a NewName string

import-csv ./rename.csv | rename-item

The CSV File

Path,NewName
dog.jpg,222-dog.jpg
rat.jpg,333-rat.jpg
cat.jpg,111-cat.jpg

Pass txt file to a command

The parentheses is needed to execute that portion first, then pass the content to the Test-Connection

Test-Connection -ComputerName (Get-Content .\filenamewithcomputernames.txt)

Get a Count of Item. Like WC in Linux

Get-ChildItem . -name | Measure-Object

Count    : 417
Average  :
Sum      :
Maximum  :
Minimum  :
Property :

Sorting Object in the pipeline

Get-Process | Sort-Object ID,ProcessName -Unique

Sorts by ID First Then ProcessName

Handles  NPM(K)    PM(K)      WS(K)     CPU(s)     Id  SI ProcessName
-------  ------    -----      -----     ------     --  -- -----------
      0       0       60          8                 0   0 Idle
  10836       0       60       3356                 4   0 System
      0       0      176     102024               332   0 Secure System
      0      25     6876      50164               376   0 Registry
   1653      20    10408      20084              1068   0 svchost
    208       8     1580       6360              1092   0 WUDFHost
    899      30     2572       6316              1152   0 csrss