When you run a command Export-Csv in PowerShell, it automatically creates a CSV file to the specific location.ExampleGet-Service | Select Name, Starttype, Status | Export-Csv C:\temp\services.csv -NoTypeInformationIn the above example, Services.csv file created in C:\Temp folders with the header Name, Starttype, and Status headers.Similarly, you can use the other commands to get the output into the CSV file format.If you want to check this file from the PowerShell console, you need to use Import-CSV command.Import-Csv C:\temp\Services.csv | ft -AutosizeOutputName                                     StartType     ... Read More

If you want the specific properties in PowerShell, you need to use the Select-Object (Alias − Select) as a pipeline.In the below example, we will retrieve the specific properties of the Spooler service.ExampleGet-Service Spooler | Select Name, DisplayName, Starttype, StatusOutputName       DisplayName    StartType    Status ----       -----------    ---------    ------ Spooler    Print Spooler  Automatic    RunningNow we will customize the header by renaming the “Name” property to the “Alias Name” by the Name and the Expression syntax inside the Select-object.ExampleGet- Service Spooler | Select @{N='Alias Name';E={$_.Name}}, DisplayName, Starttype, StatusYou can also use ... Read More

In PowerShell, the output is in the default table format. To format the output in the desired format, mainly below pipeline commands are used.Format-TableFormat-ListFormat-WideThere are also commands to format the output data but not used widely.Format-CustomFormat-HexIn the below example, we will get the service's details using Get-Service and format it using the different output cmdlets.Get-Service WinRM, SpoolerOutputStatus     Name        DisplayName ------     ----        ----------- Running    Spooler     Print Spooler Stopped    WinRM       Windows Remote Management (WS-Manag...As you can see Display Name for the WinRM service is not ... Read More

To add/remove date from the date string you need to use AddDay() method. For example,We need to add 6 days to the current date.(Get-Date).AddDays(6) 25 March 2020 22:40:36To go back to the specific number of days, the same AddDays() method will be used but the numbers are negative. For example,(Get-Date).AddDays(-6) 13 March 2020 22:45:34

By default the when you run the (Get-Date) cmdlet, its output is in the below format.PS C:\WINDOWS\system32> Get-Date 18 March 2020 22:56:18You can format the above output in the various format supported by PowerShell.Examplesd – Short date pattern.PS C:\WINDOWS\system32> Get-Date -Format d 18-03-2020D – Long date patternPS C:\WINDOWS\system32> Get-Date -Format D 18 March 2020f – Full date pattern with a short time pattern.PS C:\WINDOWS\system32> Get-Date -Format f 18 March 2020 23:01F – Full date pattern with a long time pattern.PS C:\WINDOWS\system32> Get-Date -Format F 18 March 2020 23:02:22g – General date pattern with a short time pattern.PS C:\WINDOWS\system32> Get-Date -Format g 18-03-2020 ... Read More

To check if the date is adjusted by the daylight savings you need to use the function IsDayLightSavingTime() of the Get-Date cmdlet.PS C:\WINDOWS\system32> (Get-Date).IsDaylightSavingTime() FalseTo know more about DST, check the link below.http://www.webexhibits.org/daylightsaving/b.html

Get-Date function in PowerShell is to get the current system date and time. For example, when you type simply Get-Date, the output will be, Get-DatePS C:\WINDOWS\system32> Get-Date 18 March 2020 19:17:03When you check the type of the (Get-Date) function, it is DateTime.(Get-Date).GetType() PS C:\WINDOWS\system32> (Get-Date).GetType() IsPublic IsSerial    Name       BaseType -------- --------    ----       -------- True     True        DateTime    System.ValueTypeWhen you check all the properties of the (Get-Date).PS C:\WINDOWS\system32> Get-Date | fl * DisplayHint : DateTime DateTime    : 18 March 2020 19:32:32 Date        : 18-03-2020 ... Read More

To convert the integer variable to the string variable, you need to use the explicit conversion or the functional method. In the below example, we are assigning an integer value to the variable $X.$x = 120 $x.GetType().NameNow when you check the data type of that variable, it will be Int32.To convert it into the string variable, first, we will use the explicit method by using a square bracket and data type to convert inside the brackets.[string]$x = 130 $x.GetType().NameThe data type of $x is the String.In the second method, you can use the PowerShell functional method ToString() to convert. For ... Read More

There are different data types exist for the variable like Byte, Int32, Float, String, etc. To get the variable type, we need to use the GetType() method.Example$x = 10 $x.GetType()OutputIsPublic IsSerial Name    BaseType -------- -------- ----    -------- True     True     Int32   System.ValueTypeTo get only the variable datatype use Name property.$x.GetType().NameInt32

To convert the content of the file into the upper case, you need to use the method ToUpper() and to convert into lower case, you need to use ToLower() method.Upper case example(Get-Content D:\Temp\PowerShellaliases.txt).ToUpper()OutputPS C:\WINDOWS\system32> (Get-Content D:\Temp\PowerShellaliases.txt).ToUpper() COMMANDTYPE     NAME                                               VERSION    SOURCE -----------     ----                                               -------    ------ ALIAS         ... Read More