Difference between revisions of "Useful PowerShell Commands"
Jump to navigation
Jump to search
| Line 20: | Line 20: | ||
==Rename Files using csv list / excel file (exported to CSV)== | ==Rename Files using csv list / excel file (exported to CSV)== | ||
<p>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</p> | <p>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</p> | ||
<p>You can start with an excel file. Header has to be <span class="high"> Path</span> and <span class="high">NewName </span></p> | <p>You can start with an excel file. Header has to be <span class="high"> Path</span> and <span class="high">NewName </span> Then export the file as <span class="high">CSV</span></p> | ||
{| class="wikitable" style="margin:auto" | {| class="wikitable" style="margin:auto" | ||
|+ Sample Excel File | |+ Sample Excel File | ||
| Line 45: | Line 45: | ||
cat.jpg,111-cat.jpg | cat.jpg,111-cat.jpg | ||
</pre> | </pre> | ||
== Pass txt file to a command == | == Pass txt file to a command == | ||
<p class="subhead">The parentheses is needed to execute that portion first, then pass the content to the Test-Connection </p> | <p class="subhead">The parentheses is needed to execute that portion first, then pass the content to the Test-Connection </p> | ||
Revision as of 17:07, 22 October 2024
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
Update Windows From PowerShell
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
| 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