GetLicenseData.ps1
function GetLicenseData { [string]$licenseDownloadURL = "https://learn.microsoft.com/en-us/entra/identity/users/licensing-service-plan-reference" $licenseJSON = $null $licenseExport = $global:logFile.replace(".log",".csv") try { out-logfile -string "Invoking web request to obtain HTML data." $functionHTMLData = invoke-WebRequest -URI $licenseDownloadURL -errorAction STOP out-logfile -string "License URL HTML successfully obtained." } catch { out-logfile -string "Unable to obtain the license HTML Data." out-logfile -string $_ -isError:$TRUE } $functionDownloadLink = $functionHTMLData.links | where {$_.innerText -eq "Here"} $functionDownloadLink = $functionDownloadLink.href try { out-logfile -string "Attempting to obtain the license CSV." $functionCSVData = Invoke-WebRequest -Uri $functionDownloadLink -errorAction Stop out-logfile -string "The license CSV data was successfully obtained." } catch { out-logfile -string "Unable to obtain the license CSV data." out-logfile -string $_ -isError:$TRUE } out-logfile -string "Converting the raw data downloaded to CSV format." try { $functionCSVData = ConvertFrom-CSV $functionCSVData -ErrorAction STOP } catch { out-logfile -string "Unable to convert the data to CSV." out-logfile -string $_ -errorAction:STOP } out-logfile -string "Retaining the CSV file that was used for evaluation on this run." try { $functionCSVData | export-csv $licenseExport -errorAction STOP } catch { out-logfile -string "Unable to export the csv license data." out-logfile -string $_ -isError:$TRUE } out-logfile -string "Convert the CSV file to indexed hash tables." $skuCSV = $functionCSVData | Group-Object String_ID | ForEach-Object {$_.Group[0] } $servicePlanCSV = $functionCSVData | Group-Object Service_Plan_Name | ForEach-Object {$_.Group[0] } $global:skuHash = @{} $global:servicePlanHash = @{} foreach ($member in $skuCSV) { $key = $member.string_ID $global:skuHash[$key] = $member } foreach ($member in $servicePlanCSV) { $key = $member.Service_Plan_Name $global:servicePlanhash[$key] = $member } } |