To convert the JSON file to the CSV file using PowerShell, we need to use the ConvertTo-CSV command as a pipeline.For example, we have a JSON file called PatchingServer.JSON stored at C:\temp and its content is as below.ExamplePS C:\> Get-Content C:\Temp\PatchingServer.json {    "Port": "9000",    "ApplicationName": "TestApp",    "MaintenanceWindow": "Every Saturday",    "BusinessUnit": "IT",    "AppOwner": "Josh",    "AppID": "1jj2221-223443s",    "Location": "EastUS" }We need to convert the above file to the CSV file so we will use the ConvertTo-CSV command but before that, we need the JSON file need to be converted from JSON format to table format using ... Read More

Windows Product key can be retrieved using PowerShell or CMD. To retrieve the product key using PowerShell, we need to query SoftwareLicesingService class and there is a property called OA3xOriginalProductKey which stores the product key.ExampleGet-WmiObject -query `select * from SoftwareLicensingService' | Select OA3xOriginalProductKeyOutputOA3xOriginalProductKey ---------------------- BBBBB-CSDSC-EESSR-KKIDS-AAAAAWe can also query this WMI class using cmd as shown below.wmic path softwarelicensingservice get OA3xOriginalProductKeyCaution: It may or may not work for all the Windows OS. The above is tested in Windows 10.

Generally, Product serial numbers are available at the back of the laptop on the company sticker and we can use the Third-party or manufacturer software to find the Product details. The product serial number can also be found using the BIOS utility or command. We can either use the BIOS command for the cmd or using PowerShell.To get the product serial number using PowerShell, we can use WMI or CIMInstance command. For example, ExampleGet-CimInstance Win32_BIOSWe can also use the WMI command. For example, ExampleGet-WmiObject Win32_BIOSOutputSMBIOSBIOSVersion : F.13 Manufacturer      : AMI Name              : ... Read More

To set the line breakpoint in the script, we can use the Set-PSBreakpoint command with -Line parameter and need to give the path of the script on which the Line breakpoint needs to set.Consider we have the script below which retrieves the value up to 99, starting from 1, We will set the Line Breakpoint at line number 3 so we will use the below command. Here the script name is WhieScript.ps1 and stored at C:\temp.Set-PSBreakpoint C:\temp\WhileScript.ps1 -Line 3Once you run the above command, you will get the output with the details as shown below.ID Script    Line Command Variable ... Read More

Breakpoint in the PowerShell is the part of the debugger in the PowerShell commands. We use the breakpoints in PowerShell mainly for troubleshooting and logging purpose.There are three ways to set the breakpoint in PowerShell.Line BreakPoint (Can set the breakpoint for single or multiple lines)Command BreakPoint (Can set the breakpoint for commands or functions)Variable Breakpoint (Can set the breakpoint on a variable or multiple variables).We can’t set the breakpoint for the remote computer. To set the breakpoint for the remote computer, we first need to copy the script to the remote computer and then need to set the breakpoint as ... Read More

To check if the file is empty using PowerShell, we can use the string method called IsNullorWhiteSpace(). This method provides result true if the file is empty or only contains the white spaces otherwise false.For example, We have a test2.txt text file which has whitespaces.Example[String]::IsNullOrWhiteSpace((Get-content C:\Test2.txt))OutputTrueBut if you have a file like CSV which contains few headers but the data is empty, in that case, Get-Content will show the wrong output because it will consider headers. For example, Example[String]::IsNullOrWhiteSpace((Get-content C:\Temp\NewUsers.csv))OutputFalse Because the file has headers.PS C:\> Get-Content C:\Temp\NewUsers.csv Name, FirstName, Surname, EMPNumber, CountryIn that case, we can use the Import-CSV ... Read More

To open any file using its default application, we can use the Invoke-Expression command. For example, we want to open a file on the C:\temp and the file name is NewUsers.CSV then you can run the below command.Invoke-Expression C:\Temp\NewUsers.csvThe above command will open the file from that location. If the default application is not set then Windows will ask for the default application to select.If you know any application name and which can be opened with the shortcut then you can directly type the name of the application. For example, Notepad.exe, Calc.exeGenerally, they can be opened directly but this command ... Read More

We have a raw text example and to convert it into the CSV values, we can use below code.ExamplePS C:\> $text = "This is a PowerShell latest version" PS C:\> $text.Replace(' ', ', ')OutputThis, is, a, PowerShell, latest, versionIf there are multiple spaces between the keywords then the above replace command would go wrong. For example, ExamplePS C:\> $text = "This is a PowerShell latest version" PS C:\> $text.Replace(' ', ', ')OutputThis, , is, , , a, , , , PowerShell, latest, version So we can use another method as shown below.$text -replace '\s+', ' 'In the above command, \S ... Read More

We can get the list of opened applications in Windows using PowerShell using Get-Process command. Get-Process command shows the currently running processes in the foreground and the background as well.If we simply run the Get-Process command then it will give the process names and their associated process IDs and CPU, memory usage.PS C:\> Get-ProcessIf we check the members of the Get-Process, there is a MainWindowsTitle Property. This property indicates the Title of the opened application.In the below example, we will find the Application Name, associated process, and the ID of the application. For example, Get-Process | Select MainWindowTitle, ProcessName, Id ... Read More

To delete the OU from the Active Directory using PowerShell, we need to use the command Remove-ADOrganizationUnitRemove-ADOrganizationalUnit -Identity "OU=LabUsers, DC=Labdomain, DC=Local"If the OU is protected from the accidental delete, you will receive an Access is Denied error as shown below.Remove-ADOrganizationalUnit : Access is denied At line:1 char:1 + Remove-ADOrganizationalUnit -Identity "OU=LabUsers, DC=Labdomain, DC=Lo ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : PermissionDenied: (OU=LabUsers, DC=Labdomain, DC=Local:ADOrganizationalUnit) [Remove-ADOrgan izationalUnit], UnauthorizedAccessException + FullyQualifiedErrorId : ActiveDirectoryCmdlet:System.UnauthorizedAccessException, Microsoft.ActiveDirectory.Managem ent.Commands.RemoveADOrganizationalUnitSo for that, first you need to disable the protected mode using the Set-ADOrganizationalUnit command and then need to run the remove command as shown below.$ou = "OU=LabUsers, DC=Labdomain, ... Read More