Difference between revisions of "Useful PowerShell Commands"
Jump to navigation
Jump to search
| Line 16: | Line 16: | ||
Get-TimeZone | Get-TimeZone | ||
<h3>[[Update Windows From PowerShell]]</h3> | <h3>[[Update Windows From PowerShell]]</h3> | ||
==Import csv file The pipe it to another function== | |||
import-csv .\filename.csv | | import-csv .\filename.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></p> | ||
| Line 45: | Line 45: | ||
cat.jpg,111-cat.jpg | cat.jpg,111-cat.jpg | ||
</pre> | </pre> | ||
== 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> | ||
Test-Connection -ComputerName (Get-Content .\filenamewithcomputernames.txt) | Test-Connection -ComputerName (Get-Content .\filenamewithcomputernames.txt) | ||
== Get a Count of Item. Like WC in Linux == | |||
Get-ChildItem . -name | Measure-Object | Get-ChildItem . -name | Measure-Object | ||
<pre> | <pre> | ||
Revision as of 19:17, 18 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
| 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 :