Virtual Geek

This blog article is similar to my previous notes VMWARE ESXI INSTALL AND CONFIGURE SOFTWARE ISCSI STORAGE ADAPTER FOR VMFS VERSION 6 DATASTORE. Here I am using VMware Powercli instead of vSphere web client to configure iScsi storage adpater and add new datastore. As this is complete powercli article I will not use GUI at all.

I am configuring my first Esxi server. Storing its information in variable called $VMhost.
$VMhost = Get-VMhost Esxi001.vcloud-lab.com

Next install and enable iSCSI software adapter.
$VMhost | Get-VMHostStorage | Set-VMHostStorage -SoftwareIScsiEnabled $True

Before processing further first I will do ping and telnet test on esxi server to storage and vice versa, As this is complete powercli article, for this I will enable SSH service on Esxi server using below command.
$VMHost | Get-VMHostService | ? {$_.Key -eq 'TSM-SSH'} | Start-VMHostService -Confirm:$false

Putty to esxi server. The telnet command is not available in any versions of ESXi and, therefore, you must use netcat (nc) to confirm connectivity to a TCP port on a remote host. The syntax of the nc command is: nc -z <destination-ip> <destination-port>, I am telneting port 3260 and succeeded means good (This is also a guide how to telnet in vmware esxi)

nc -z 172.20.1.101 3260
Connection to 172.20.1.101 3260 port [tcp/*] succeeded!

To use telnet command on Microsoft Windows telnet client needs to be installed with PowerShell command Install-WindowsFeature Telnet-Client. run telnet IP port, prompt is changed means I can go ahead with further configuration.

After enabling iScsi software adapter I need iSCSI IQN name, which I will need to add on storage server in initiator list.
$VMhost | Get-VMHostHba -Type iScsi | Select-Object Name, Status, IScsiName

Below command is ran on Microsoft iSCSI target, in the Initiator list, without this Esxi will not able to view or access LUN. Refer this article POWERSHELL INSTALLING AND CONFIGURING MICROSOFT ISCSI TARGET SERVER
Set-IscsiServerTarget -TargetName Boot-Esxi001 -InitiatorIds iqn:iqn.1998-01.com.vmware:esxi001-5abe60a5

Add storage target IP in the software iScsi storage adapter static discovery. (Get-VMHostHba -Type iscsi parameter shows software adapter)
$VMhost | Get-VMHostHba -Type iScsi | New-IScsiHbaTarget -Address 172.20.1.101

Next is needed devicename of iSCSI VMkernel adapter configured earlier. Ref. article POWERCLI: VMWARE ESXI CONFIGURE (VSWITCH) VMKERNEL NETWORK PORT FOR ISCSI STORAGE, with using Where-Object filtering on Get-VMHostNetworkAdapter -VMkernel I easily get the needed DeviceName. I got two results vmk1 and vmk2. note them down.
$VMhost | Get-VMHostNetworkAdapter -VMKernel | ? {$_.PortGroupName -match 'iSCSI'} | select Devicename

After getting information about VMkernel port name, I need device name of vmhba using:
$VMHost | Get-VMHostHba -Type IScsi | Select Device

Next step use EsxCli and add vmkernel ports to network port binding,
$esxcli = $VMhost | Get-EsxCli
$esxcli.iscsi.networkportal.add('vmhba65',$Null,'vmk1')
$esxcli.iscsi.networkportal.add('vmhba65',$Null,'vmk2')

Once everything is successful rescan for HBA and VMFS on esxi server.
$VMhost | Get-VMHostStorage -RescanAllHba -RescanVmfs

If above steps are successful, It requires NAA id of Free LUN for last step, to find free lun follow this article FIND FREE OR UNASSIGNED STORAGE LUN DISKS ON VMWARE ESXI SERVER.
Get-FreeEsxiLUNs -Esxihost Esxi001.vcloud-lab.com

Once NAA id is rectified use New-Datastore command to format LUN with VMFS type, I am using complete space here.
$VMhost | New-Datastore -Name Disk1_Tier3 -Path naa.60003ff44dc75adc9601165db783a4ac -Vmfs

If you add another Esxi host adding datastore is not required, This formatted datastore will be automatically be visible once configuring VMKernel ports and iSCSI software adapter. New-Datastore need to run once only for newly presented storage disk.

Series Parts
MICROSOFT WINDOWS 2012 R2 ISCSI TARGET STORAGE SERVER FOR ESXI AND HYPERV 
POWERSHELL INSTALLING AND CONFIGURING MICROSOFT ISCSI TARGET SERVER
VMWARE ESXI CONFIGURE (VSWITCH) VMKERNEL NETWORK PORT FOR ISCSI STORAGE
POWERCLI: VMWARE ESXI CONFIGURE (VSWITCH) VMKERNEL NETWORK PORT FOR ISCSI STORAGE
VMWARE ESXI INSTALL AND CONFIGURE SOFTWARE ISCSI STORAGE ADAPTER FOR VMFS VERSION 6 DATASTORE
POWERCLI VMWARE: CONFIGURE SOFTWARE ISCSI STORAGE ADAPTER AND ADD VMFS DATASTORE
VMWARE VCENTER STORAGE MIGRATE/SVMOTION VM AND PORT BINDING MULTIPATHING TESTING
POWERCLI: VIRTUAL MACHINE STORAGE MIGRATE/SVMOTION AND DATASTORE PORT BINDING MULTIPATHING

Series Parts
MICROSOFT WINDOWS 2012 R2 ISCSI TARGET STORAGE SERVER FOR ESXI AND HYPERV 
POWERSHELL INSTALLING AND CONFIGURING MICROSOFT ISCSI TARGET SERVER
VMWARE ESXI CONFIGURE (VSWITCH) VMKERNEL NETWORK PORT FOR ISCSI STORAGE
POWERCLI: VMWARE ESXI CONFIGURE (VSWITCH) VMKERNEL NETWORK PORT FOR ISCSI STORAGE
VMWARE ESXI INSTALL AND CONFIGURE SOFTWARE ISCSI STORAGE ADAPTER FOR VMFS VERSION 6 DATASTORE
POWERCLI VMWARE: CONFIGURE SOFTWARE ISCSI STORAGE ADAPTER AND ADD VMFS DATASTORE
VMWARE VCENTER STORAGE MIGRATE/SVMOTION VM AND PORT BINDING MULTIPATHING TESTING
POWERCLI: VIRTUAL MACHINE STORAGE MIGRATE/SVMOTION AND DATASTORE PORT BINDING MULTIPATHING

As per below diagram I have setup Microsoft Storage Target server and Esxi Networking VMKernel ports, This is last part of series and configuring ESXi software iSCSI adapter for adding storage, here I will be adding and enabling software iSCSI adapter. (It is a client and also called initiator), Same steps can be performed using VMware Powercli and it will be a subject of my next article.

Make sure you have proper connectivity between Esxi iSCSI VMKernel adapters and Storage Target, I am checking connectivity on ESXi as well as Storage server by pinging each other. If SSH is not enabled on Esxi server go to Configure tab >> System Security Profile >> scroll down and Edit Services >> Select SSH >> Services Details on the status and start service. I am using putty tool to login to Esxi server. esxcfg-vmknic -l command lists all VMKernel adapter. I have highlighted both iSCSI vmkernel adapters, I specifically need their Interface names.

vmkping -I vmk1 172.20.1.101
vmkping -I vmk2 172.20.1.102

-I is Interface, vmkping will us selected interface only to ping remote IP. It looks good from Esxi Server that connectivity is good. Next do the same ping testing from Microsoft Storage Target server and try to reach Esxi server, using powershell command Test-Connection alternative to ping.

Test-Connection -Source 172.20.1.101 -Destination 172.20.1.10
Test-Connection -Source 172.20.1.102 -Destination 172.20.1.11

-Source is the interface on storage server and -Destination is Esxi server. Pinging is successful (if ping fails you will see error on the screen with red text). I can also check connectivity using telnet port 3260, If you are facing any issue check at networking for VLAN and MTU settings (remove them if required and check), Same steps are useful for first basic troubleshooting, Most of the time I have resolved my issues with the same steps.

By default Software iSCSI adapter is disabled and not installed on the ESXi server, It can be added by selecting Esxi Server >> Configure Tab >> Storage >> Storage Adapters >> click + green plus sign >> Software iSCSI adapter.

It shows popup message A new software iSCSI adapter will be added to the list. after it has been added, select the adapter and use the adapter details section to complete the configuration, Make note here, only one Software iSCSI hba can be added on esxi server. also it will always have number above 35, in my scenario it is vmhba65.

Here select vmhba65 adapter, note the type is iSCSI and status is online, I will require to add IQN identifier on Storage server for access. IQN stands for iSCSI Qualified name. It is somewhat as similar as physical address like MAC address and unique. Communication will taken care on 3260 port, by default when iSCSI software adapter is enabled or added it opens and allow port no 3260 in ESXi security profile automatically. Next I added this ESXi's IQN on Microsoft storage server. This table show how IQN name is made of.

I am adding one Target (Storage Server) IP address in Dynamic Discovery (just need to add one of the IP and it will detect Targets IQN and other IPs, available paths automatically). Here it supports CHAP authentication, but for simplicity I am not touching it. Advanced options can be added or changed as per vendor recommendations and best practices documents.

Next Configure storage network port binding. Port binding is used in iSCSI when multiple VMkernel ports for iSCSI reside in the same broadcast domain and IP subnet to allow multiple paths to an iSCSI array that broadcasts a single IP address. When using port binding, you must remember that:

• Array Target iSCSI ports must reside in the same broadcast domain and IP subnet as the VMkernel port.
• All VMkernel ports used for iSCSI connectivity must reside in the same broadcast domain and IP subnet.
• All VMkernel ports used for iSCSI connectivity must reside in the same vSwitch.
• Currently, port binding does not support network routing.

Here VMware has provided very nice article on storage network port binding, It is a must read article. Select network port binding tab in the bottom on iSCSI vmhba, click + green plus button. and select iSCSI network vmkernel adapters.

You will see warning, Due to recent configuration changes, a rescan of this storage adapter is recommended. So for next step click rescan button in the red circle. It Rescans the host's storage adapter to discover newly added storage devices, detects all provided remote LUNs. Check the paths tab, If calculated Two iSCSI dedicated NICs on esxi server and two NICs on storage total 4 paths available correctly.

So far it all looks good to me. In the next step add and format assigned LUN as VMFS datastorage. To add remote storage disk/LUN  on esxi go to configure tab, from Left pane expand Storage and click datastores, click the icon (red circled) to create a new datastore. New wizard opens, Select VMFS to create it and click next.

In the Name and device selection give datastore name, for best practices this name should always be matching with LUN disk on the Storage. You can use Name Naa id to correctly identify LUN disk selection, by practicing this you can avoid any accident like formatting incorrect LUN disk. In production specially with EMC devices I always ask storage team Datastore name and associated NAA id to identify disks and avoid any mis-configuration or mistakes. With the name I can view information like LUN Number, Capacity, Hardware acceleration, Drive type (HDD or SSD) and new sector format.

NAA stands for Network Addressing Authority identifier. EUI stands for Extended Unique Identifier. The number is guaranteed to be unique to that LUN. The NAA or EUI identifier is the preferred method of identifying LUNs and the number is generated by the storage device.

Next is VMFS Version as my all future hosts version going to be above 6.5, I am choosing VMFS 6 version, with this I get below feature. 

• Support for 4K Native Drives in 512e mode
• SE Sparse Default
• Automatic Space Reclamation (UNMAP) 
• Support for 512 devices and 2000 paths (versus 256 and 1024 in the previous versions)
• CBRC aka View Storage Accelerator

Make decision appropriately before going for VMFS 6 as it is not compatible with earlier version of esxi and host might not be able to access the datastores. Unfortunately it is not possible to perform an in-place upgrade from VMFS 5 to VMFS 6. To upgrade, you have to perform the following steps:

• Unmount the datastore from all ESX hosts.
• Delete the datastore formatted with VMFS 5.
• Create a new datastore with the VMFS 6 file system using the same LUN.

Depending on your environment and how much space you have available on your array, this can be a long and painful migration.

Next screen is Partition configuration, I am using all available partition and whole datastore size, Block size is by default 1 MB, Specify granularity for the unmap operation. Unmap granularity equals the block size, which is 1 MB. Storage sectors of the size smaller than 1 MB are not reclaimed. There are two options for space reclamation policy. Low (default), Processes the unmap operations at a low rate. Select None option if you want to disable the space reclamation operations for the datastore, Reclamation is also possible using commands. If everything looks good review the changes in Ready to complete and click finish.

Here my datastore is ready to deploy VMs. It is always a best practice to test the configured item so I will be demonstrating and removing cable from one of the physical NIC adapter to simulate switch or network card failure and will watch how storage multiple path effects to see what happens to VM on the datastore.

If you add another Esxi host adding datastore is not required, This formatted datastore will be automatically be visible once configuring VMKernel ports and iSCSI software adapter. add datastore need to run once only for newly presented storage disk, also once LUN is presented from storage to Esxi always to detect it correctly rescan adapter as well as vmfs.

VMWare vSphere suite (vCenter, Esxi and other products) can be managed using powercli, It is software module installed as same as about to deprecate old vSphere c# client. Prerequisite is you must have Powershell on the client desktop or server from you are managing vSphere, by default Powershell available on microsoft latest OS. There are two options available to install PowerCLI, first method is download vSphere Powercli installer from VMware website, it requires login to VMware site. Installation is very easy and not much interactive. Accept license agreement and Click next until finish.

You can find VMware PowerCLI icon on desktop or in search bar, lanuch it. It opens Windows Powershell, but in the background it runs the script INITIALIZE-POWERCLIENVIRONMENT.PS1 located under location  %program files%\VMware\Infrastructure\vSphere Powercli\Scripts, and loads (Imports) all the required vmware module, These modules can be imported individually as per requirement which I will be showing later in this article when showing second installation method. Incase if you are facing issue and seeing error on the powershell console I suggest you to check below article to resolve issue POWERCLI INITIALIZE-POWERCLIENVIRONMENT.PS1 CANNOT BE LOADED BECAUSE RUNNING SCRIPTS IS DISABLED

I can see the version of VMware Powercli on the title bar. For first time it will ask for Participate in VMware Customer Experience Improvement Program CEIP, Choose your option. from here on I am ready to use it.

Below are all available modules related to VMware and loaded with PowerCLI, It can be viewed imported modules with command Get-Module.

• Initialize-VMware.VimAutomation.HorizonView
• Initialize-VMware.VimAutomation.License
• Initialize-VMware.VimAutomation.vROps
• Initialize-VMware_DeployAutomation
• Initialize-VMware_VimAutomation_Cis
• Initialize-VMware_VumAutomation
• VMware.DeployAutomation
• VMware.ImageBuilder
• VMware.VimAutomation.Cis.Core
• VMware.VimAutomation.Cloud
• VMware.VimAutomation.Common
• VMware.VimAutomation.Core
• VMware.VimAutomation.HA
• VMware.VimAutomation.HorizonView
• VMware.VimAutomation.License
• VMware.VimAutomation.PCloud
• VMware.VimAutomation.Sdk
• VMware.VimAutomation.Storage
• VMware.VimAutomation.Vds
• VMware.VimAutomation.vROps
• VMware.VumAutomation

Now I have my Powercli is installed and setup, think it is as client only, My very first command will be Connect-VIserver vCenterIp_or_FQDN. It connects to vCenter and ask for credentials - Username and Password. If it is successful I see the connection status with server name, port and username, I connected to. While connecting It shows me warning about server certificate and I can ignore it for time being until I install valid public or CA certificate, but for now I don't require it. and My second command is Get-VM, it shows the list of VMs with there status.

Earlier installer wizard was the old method. This second new method is very straight forward, download module directly from online Microsoft PS gallary, This requires no logging to VMware site and can be automated easily in the script. It requires Internet and Administrator rights, After running Find-Module VMware* it shows me all related module in the online Microsoft PSGallary repository. Right now I require one of the main module and I am installing it using command Install-Module VMware.VimAutomation.Core -Confirm:$false, downloaded modules can be found at location C:\Program Files\WindowsPowerShell\Modules. 

Also make sure you are ok with Powershell question and ask for your input Yes or No:
You are installing the modules from an untrusted repository. If you trust this repository, change its Installation Policy value by running the Set-PSRepository cmdlet. Are you sure you want to install the modules from 'PSGallery'?

I can see the list of loaded modules with Get-Module. As Powershell core is available on Linux as well as Mac os there is fling available to install powercli core on Linux from https://labs.vmware.com/flings/powercli-core.

I use Powershell DSC (Desired State Configuration) a lot for windows servers configuration, And I make use of DSC hashtable (configurationdata) frequently. Here is Microsoft fantastic article guide for writing DSC hashtable. But while adding multiple node I find sometimes it takes time to adding extra configuration, specifically comma "s, parentheses, braces, equal sign,  (Tabs for in better readable format) need to have sometime special care and one has to spend more time typing them. I wanted a best automated way to write the hashtable format, so it can be easily exported in below dsc data schema, and it will have few or less errors in it.

$MyData = 
@{
    AllNodes = @()
    NonNodeData = ""   
}

Useful Blog related to DSC
POWERSHELL PS REMOTING BETWEEN STANDALONE WORKGROUP COMPUTERS
DSC (DESIRED STATE CONFIGURATION) : DEPLOYING ACTIVE DIRECTORY
PART 1 : POWERSHELL - CREATE LOCAL IIS WEB REPOSITORY FOR DSC MODULE
POWERSHELL: USE PARAMETERS AND CONFIGURATION FROM INI FILE, USE AS SPLATTING
POWERSHELL CREATE HASHTABLE FROM MICROSOFT EXCEL

Most of the time I gather information in Microsoft Excel or my colleagues provide information in same format to me, so I decided to utilize Excel for this task, writing configuration to multiple tabs is easy, I can easily use them and convert to AllNodes automatic hashtable DSC variable, also NonNodedata can also can be mentioned as tab. Below is the strict Excel file format need to follow, Create AllNodes (Name should be same) tab names must contain AllNodes suffixed with . (dot) and numberings, NonNodeData must be as a tab with same name even though it is blank.

Below script I am running as .ps1 file, make sure you can execute ps1 scripts on your computer, Set the execution policy with Set-ExecutionPolicy RemoteSigned.

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132

<#  
  .Synopsis  
   Converts Excel to DSC Configuration Data HashTable format text file.
  .Description  
   This script parses Microsoft Excel file data and coverts to ready to use Powershell DSC (Desired State Configuration) configuration Hashtable format text file. It requires Microsoft Excel to be installed from where you are running this script. Once Excel file is proecess it opens notepad with result, Notpad data can be copied and modified easily.
  .Example  
   ConvertTo-DSCHashTable -ExcelFile C:\temp\Test.xlsx
     
   It parses Microsoft Excel file and create DSC configuration text file, Notpad will automatically open.
  .Example
   Microsoft Excel file format and example, AllNodes data must 
   ----------------------                -----------------------------------   ---------------------------------
   | NodeName | LogPath |                | NodeName | Role      | SiteName |   | ConfigFileContents            | 
   |--------------------|                |----------------------------------   |-------------------------------|
   | *        | C:\Logs |                | VM1      | WebServer | Website1 |   |(Get-Content C:\Temp\Conf.xml) |

   ------------------------------------  ------------------------------------  ------------------------------------
   |*AllNodes.0|AllNodes.1|NonNodeData|  |AllNodes.0|*AllNodes.1|NonNodeData|  |AllNodes.0|AllNodes.1|*NonNodeData| <------ Tabs
   ------------------------------------  ------------------------------------  ------------------------------------
  .OutPuts  
    ConvertTo-DSCHashTable -ExcelFile C:\temp\Test.xlsx
    
    $ConfigurationData = @{
        AllNodes = @(
            @{
                LogPath='C:\Logs'; 
                NodeName='*'
            },

            @{
                Nodename='VM-1'; 
                Role='WebServer'; 
                SiteName='Website1'
            },
        );
        
        NonNodeData = @{		
		    ConfigFileContents=(Get-Content C:\Temp\conf.xml)
	    }
    }

  .Notes  
   NAME: ConvertTo-DSCHashTable
   AUTHOR: Kunal Udapi
   CREATIONDATE: 12 February 2017
   LASTEDIT: 2 July 2017  
   KEYWORDS: Convert excel tab to DSC configuration hashtable  
  .Link  
   #Check Online version: http://kunaludapi.blogspot.com
   #Check Online version: http://vcloud-lab.com
   #Referances: https://msdn.microsoft.com/en-us/powershell/dsc/configdata
   #Requires -Version 3.0  
  #>
[CmdletBinding(SupportsShouldProcess=$True,ConfirmImpact='Medium')]
param(
	[Parameter(
        Position=0, 
        Mandatory=$true,
        ValueFromPipeline=$true,
        HelpMessage='Type the full path of Excel file'
    )]
    [alias('ExcelFile')]
    [ValidateScript({
        If (Test-Path $_) {
            $true
        }
        else{
            "Invalid path given: $_"
        }
    })]
    [System.String]$File
)
$ConfigurationData = @()
#Region  (Parse Excel)
#$File = 'C:\temp\test.xlsx'
$TempFolder = [System.IO.Path]::GetTempPath()
$Guid = [System.Guid]::NewGuid()
$TempDir = Join-Path -Path $TempFolder -ChildPath $Guid.Guid
New-Item -Path $TempDir -ItemType Directory | Out-Null
$excelObj =  New-Object -ComObject Excel.Application
$excelObj.Visible = $false
$excelObj.DisplayAlerts = $false
$WorkBook = $excelObj.Workbooks.Open($File)
$WorkSheets = $WorkBook.Worksheets
Foreach ($WorkSheet in $WorkSheets) {
    $CSVFileName = $WorkSheet.Name
    $CSVFile = Join-Path -Path $TempDir -ChildPath $CSVFileName
    $WorkSheet.SaveAs($CSVFile, 6)
}
$excelObj.Quit()
#Endregion

#Region  (AllNodes)
$AllNodesCSV = Get-ChildItem -Path $TempDir -Filter AllNodes.* | Select-Object -ExpandProperty FullName
$CompleteAllNode =@()
Foreach ($AllNodeRow in $AllNodesCSV) {
    $RowHash = @()
    $ALLNodeCSVRow = Import-Csv $AllNodeRow | Where-Object { ($_.PSObject.Properties | ForEach-Object {$_.Value}) -ne $null}
    $Header = $ALLNodeCSVRow | Get-Member -MemberType NoteProperty | Select-Object -ExpandProperty Name
    foreach ($head in $header) {
        $HashValue = ($ALLNodeCSVRow.$Head | Out-String).Trim()
        $RowHash += "`t`t`t{0}=`"{1}`"" -f $Head, $HashValue
        #"`"$Head`"=`"$($ALLNodeCSVRow.$Head)`""
    }
    $CompleteAllNode += "`t`t@{`n$($RowHash -Join "; `n")`n`t`t}"
}
$AllNodeInfo = $CompleteAllNode -join ",`n`n"
#Endregion

#Region  (NonNodeData)
$NonNodeDataCSV = Get-ChildItem -Path $TempDir -Filter NonNodeData.csv | Select-Object -ExpandProperty FullName
$NonNodeDataCSVRow = Import-Csv $NonNodeDataCSV | Where-Object { ($_.PSObject.Properties | ForEach-Object {$_.Value}) -ne $null}
$CompleteNonNode = @()
if ($NonNodeDataCSVRow -eq $null) {
    $CompleteNonNode = "`t`t`tNonNodeData = `"`""
}
else {
    $NonHeader = $NonNodeDataCSVRow | Get-Member -MemberType NoteProperty | Select-Object -ExpandProperty Name
    $NonNodeRowHeadHash = @()
    foreach ($Nonhead in $NonHeader) {
        $NonNodeHashValue = ($NonNodeDataCSVRow.$Nonhead | Out-String).Trim()
        $NonNodeRowHeadHash += "`t`t{0}=`"{1}`"" -f $NonHead, $NonNodeHashValue
    }
    $CompleteNonNode += "`t`t`n$($NonNodeRowHeadHash -Join "; `n")`n`t"
}
#Endregion
$TmpFileName = [System.IO.Path]::GetTempFileName()
$ConfigurationData = "`$ConfigurationData = @{`n`tAllNodes = @(`n$AllNodeInfo`n`t); `n`n`tNonNodeData = @{$CompleteNonNode}`n}"
Set-Content -Path $TmpFileName -Value $($ConfigurationData -replace "`n", "`r`n")
Notepad $TmpFileName
#$ConfigurationData | clip.exe
$ConfigurationData

There is only one parameter named File or ExcelFile, is the path to Excel and it is mandetory. Once it is executed it opens notepad with the required formatted data, here on notepad  (Powershell ISE, Visual Studio Code Copy past data) I can again verify the data if there is any mistake, and for minor changes information can be modified straight in the readymade text formatted notepad or choice of editor, instead running script again, Also same information is shown on the console as well, for future use save notepad as it is opened as temporary file.

Incase you require this hashtable in the variable first load the data in variable, and run Invoke-Expression. 

$ConfigurationData = C:\Temp\ConvertTo-DSCHashTable.ps1 -ExcelFile C:\Temp\Test.xlsx
Invoke-Expression $ConfigurationData

All the name and value information within hashtable is stored into variable $ConfigurationData and ready to use in Desired State Configuration