The script looks really impressive good work. I seem to have a problem getting the html file though. I am using these commands from your website...
Function Get-LicenseReport{
param (
[string]$htmlfile,
[string]$CustomerNumber,
[string]$Name,
[string]$Email
)
$Head=@"
<Title>License Report for $($global:DefaultVIServer.name)</Title>
<Style type="text/css">
P.myinfo {text-align: Left}
body {
margin-left: 20%;
margin-right: 20%;
padding-top: 30px;
padding-bottom: 40px;
color: #2E2E2E;
background-color: #E6E6E6 }
table.gridtable {
font-family: verdana,arial,sans-serif;
font-size:11px;
color:#333333;
border-width: 1px;
border-color: #666666;
border-collapse: collapse;
}
table.gridtable th {
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #666666;
background-color: #dedede;
}
table.gridtable td {
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #666666;
background-color: #ffffff;
}
</Style>
"@
$PreContent=@"
<center>
<p><h1>License Report</h1></p>
<p class="myinfo">VMware License Review – for VC:<b> $($global:DefaultVIServer.name) </b></br>
Customer Number:<b> $CustomerNumber </b></br>
Name of Person completing this form: <b>$Name</b></br>
Email of Person completing this form: <b>$Email</b></br>
Date: <b> $(get-date) </b></br></br</p>
"@
if(-not ($global:DefaultVIServer) ) {
Write-Host -ForegroundColor Red -BackgroundColor Black "You are not connected to any VirtualCenter server. Please connect manually."
Write-Host -ForegroundColor Yellow -BackgroundColor Black "hint: Connect-VIServer -server myVC.domain.biz -Credential (Get-Credential)"
break
}
$param = @($null)
$ServiceInstance = Get-View ServiceInstance
$LicenseManager= Get-view $ServiceInstance.Content.LicenseManager
$LicenseAssignmentManager= Get-View $LicenseManager.LicenseAssignmentManager
$LicensesArrayList=New-Object System.Collections.ArrayList
$LicenseAssignmentManager.GetType().GetMethod("QueryAssignedLicenses").Invoke($LicenseAssignmentManager,$param) |Foreach-Object{
$License=New-Object -TypeName PsObject -Property @{ProductName=$null;Version=$null;Edition=$null;DisplayName=$null;PhysProcessors=$null;CoresPerCpu=$null}
$License.ProductName= ($_.Properties.GetEnumerator()|?{$_.Key -eq 'ProductName'}).Value
$License.Version= ($_.Properties.GetEnumerator()|?{$_.Key -eq 'ProductVersion'}).Value
$License.Edition= $_.AssignedLicense.Name
$License.DisplayName=$_.EntityDisplayName
if($_.AssignedLicense.EditionKey -like "vco*"){
$License.DisplayName+=" Used: $($_.AssignedLicense.Used) from: $($_.AssignedLicense.Total)"
}
if($_.EntityId -like "host-*"){
$HostView=Get-View -Id "HostSystem-$($_.EntityID)"
$License.PhysProcessors=$HostView.Hardware.CpuInfo.NumCpuPackages
$License.CoresPerCpu=$hostview.Hardware.CpuInfo.NumCpuCores/$HostView.Hardware.CpuInfo.NumCpuPackages
}
else {
$License.PhysProcessors="N/A"
$License.CoresPerCpu="N/A"
}
$LicensesArrayList.Add($License)|Out-Null
}
if($htmlfile){
($LicensesArrayList | Select-Object ProductName,Version,Edition,DisplayName,CoresPerCpu,PhysProcessors | ConvertTo-Html -PreContent $PreContent -Head $Head ) -Replace '<table>','<table class="gridtable">' |Out-File $htmlfile
}
else{
return $LicensesArrayList
}
}
No errors appear and it just stays like that on the screen. Forgive me if i am doing anything wrong but im new to powercli to testing things 🙂 Any help would be much appreciated
Grzesiekk
