Public/Get-AvdImageVersionStatus.ps1
|
#requires -module @{ModuleName = 'Az.ResourceGraph'; ModuleVersion = '0.7.6'} Function Get-AvdImageVersionStatus { <# .SYNOPSIS Gets the image version from where the session host is started from. .DESCRIPTION The function will help you getting insights if there are session hosts started from an old version in relation to the Shared Image Gallery .PARAMETER HostpoolName Enter the AVD Hostpool name .PARAMETER ResourceGroupName Enter the AVD Hostpool resourcegroup name .PARAMETER SessionHostName Enter the session host name. .PARAMETER NotLatest This is a switch parameter which let you control the output to show only the sessionhosts which are not started from the latest version. .EXAMPLE Get-AvdImageVersionStatus -HostpoolName avd-hostpool-001 -ResourceGroupName rg-avd-001 #> [CmdletBinding(DefaultParameterSetName = 'Hostpool')] param ( [parameter(Mandatory, ParameterSetName = 'Hostpool')] [parameter(Mandatory, ParameterSetName = 'Sessionhost')] [ValidateNotNullOrEmpty()] [string]$HostpoolName, [parameter(Mandatory, ParameterSetName = 'Hostpool')] [parameter(Mandatory, ParameterSetName = 'Sessionhost')] [ValidateNotNullOrEmpty()] [string]$ResourceGroupName, [parameter(ParameterSetName = 'Sessionhost')] [ValidateNotNullOrEmpty()] [string]$SessionHostName, [parameter()] [switch]$NotLatest ) Begin { Write-Verbose "Start searching" AuthenticationCheck } Process { switch ($PsCmdlet.ParameterSetName) { Sessionhost { $Parameters = @{ HostPoolName = $HostpoolName ResourceGroupName = $ResourceGroupName Name = $SessionHostName } } Default { $Parameters = @{ HostPoolName = $HostpoolName ResourceGroupName = $ResourceGroupName } } } try { $SessionHosts = Get-AzWvdSessionHost @Parameters } catch { Throw "No sessionhosts found, $_" } $sessionhostsIds = [system.String]::Join("`",`"", $SessionHosts.ResourceId) $sessionhostsName = $SessionHosts.Name.Split("/")[-1] $Query = 'resources | where type =~ "microsoft.compute/virtualmachines" and isnotempty(properties.storageProfile.imageReference.exactVersion) and id in~ ("'+ $sessionhostsIds + '") | extend currentImageVersion = properties.storageProfile.imageReference.exactVersion | extend imageName=split(properties.storageProfile.imageReference.id,"/")[10] | project tostring(imageName), tostring(currentImageVersion), vmId=id, vmName=name, hostpoolName = tolower("'+ $HostpoolName + '"), ResourceGroupName = "' + $ResourceGroupName + '", sessionHostName = "' + $sessionhostsName + '" | join kind=inner( resources | where type=~"microsoft.compute/galleries/images/versions" | extend imageName=split(id,"/")[10] | project id, name, tostring(imageName) | join kind=inner ( resources | where type =~ "microsoft.compute/galleries/images/versions" | extend versionDetails=split(id,"/") | project id, name, imageName=versionDetails[10], imageGallery=versionDetails[8], resourceGroup, subscriptionId | summarize lastVersion=max(tostring(name)) by tostring(imageName) , tostring(imageGallery), resourceGroup, subscriptionId ) on imageName | extend latestVersion = case(name != lastVersion, false, true) | where latestVersion == true ) on imageName | extend vmLatestVersion = case(currentImageVersion != lastVersion, false, true) | extend vmDetails = split(vmId,"/") | join kind=inner ( resources | where type =~ "microsoft.desktopvirtualization/hostpools" and name =~ "'+ $HostpoolName + '" and resourceGroup =~ "' + $ResourceGroupName + '" | extend vmTemplate=parse_json(tostring(parse_json(properties.vmTemplate))) | extend registrationInfo=properties.registrationInfo | project hostpoolName=tolower(name), resourceGroup, domain=vmTemplate.domain ) on hostpoolName | project vmLatestVersion,vmName,imageName, currentImageVersion, vmId, imageGallery, resourceGroupName=resourceGroup, subscriptionId, lastVersion, hostpoolName, sessionHostName=strcat(vmName, ".", domain) ' if ($NotLatest.IsPresent) { $LatestQuery = '| where vmLatestVersion == false' $Query = $Query + $LatestQuery } return Search-AzGraph -Query $Query } } |