Get OS and SQL Version information with dbatools

versioninfo.ps1

$servers = Get-DbaRegServer -SqlInstance CmsServerName
$os = Get-DbaOperatingSystem -ComputerName $servers.name
$sql = Get-DbaProductKey -ComputerName $servers.name
 
$excelFile = C:\temp\VersionInfo.xlsx'
 
$osProps = 'ComputerName','Architecture','Version','Build','OSVersion', 'SPVersion', 'InstallDate','LastBootTime', 'ActivePowerPlan'
$sqlProps = 'ComputerName','InstanceName','SqlInstance','Version','Edition'
 
$osExcel = @{
	Path = $excelFile
	WorksheetName = 'OSVersions'
	AutoSize = $true
	TableName = 'OSVersion'
	IncludePivotTable = $true
	PivotRows = 'OSVersion'
	PivotData = @{OSVersion='Count'}
	IncludePivotChart = $true
	ChartType = 'ColumnClustered'
}
 
$os | Select-Object $osProps | export-excel @osExcel
 
$sqlExcel = @{
	Path = $excelFile
	WorksheetName = 'SQLVersions'
	AutoSize = $true
	TableName = 'SQLVersions'
	IncludePivotTable = $true
	PivotRows = 'Version'
	PivotData = @{Version='Count'}
	IncludePivotChart = $true
	ChartType = 'ColumnClustered'
}
 
$sql | Select-Object $sqlProps | export-excel @sqlExcel

In case others decide to use this, looks like single quote missing from $excelFile