“Relative path is not supported” error generally occurs with the PowerShell DSC when we download a file from online or Website and we use “File” DscResource for that.In the below example, we are downloading the PowerShell 7.1.4 version from GitHub using DSC to the local computer and we get the error below.ExampleConfiguration FileCopy{    Node LocalHost{       File CopyFromBlob{          SourcePath = "https://github.com/PowerShell/PowerShell/releases/download/v7.1.4/PowerShell-7.1.4-win-x86.msi"          DestinationPath = "C:\Temp\"          Ensure = 'Present'       }    } } FileCopy -OutputPath C:\Temp\dsc\FileCopy Start-DscConfiguration -Path C:\Temp\dsc\FileCopy -Wait -ForceOutputRelative path is ... Read More

To install the DSC resource using PowerShell, we can use the same command to install modules in PowerShell (Install-Module).The Find-DscResource command would get all the available DSC resources. To search the specific DSC resource, you can provide the -Name parameter in the Find-DscReource command. For example, we need to search for the FilesAndFolder DSC resourceFind-DSCResource -Name filesandfoldersOutputName             Version ModuleName Repository ----             ------- ---------- ---------- FilesAndFolders 0.3.212 CommonTasks PSGalleryTo install this module, we can pipeline the Install-Module command.Find-DSCResource -Name filesandfolders | Install-Module -Force -VerboseOnce the module is installed, we can ... Read More

To generate or append multiple outputs in the HTML file using PowerShell, we need to use the - Fragment parameter in the ConvertTo-HTML command.For example, let say we need to generate the computer utilization report which includes the top 5 consuming processes, stopped services, and the disk utilization report. A single report can be generated by sending the output to the ConvertTo-HTML pipeline command.Example$Heading = "System Utilization Report" $procs = Get-Process | Sort-Object -Property CPU -Descending| Select - First 5 | `    ConvertTo-Html -Property ProcessName, ID, CPU -Fragment - PreContent "High Utilization Processes" $services = Get-Service | ... Read More

To generate an HTML report using PowerShell, we can use the ConvertTo-HTML command. For example, let say we need to get the services to report in HTML format then we can use ConvertTo-HTML as a pipeline.Get-Service | ConvertTo-Html | Out-File C:\Temp\Services.html ii C:\Temp\services.htmlThe first command will retrieve the output in the HTML file and the second command (ii) is the alias of the Invoke-Item command.Once you check the output, It selects all the properties of the command. To select only a few properties, you can either use the Select command or use the -Property parameter in the ConvertTo-Html command. Both the ... Read More

To create dynamic columns or headers using CSV, we can use multiple methods but the one method that I find most suitable is the PSObject method.Let assume that your CSV column headers depend on the input provided by the user. Input can be a text file, user prompt for headers, array, etc. For this example, we will use the text file as input.We have the below columns (headers) to create in the CSV file.We will use the below command to create headers using PSObject and then export them into the CSV file.$object = New-Object psobject foreach($item in (gc C:\Temp\DynamicHeaders.txt)){ ... Read More

To delete the Azure blob using Azure CLI, we can use “az storage blob” command with the “delete” parameter. Before running this command, we first need to make sure that the azure account is connected (az login) and the proper subscription is set (az account set).To work with the azure storage account we need to authenticate to the storage. We can use storage key or the storage connections string. Here, we have shown how to retrieve the connections string.$storageaccount = 'az204storage05june' $connectionstring = az storage account show-connection-string - n $storageaccount -otsvThe below command will delete the azure storage blob named ... Read More

To get blobs inside the Azure storage container using PowerShell, we will use the Get-AzStorageBlob command. . Before running this command, we need to make sure that the Azure cloud account is connected (Connect-AzAccount) and the proper subscription is set in which the storage account resides (Set-AzContext).To work with the storage accounts we first need to set the Context for it and we will use the storage account key to set the context.$rg = "az204" $storageaccount = "az204storage05june" $key = (Get-AzStorageAccountKey -ResourceGroupName $rg - Name $storageaccount)[0].Value $context = New-AzStorageContext -StorageAccountName $storageaccount - StorageAccountKey $keyWe have now created the Azure storage ... Read More

Storage context is helpful when you are working with the Storage accounts in the PowerShell session. It is like authenticating for Azure storage. Generally, we use the Azure storage account key and the connection string to create the Azure storage context.To create a new storage context, we need to use the New-AzStorageContext command but to use this command we need a storage account key or the connection string.We will use here Storage account key. We have the resource group “Az204” and the Storage account name “az204storage05june” which are stored in a variable.$rg = "az204" $storageaccount = "az204storage05june"To get the storage account ... Read More

To use the Azure Rest API using PowerShell, we first need to connect to the Azure cloud account using the Connect-AzAccount. Once you are connected to the Azure Account, you can use the below authorization header (same has been provided on the MS website) which contains a bearer token to authenticate the rest API.$azContext = Get-AzContext $azProfile = [Microsoft.Azure.Commands.Common.Authentication.Abstractions.AzureRm ProfileProvider]::Instance.Profile $profileClient = New-Object - TypeName Microsoft.Azure.Commands.ResourceManager.Common.RMProfileClient - ArgumentList ($azProfile) $token = $profileClient.AcquireAccessToken($azContext.Subscription.TenantId) $authHeader = @{    'Content-Type'='application/json'    'Authorization'='Bearer ' + $token.AccessToken }Once you have the Authorization header available, you can use it for authentication. Now let assume we need ... Read More

As of now, there is no built-in command like CSV (Export-CSV) to export output to the excel file but we can use the Out-File command to export data to excel or any other file format.Let’s use Out-File to export the output of the Get-Processes command to an excel file.Get-Process | Out-File C:\Temp\processes.xlsThe above command will get all the running processes on the local system to the excel file. Let’s check the output of the excel file. You can see that the output is not in the proper excel format.One other way is to install the ImportExcel module for excel. It ... Read More