Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Software & Coding Articles
Page 27 of 83
How to create dynamic columns (headers) in CSV using PowerShell?
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 MoreHow to get the Azure storage container blobs (Files) using PowerShell?
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 MoreHow to resolve - The underlying connection was closed - Could notnestablish trust relationship for the SSL/TLS secure channel in PowerShell?
When you run Invoke-WebRequest or Invoke-RestMethod command, sometimes you get the error “The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.” because there could be a certificate issue or the required windows version doesn’t support the TLS or SSL version. You can use the below command to bypass this error.[System.Net.ServicePointManager]::ServerCertificateValidationCallback = {$true}Or you can use the below code to resolve this error.Exampleadd-type @" using System.Net; using System.Security.Cryptography.X509Certificates; public class TrustAllCertsPolicy : ICertificatePolicy { public bool CheckValidationResult( ServicePoint srvPoint, X509Certificate certificate, WebRequest request, ...
Read MoreHow to get the Accelerated networking status of Azure VM using PowerShell?
From the Azure Portal, we can find the Accelerated Networking (AN) status from the networking blade.To get the AN settings on the VM, we need to first retrieve the NIC information because it is set on it. We have the VM named ‘TestVM’ and we will retrieve its NIC information.PS C:\> $vm = Get-AzVM -Name TestVMTo get the NIC associated with the VM, $nicname = (($vm.NetworkProfile.NetworkInterfaces.id).Split('/'))[-1]We need to retrieve the NIC settings to get the AN setting.$nicsetting = Get-AzNetworkInterface -ResourceGroupName $vm.ResourceGroupName - Name $nicnameTo get the AN settings, use the EnableAcceleratedNetworking property.$nicsetting.EnableAcceleratedNetworkingIf you want to retrieve the AN settings on ...
Read MoreHow to get the Azure VM username using Azure CLI in PowerShell?
To get the Azure VM username using Az CLI, we need to use the below command.PS C:\> az vm show -n AzVM -g ResourceGroup --query '[osProfile.adminUsername]' -otsvThe above command will retrieve the Azure VM username. You can also use the below command to retrieve the Azure VM username without knowing the resource group name.PS C:\> az vm list --query "[?name=='vmname'].osProfile.adminUsername" -otsvBefore running the above commands, make sure that you are connected to the Azure cloud and the specific Azure Subscription.
Read MoreHow to get the Azure VM Size using Azure CLI in PowerShell?
To get the Azure VM size using Azure CLI, we first need to make sure that the Azure account is connected to the specific subscription for the VM that we need to retrieve the VM size.To get the specific Azure VM size, we need to first retrieve the VM details and then need to run the JMESPATH query to retrieve the VM size.az vm show -n VMname -g ResourceGroupName --query '[hardwareProfile.vmSize]' -otsvyou can also retrieve the size of the VM without resource group name, using “az vm list” command.az vm list --query "[?name=='AzVM'].hardwareProfile.vmSize" -otsv
Read MoreHow to get Azure VM activity logs using PowerShell?
To get the Azure VM activity logs with PowerShell, we need to use the Get-AzLog command. Before running, AZ commands make sure that you are connected to the Azure Account using (ConnectAzAccount) and the subscription (Set-AzContext).We have the below TestVM, we need to retrieve activity logs and we need its resource id. We will get the resource ID using, PS C:\> $vm = Get-AzVM -VMName TestVMPS C:\> $vm.IdWe need to use this ID in the Get-AzLog command to retrieve the activity logs.PS C:\> Get-AzLog -ResourceId $vm.IdIt will provide all the azure events for that specific resource group and you can ...
Read MoreHow to get the windows authentication settings using PowerShell?
To get the windows server authentication setting using PowerShell, we can use the below command on the local server.PS C:\> Get-ChildItem WSMan:\localhost\Service\Auth | Select name, valueOutputName Value ---- ----- Basic false Kerberos true Negotiate true Certificate false CredSSP false CbtHardeningLevel RelaxedTo get the same settings on the remote servers, use the below command.Invoke-Command -ComputerName TestMahchine1, TestMachine2 - ScriptBlock { Get-ChildItem WSMan:\localhost\Service\Auth } | Select PSComputerName, Name, Auth
Read MoreHow to enable credssp authentication on windows server using PowerShell?
Before enabling the credssp authentication for the windows server, we will first check the credssp status using the below command.Get-ChildItem WSMan:\localhost\Service\Auth | Where-Object {$_.Name -eq "CredSSP"} | Select Name, ValueOutputName Value ---- ----- CredSSP falseTo enable the credssp,PS C:\> Enable-WSManCredSSP -role server -ForceOutputcfg : schemas.microsoft.com/wbem/wsman/1/config/service/auth lang : en-US Basic : false Kerberos : true Negotiate : true Certificate : false CredSSP : true CbtHardeningLevel : RelaxedTo enable the credssp authentication on the remote computers,Invoke-Command -ComputerName TestMahchine1, TestMachine2 - ScriptBlock { Enable-WSManCredSSP -Role Server -Force }
Read MoreHow to disable the credssp authentication using PowerShell?
To disable the credssp on the local computer using PowerShell, use the below command.PS C:\> Disable-WSManCredSSP -Role Server -VerboseYou can check if the credssp is disabled, using the below command.PS C:\> Get-ChildItem WSMan:\localhost\Service\Auth | Where-Object {$_.Name -eq"CredSSP"} | Select Name, Value Name Value ---- ----- CredSSP falseTo disable the credssp authentication on the remote computers using PowerShell,Invoke-Command -ComputerName TestMahchine1, TestMachine2 - ScriptBlock { Disable-WSManCredSSP -Role Server }
Read More