Useful PowerShell Commands - Revision history

Bacchas at 19:11, 22 October 2024

2024-10-22T19:11:13Z

← Older revision		Revision as of 19:11, 22 October 2024
Line 18:		Line 18:
	==Import csv file The pipe it to another function==		==Import csv file The pipe it to another function==
	import-csv .\filename.csv \|		import-csv .\filename.csv \|
			== Pipe files from explorer into text file ==
			get-childitem . -name >> filenames.txt

			get-childitem . -file \| foreach-object{$_.BaseName} > filenames.txt


	==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>

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

2024-10-22T17:07:55Z

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

← Older revision		Revision as of 17:07, 22 October 2024
Line 38:		Line 38:
	import-csv ./rename.csv \| rename-item		import-csv ./rename.csv \| rename-item

	<p>The CSV File</p>		<h2>The CSV File</h2>
	<pre>		<pre>
	Path,NewName		Path,NewName

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

2024-10-22T17:07:11Z

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

← Older revision		Revision as of 17:07, 22 October 2024
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>

Bacchas: /* Sorting Object in the pipeline */

2024-10-18T19:26:26Z

Sorting Object in the pipeline

← Older revision		Revision as of 19:26, 18 October 2024
Line 60:		Line 60:
	==Sorting Object in the pipeline ==		==Sorting Object in the pipeline ==
	Get-Process \| Sort-Object ID,ProcessName -Unique		Get-Process \| Sort-Object ID,ProcessName -Unique
			'''Sorts by ID First Then ProcessName'''
	<pre>		<pre>
	Handles NPM(K) PM(K) WS(K) CPU(s) Id SI ProcessName		Handles NPM(K) PM(K) WS(K) CPU(s) Id SI ProcessName
	------- ------ ----- ----- ------ -- -- -----------		------- ------ ----- ----- ------ -- -- -----------
	~~362 24 8276~~ ~~3180~~ 0~~.20 26508~~ ~~1 AcrobatNotificationClient~~		0 0 60 8 0 0 Idle
	~~148~~ ~~9 2160 11400~~ 0~~.03 3144 1 Adobe Crash Processor~~		10836 0 60 3356 4 0 System
	~~1305~~ 86 ~~114728~~ ~~94496~~ ~~52.77 10032~~ ~~1 Adobe Desktop Service~~		0 0 176 102024 332 0 Secure System
	~~584~~ ~~2532~~ ~~10192~~ ~~26700 31.14 25252~~ ~~1 AdobeCollabSync~~		0 25 6876 50164 376 0 Registry
	~~522~~ 24 ~~6748 25096~~ 0~~.31 25200 1 AdobeCollabSync~~		1653 20 10408 20084 1068 0 svchost
			208 8 1580 6360 1092 0 WUDFHost
			899 30 2572 6316 1152 0 csrss
	</pre>		</pre>

	==[[Main_Page\| Home]] - [[PowerShell\|Category]]==		==[[Main_Page\| Home]] - [[PowerShell\|Category]]==

Bacchas: /* Sorting Object in the pipeline */

2024-10-18T19:24:25Z

Sorting Object in the pipeline

← Older revision		Revision as of 19:24, 18 October 2024
Line 59:		Line 59:
	</pre>		</pre>
	==Sorting Object in the pipeline ==		==Sorting Object in the pipeline ==
	Get-Process \| Sort-Object ID -Unique		Get-Process \| Sort-Object ID,ProcessName -Unique
			<pre>
			Handles NPM(K) PM(K) WS(K) CPU(s) Id SI ProcessName
			------- ------ ----- ----- ------ -- -- -----------
			362 24 8276 3180 0.20 26508 1 AcrobatNotificationClient
			148 9 2160 11400 0.03 3144 1 Adobe Crash Processor
			1305 86 114728 94496 52.77 10032 1 Adobe Desktop Service
			584 2532 10192 26700 31.14 25252 1 AdobeCollabSync
			522 24 6748 25096 0.31 25200 1 AdobeCollabSync
			</pre>

	==[[Main_Page\| Home]] - [[PowerShell\|Category]]==		==[[Main_Page\| Home]] - [[PowerShell\|Category]]==

Bacchas at 19:23, 18 October 2024

2024-10-18T19:23:14Z

← Older revision		Revision as of 19:23, 18 October 2024
Line 58:		Line 58:
	Property :		Property :
	</pre>		</pre>
			==Sorting Object in the pipeline ==
			Get-Process \| Sort-Object ID -Unique

	==[[Main_Page\| Home]] - [[PowerShell\|Category]]==		==[[Main_Page\| Home]] - [[PowerShell\|Category]]==

Bacchas at 19:17, 18 October 2024

2024-10-18T19:17:45Z

← Older revision		Revision as of 19:17, 18 October 2024
Line 16:		Line 16:
	Get-TimeZone		Get-TimeZone
	<h3>[[Update Windows From PowerShell]]</h3>		<h3>[[Update Windows From PowerShell]]</h3>
	~~<h3>~~Import csv file The pipe it to another function~~</h3>~~		==Import csv file The pipe it to another function==
	import-csv .\filename.csv \|		import-csv .\filename.csv \|
	~~<h3>~~Rename Files using csv list / excel file (exported to CSV)~~</h3>~~		==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>
	~~<h3>~~ Pass txt file to a command ~~</h3>~~		== 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)
	~~<h3>~~ Get a Count of Item. Like WC in Linux ~~</h3>~~		== Get a Count of Item. Like WC in Linux ==
	Get-ChildItem . -name \| Measure-Object		Get-ChildItem . -name \| Measure-Object
	<pre>		<pre>

Bacchas at 19:16, 18 October 2024

2024-10-18T19:16:47Z

← Older revision		Revision as of 19:16, 18 October 2024
Line 1:		Line 1:
	Get-ComputerInfo		Get-ComputerInfo
	~~<h3>~~Accessing the properties of a command ~~</h3>~~		==Accessing the properties of a command ==
	Get-Computerinfo -Properties csusername		Get-Computerinfo -Properties csusername
	Get-Computerinfo -Properties csusername \| Get-Member		Get-Computerinfo -Properties csusername \| Get-Member
	Get-ComputerInfo \| Format-List OsType,osName,csusername		Get-ComputerInfo \| Format-List OsType,osName,csusername

	~~<h3>~~ Write output to the screen, like Echo ~~</h3>~~		== Write output to the screen, like Echo ==
	Write-Output "Hello World"		Write-Output "Hello World"

	~~<h3>~~ Read Text file ~~</h3>~~		== Read Text file ==
	Get-Content filename.txt		Get-Content filename.txt

Bacchas at 19:15, 18 October 2024

2024-10-18T19:15:35Z

@@ Line 48: / Line 48: @@
 <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)
 ==[[Main_Page| Home]] - [[PowerShell|Category]]==

Bacchas at 18:59, 18 October 2024

2024-10-18T18:59:34Z

← Older revision		Revision as of 18:59, 18 October 2024
Line 45:		Line 45:
	cat.jpg,111-cat.jpg		cat.jpg,111-cat.jpg
	</pre>		</pre>
			<h3> Pass txt file to a command </h3>
			<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)

	==[[Main_Page\| Home]] - [[PowerShell\|Category]]==		==[[Main_Page\| Home]] - [[PowerShell\|Category]]==