TopMiniSite
-
4 min readTo read an XML node text with spaces using PowerShell, you can use the Select-Xml cmdlet to select the specific node and then access its InnerText property to get the text value, even if it contains spaces. Use the following code snippet as an example: $xml = [xml](Get-Content "path/to/xmlfile.xml") $node = Select-Xml -Xml $xml -XPath "//node/with/spaces" $nodeValue = $node.Node.
-
6 min readTo export output from PowerShell to a CSV file, you can use the Export-CSV cmdlet. This cmdlet allows you to create a CSV file containing the output of a command or script. You can pipe the output of a command to Export-CSV and specify the file path where you want to save the CSV file. This way, you can easily store the output of PowerShell commands in a format that can be easily shared and analyzed in other applications.
-
4 min readTo copy folder structure only with PowerShell, you can use the following command: Get-ChildItem -Path "source_folder_path" -Recurse | Where-Object { $_.PSIsContainer } | foreach { $_.FullName.Replace("source_folder_path", "destination_folder_path") } Replace "source_folder_path" with the path of the folder you want to copy and "destination_folder_path" with the path of the destination folder where you want to copy the folder structure.
-
5 min readYou can execute a multi-line PowerShell script using Java by first creating a ProcessBuilder object and setting the command to "powershell.exe". Then, you can pass the script as a parameter to the ProcessBuilder object using the command line arguments. Make sure to include the "-Command" flag before the script to indicate that it is a PowerShell command. Finally, start the process and read the output if needed.
-
4 min readIn PowerShell, environment variables can be accessed through the $env: prefix followed by the name of the variable. When dealing with environment variable types in PowerShell, it is important to remember that all variable values are inherently stored as strings. This means that if you need to use an environment variable as a specific type (e.g. integer, boolean), you will need to explicitly cast or convert the value to the desired type.
-
5 min readTo split on the first occurrence using regex in PowerShell, you can use the -split operator along with a regular expression pattern that matches the first occurrence. For example, if you want to split a string $input on the first comma ,, you can do it like this: $input = "first,second,third" $parts = $input -split ",(?=.*?,)" In this example, the regex pattern ",(?=.*?,)" matches the first comma , in the string without consuming any characters after it. The (?=.*.
-
4 min readTo find the sum of two columns in PowerShell, you can use the Measure-Object cmdlet.First, import the data from the columns using Import-Csv or Get-Content, then select the two columns you want to find the sum of using Select-Object.Next, pipe the output to the Measure-Object cmdlet with the -Sum parameter to calculate the sum of the selected columns.
-
7 min readTo compare two folders and add/remove files with PowerShell, you can use the Compare-Object cmdlet. This cmdlet compares two sets of objects and indicates differences. You can use it to compare files in two folders by specifying the folders as the input objects.First, use the Get-ChildItem cmdlet to retrieve the files in each folder and store them in variables.
-
4 min readTo connect MongoDB with PowerShell, you can use the MongoDB PowerShell module. This module provides cmdlets for interacting with a MongoDB database. To connect to MongoDB using PowerShell, you first need to install the MongoDB PowerShell module using the PowerShell Gallery. Once installed, you can use the Connect-MongoDb cmdlet to establish a connection to your MongoDB database by providing the server and database details.
-
6 min readTo enable SQL filestream using Powershell, you can use the following steps:Open Powershell with administrator privileges.Load the SQL Server module by running the command: Import-Module SQLPSConnect to the SQL Server instance by running the command: $server = New-Object Microsoft.SqlServer.Management.Smo.Server("")Set the filestream access level by running the command: $server.Settings.
-
7 min readTo remotely execute a script in PowerShell, you can use the Invoke-Command cmdlet. This cmdlet allows you to run commands on remote computers. First, you need to establish a remote session using the New-PSSession cmdlet and provide the remote computer name. Then, you can use the Invoke-Command cmdlet with the -ScriptBlock parameter to specify the script you want to run remotely. Make sure to include the -Session parameter and provide the session you created earlier.