Converting Lun Serial to Serialhex - CMODE using Powershell

Diarmuid — Fri, 03 Nov 2023 13:31:53 GMT

I am trying to find a way to convert a LUN SerialNumber to a Serial-hex using powershell - unfortunately this is not an option off the get-nclun applet.

I want to use a CSV column containing Lun Serials as my data source and replace the data with the serial-hex. I initially tried this

# Replace 'input.csv' and 'output.csv' with your file paths

$inputFile = 'input.csv'

$outputFile = 'output.csv'

# Read the CSV file

$data = Import-Csv $inputFile

# Convert the 'ColumnName' column from decimal to hexadecimal

$data = $data | ForEach-Object {

$_.ColumnName = [Convert]::ToString([int]$_.ColumnName, 16)

}

# Export the updated data to a new CSV file

$data | Export-Csv -Path $outputFile -NoTypeInformation

However an error of this type is returned for each line - "Cannot convert value "83J6k$UbONg6" to type "System.Int32". Error: "Input string was not in a correct format."

I found this article

https://community.netapp.com/t5/Microsoft-Virtualization-Discussions/Any-way-to-get-lun-serial-number-in-hex-through-powershell/m-p/28647

However when the concept to CMODE I am getting back an 82 character string as opposed to the 24 character I would expect.

I have also tried format-hex and other functions but what mechanism I use I end up with an incorrect result. Additionally I seem to be encountering is the use of '$' in the Lun Serials which confuses powershell.

Help!

Re: Converting Lun Serial to Serialhex - CMODE using Powershell

RobDBA — Mon, 06 Nov 2023 16:07:31 GMT

Use the ConvertTo-HexString function in that linked article. It works just fine with the cluster mode serial. There are several ways to get Powershell to ignore special characters in data.

topic Converting Lun Serial to Serialhex - CMODE using Powershell in Microsoft Virtualization Discussions

Converting Lun Serial to Serialhex - CMODE using Powershell

Re: Converting Lun Serial to Serialhex - CMODE using Powershell