AzureResourceInventory

3.6.0-Beta2

Modules/Public/InventoryModules/Compute/VirtualMachineScaleSet.ps1

                                <#

.Synopsis

Inventory for Azure Virtual Machine Scale Set

.DESCRIPTION

This script consolidates information for all microsoft.compute/virtualmachinescalesets resource provider in $Resources variable. 

Excel Sheet Name: VMSS

.Link

https://github.com/microsoft/ARI/Modules/Public/InventoryModules/Compute/VirtualMachineScaleSet.ps1

.COMPONENT

This powershell Module is part of Azure Resource Inventory (ARI)

.NOTES

Version: 3.6.0

First Release Date: 19th November, 2020

Authors: Claudio Merola and Renato Gregio 

#>

<######## Default Parameters. Don't modify this ########>

param($SCPath, $Sub, $Intag, $Resources, $Retirements, $Task ,$File, $SmaResources, $TableStyle, $Unsupported)

If ($Task -eq 'Processing')

{

    <######### Insert the resource extraction here ########>

        $vmss = $Resources | Where-Object {$_.TYPE -eq 'microsoft.compute/virtualmachinescalesets'}

        $AutoScale = $Resources | Where-Object {$_.TYPE -eq "microsoft.insights/autoscalesettings" -and $_.Properties.enabled -eq 'true'} 

        $AKS = $Resources | Where-Object {$_.TYPE -eq 'microsoft.containerservice/managedclusters'}

        $SFC = $Resources | Where-Object {$_.TYPE -eq 'microsoft.servicefabric/clusters'}

        $VMExtraDetails = $Resources | Where-Object { $_.TYPE -eq 'ARI/VM/SKU' }

        $VMQuotas = $Resources | Where-Object { $_.TYPE -eq 'ARI/VM/Quotas' }

    <######### Insert the resource Process here ########>

    if($vmss)

        {

            $tmp = foreach ($1 in $vmss) {

                $ResUCount = 1

                $sub1 = $SUB | Where-Object { $_.id -eq $1.subscriptionId }

                $data = $1.PROPERTIES

                $OS = $data.virtualMachineProfile.storageProfile.osDisk.osType

                $RelatedAKS = ($AKS | Where-Object {$_.properties.nodeResourceGroup -eq $1.resourceGroup}).Name

                if([string]::IsNullOrEmpty($RelatedAKS)){$Related = ($SFC | Where-Object {$_.Properties.clusterEndpoint -in $1.properties.virtualMachineProfile.extensionProfile.extensions.properties.settings.clusterEndpoint}).Name}else{$Related = $RelatedAKS}

                $Scaling = ($AutoScale | Where-Object {$_.Properties.targetResourceUri -eq $1.id})

                if([string]::IsNullOrEmpty($Scaling)){$AutoSc = $false}else{$AutoSc = $true}

                $Diag = if($data.virtualMachineProfile.diagnosticsProfile){'Enabled'}else{'Disabled'}

                if($OS -eq 'Linux'){$PWD = $data.virtualMachineProfile.osProfile.linuxConfiguration.disablePasswordAuthentication}Else{$PWD = 'N/A'}

                $AcceleratedNet = if(![string]::IsNullOrEmpty($data.virtualMachineProfile.networkProfile.networkInterfaceConfigurations.properties.enableAcceleratedNetworking)){$true}else{$false} 

                # Extra Hardware Details

                $VMExtraDetail = $VMExtraDetails.properties | Where-Object {$_.Location -eq $1.location}

                $VMExtraDetail = $VMExtraDetail.SKUs | Where-Object {$_.Name -eq $1.sku.name}

                foreach ($Capability in $VMExtraDetail.Capabilities) {

                    if ($Capability.Name -eq 'vCPUs') {$vCPUs = $Capability.Value}

                    if ($Capability.Name -eq 'vCPUsPerCore') {$vCPUsPerCore = $Capability.Value}

                    if ($Capability.Name -eq 'MemoryGB') {$RAM = $Capability.Value}

                    if ($Capability.Name -eq 'MaxDataDiskCount') {$MaxDataDiskCount = $Capability.Value}

                    if ($Capability.Name -eq 'UncachedDiskIOPS') {$UncachedDiskIOPS = $Capability.Value}

                    if ($Capability.Name -eq 'UncachedDiskBytesPerSecond') {$UncachedDiskBytesPerSecond = ([math]::Round($Capability.Value / 1024) / 1024)}

                    if ($Capability.Name -eq 'MaxNetworkInterfaces') {$MaxNetworkInterfaces = $Capability.Value}

                }

                # Quotas

                $Size = $VMExtraDetail.Family

                $Quota = $VMQuotas.properties | Where-Object {$_.SubId -eq $1.subscriptionId}

                $Quota = $Quota | Where-Object {$_.Location -eq $1.location}

                $RemainingQuota = (($Quota.Data | Where-Object {$_.Name.Value -eq $Size}).Limit - ($Quota.Data | Where-Object {$_.Name.Value -eq $Size}).CurrentValue)

                $timecreated = $data.timeCreated

                $timecreated = [datetime]$timecreated

                $timecreated = $timecreated.ToString("yyyy-MM-dd HH:mm")

                $Retired = Foreach ($Retirement in $Retirements)

                    {

                        if ($Retirement.id -eq $1.id) { $Retirement }

                    }

                if ($Retired) 

                    {

                        $RetiredFeature = foreach ($Retire in $Retired)

                            {

                                $RetiredServiceID = $Unsupported | Where-Object {$_.Id -eq $Retired.ServiceID}

                                $tmp0 = [pscustomobject]@{

                                        'RetiredFeature'            = $RetiredServiceID.RetiringFeature

                                        'RetiredDate'               = $RetiredServiceID.RetirementDate 

                                    }

                                $tmp0

                            }

                        $RetiringFeature = if ($RetiredFeature.RetiredFeature.count -gt 1) { $RetiredFeature.RetiredFeature | ForEach-Object { $_ + ' ,' } }else { $RetiredFeature.RetiredFeature}

                        $RetiringFeature = [string]$RetiringFeature

                        $RetiringFeature = if ($RetiringFeature -like '* ,*') { $RetiringFeature -replace ".$" }else { $RetiringFeature }

                        $RetiringDate = if ($RetiredFeature.RetiredDate.count -gt 1) { $RetiredFeature.RetiredDate | ForEach-Object { $_ + ' ,' } }else { $RetiredFeature.RetiredDate}

                        $RetiringDate = [string]$RetiringDate

                        $RetiringDate = if ($RetiringDate -like '* ,*') { $RetiringDate -replace ".$" }else { $RetiringDate }

                    }

                else 

                    {

                        $RetiringFeature = $null

                        $RetiringDate = $null

                    }

                $Subnet = $data.virtualMachineProfile.networkProfile.networkInterfaceConfigurations.properties.ipConfigurations.properties.subnet.id | Select-Object -Unique

                $VNET = if(![string]::IsNullOrEmpty($subnet)){$Subnet.split('/')[8]}else{$null}

                $Subnet = if(![string]::IsNullOrEmpty($Subnet)){$Subnet.split('/')[10]}else{$null}

                $ext = @()

                $ext = foreach ($ex in $1.Properties.virtualMachineProfile.extensionProfile.extensions.name) 

                                {

                                    $ex + ', '

                                }

                $NSG = if(![string]::IsNullOrEmpty($data.virtualMachineProfile.networkProfile.networkInterfaceConfigurations.properties.networkSecurityGroup.id)){($data.virtualMachineProfile.networkProfile.networkInterfaceConfigurations.properties.networkSecurityGroup.id).split('/')[8]}else{'Not Configured'}

                $Tags = if(![string]::IsNullOrEmpty($1.tags.psobject.properties)){$1.tags.psobject.properties}else{'0'}

                foreach ($Tag in $Tags) {

                    $obj = @{

                        'ID'                            = $1.id;

                        'Subscription'                  = $sub1.Name;

                        'Resource Group'                = $1.RESOURCEGROUP;

                        'AKS / SFC'                     = $Related;

                        'Name'                          = $1.NAME;

                        'Location'                      = $1.LOCATION;

                        'SKU Tier'                      = $1.sku.tier;

                        'Retiring Feature'              = $RetiringFeature;

                        'Retiring Date'                 = $RetiringDate;

                        'Fault Domain'                  = $data.platformFaultDomainCount;

                        'Upgrade Policy'                = $data.upgradePolicy.mode;                                    

                        'Diagnostics'                   = $Diag;

                        'VM Size'                       = $1.sku.name;

                        'Instances'                     = $1.sku.capacity;

                        'vCPUs (per Instance)'          = $vCPUs;

                        'vCPUs per Core (per Instance)' = $vCPUsPerCore;

                        'Memory (GB) (per Instance)'    = $RAM;

                        'Remaining Quota'               = $RemainingQuota;

                        'Autoscale Enabled'             = $AutoSc;

                        'VM OS'                         = $OS;

                        'OS Image'                      = $data.virtualMachineProfile.storageProfile.imageReference.offer;

                        'Image Version'                 = $data.virtualMachineProfile.storageProfile.imageReference.sku;                            

                        'VM OS Disk Size (GB)'          = $data.virtualMachineProfile.storageProfile.osDisk.diskSizeGB;

                        'Disk Storage Account Type'     = $data.virtualMachineProfile.storageProfile.osDisk.managedDisk.storageAccountType;

                        'Disable Password Authentication'= $PWD;

                        'Custom DNS Servers'            = [string]$data.virtualMachineProfile.networkProfile.networkInterfaceConfigurations.properties.dnsSettings.dnsServers;

                        'Virtual Network'               = $VNET;

                        'Subnet'                        = $Subnet;

                        'Accelerated Networking Enabled'= $AcceleratedNet; 

                        'Network Security Group'        = $NSG;

                        'Extensions'                    = [string]$ext;

                        'Admin Username'                = $data.virtualMachineProfile.osProfile.adminUsername;

                        'VM Name Prefix'                = $data.virtualMachineProfile.osProfile.computerNamePrefix;

                        'Created Time'                  = $timecreated;

                        'Resource U'                    = $ResUCount;

                        'Tag Name'                      = [string]$Tag.Name;

                        'Tag Value'                     = [string]$Tag.Value

                    }

                    $obj

                    if ($ResUCount -eq 1) { $ResUCount = 0 } 

                }

            }

            $tmp

        }

}

<######## Resource Excel Reporting Begins Here ########>

Else

{

    <######## $SmaResources.(RESOURCE FILE NAME) ##########>

    if($SmaResources)

    {

        $SheetName = 'Virtual Machine Scale Sets'

        $TableName = ('VMSSTable_'+($SmaResources.'Resource U').count)

        $Style = @()        

        $Style += New-ExcelStyle -HorizontalAlignment Center -AutoSize -NumberFormat '0' -Range A:W

        $Style += New-ExcelStyle -HorizontalAlignment Center -AutoSize -NumberFormat '0.0' -Range Y:AA

        $Style += New-ExcelStyle -HorizontalAlignment Left -Range W:W -Width 60 -WrapText

        $condtxt = @()

        $condtxt += New-ConditionalText FALSE -Range R:R

        $condtxt += New-ConditionalText Disabled -Range K:K

        $condtxt += New-ConditionalText FALSE -Range AB:AB

        # Quota = 0

        $condtxt += New-ConditionalText 0 -Range Q:Q

        #Retirement

        $condtxt += New-ConditionalText -Range G2:G100 -ConditionalType ContainsText

        $Exc = New-Object System.Collections.Generic.List[System.Object]

        $Exc.Add('Subscription')

        $Exc.Add('Resource Group')

        $Exc.Add('AKS / SFC')

        $Exc.Add('Name')

        $Exc.Add('Location')

        $Exc.Add('SKU Tier')

        $Exc.Add('Retiring Feature')

        $Exc.Add('Retiring Date')

        $Exc.Add('Fault Domain')

        $Exc.Add('Upgrade Policy')                                   

        $Exc.Add('Diagnostics')

        $Exc.Add('VM Size')

        $Exc.Add('Instances')

        $Exc.Add('vCPUs (per Instance)')

        $Exc.Add('vCPUs per Core (per Instance)')

        $Exc.Add('Memory (GB) (per Instance)')

        $Exc.Add('Remaining Quota')

        $Exc.Add('Autoscale Enabled')

        $Exc.Add('VM OS')

        $Exc.Add('OS Image')

        $Exc.Add('Image Version')                        

        $Exc.Add('VM OS Disk Size (GB)')

        $Exc.Add('Disk Storage Account Type')

        $Exc.Add('Disable Password Authentication')

        $Exc.Add('Custom DNS Servers')

        $Exc.Add('Virtual Network')

        $Exc.Add('Subnet')

        $Exc.Add('Accelerated Networking Enabled')

        $Exc.Add('Network Security Group')

        $Exc.Add('Extensions')

        $Exc.Add('Admin Username')

        $Exc.Add('VM Name Prefix')

        $Exc.Add('Created Time')

        if($InTag)

            {

                $Exc.Add('Tag Name')

                $Exc.Add('Tag Value') 

            }

        $SmaResources | 

        ForEach-Object { [PSCustomObject]$_ } | Select-Object $Exc | 

        Export-Excel -Path $File -WorksheetName $SheetName -AutoSize -MaxAutoSizeRows 50 -TableName $TableName -TableStyle $tableStyle -ConditionalText $condtxt -Style $Style

        $excel = Open-ExcelPackage -Path $File

        $sheet = $excel.Workbook.Worksheets[$SheetName]

        #Remaining Quota

        Add-ConditionalFormatting -WorkSheet $sheet -RuleType Between -ConditionValue 50 -ConditionValue2 100 -Address Q:Q -BackgroundColor "Yellow"

        Add-ConditionalFormatting -WorkSheet $sheet -RuleType Between -ConditionValue 1 -ConditionValue2 50 -Address Q:Q -BackgroundColor 'LightPink' -ForegroundColor 'DarkRed'

        Close-ExcelPackage $excel

    }

}