AzureScout

2.4.0

Modules/Public/InventoryModules/Management/DevOpsAgentPools.ps1

<#
.Synopsis
Inventory for Azure DevOps Agent Pools

.DESCRIPTION
This script consolidates information for all devops/agentpools resources, separating
Microsoft-hosted pools from self-hosted ones so the infrastructure you are responsible
for is distinguishable at a glance.

Excel Sheet Name: ADO Agent Pools

.Link
https://github.com/thisismydemo/azure-scout/Modules/Public/InventoryModules/Management/DevOpsAgentPools.ps1

.COMPONENT
This PowerShell Module is part of Azure Scout (AZSC)

.NOTES
Version: 1.0.0
Work item: AB#327
Authors: AzureScout Contributors
#>

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

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

If ($Task -eq 'Processing')
{
    $devOpsPools = $Resources | Where-Object { $_.TYPE -eq 'devops/agentpools' }

    if ($devOpsPools)
    {
        $tmp = foreach ($1 in $devOpsPools) {
            $ResUCount = 1
            $data = $1.properties

            # isHosted true means Microsoft runs the agents; false means the customer does,
            # which is the set that carries patching and capacity obligations.
            $hosting = if ($data.PSObject.Properties.Name -contains 'isHosted' -and $data.isHosted) {
                'Microsoft-hosted'
            } else { 'Self-hosted' }

            $createdOn = if ($data.PSObject.Properties.Name -contains 'createdOn' -and $data.createdOn) {
                ([datetime]$data.createdOn).ToString('MM/dd/yyyy HH:mm')
            } else { $null }

            $owner = if ($data.PSObject.Properties.Name -contains 'owner' -and $data.owner) {
                $data.owner.displayName
            } else { $null }

            $isLegacy = if ($data.PSObject.Properties.Name -contains 'isLegacy') { [string]$data.isLegacy } else { $null }
            $autoProvision = if ($data.PSObject.Properties.Name -contains 'autoProvision') { [string]$data.autoProvision } else { $null }

            $obj = @{
                'ID'             = $1.id;
                'Organization'   = $1.organization;
                'Pool Name'      = $1.name;
                'Pool ID'        = $data.id;
                'Hosting Model'  = $hosting;
                'Pool Type'      = $data.poolType;
                'Agent Size'     = $data.size;
                'Auto Provision' = $autoProvision;
                'Legacy'         = $isLegacy;
                'Created On'     = $createdOn;
                'Owner'          = $owner;
                'Resource U'     = $ResUCount
            }
            $obj
        }
        $tmp
    }
}

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

Else
{
    if ($SmaResources)
    {
        $TableName = ('ADOAgentPoolsTable_' + (($SmaResources.'Resource U' | Measure-Object -Sum).Sum))
        $Style = New-ExcelStyle -HorizontalAlignment Center -AutoSize -NumberFormat '0'

        # Column D is Hosting Model, following the $Exc ordering below.
        $condtxt = @()
        $condtxt += New-ConditionalText -Text 'Self-hosted' -Range D:D -ConditionalType ContainsText -BackgroundColor Yellow

        $Exc = New-Object System.Collections.Generic.List[System.Object]
        $Exc.Add('Organization')
        $Exc.Add('Pool Name')
        $Exc.Add('Pool ID')
        $Exc.Add('Hosting Model')
        $Exc.Add('Pool Type')
        $Exc.Add('Agent Size')
        $Exc.Add('Auto Provision')
        $Exc.Add('Legacy')
        $Exc.Add('Created On')
        $Exc.Add('Owner')
        $Exc.Add('Resource U')

        [PSCustomObject]$SmaResources |
        ForEach-Object { $_ } | Select-Object $Exc |
        Export-Excel -Path $File -WorksheetName 'ADO Agent Pools' -AutoSize -MaxAutoSizeRows 100 -TableName $TableName -TableStyle $tableStyle -ConditionalText $condtxt -Style $Style
    }
}