How to make the Powershell code dynamic

Question

I have a below line of code where, I want the MSSQL16 should be made dynamic I.e., it should be able to accept any other values ex: test.MSSQLSERVER

$Targetresource.Productkey = Get-ItemProperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL16.MSSQLSERVER\productkey’

Answer 1

The easiest way would be to change those single quotes to double quotes and use variable interpolation.

$targetname = "test"
$Targetresource.Productkey = Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$targetname.MSSQLSERVER\productkey"

A more readable way might be to use the format operator "-f".

$targetname = test
$target = 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\{0}.MSSQLSERVER\productkey' -f $targetname
$Targetresource.Productkey = Get-ItemProperty $target