AzureScout

2.7.0

manifests/collectors/Databases/POSTGREFlexible.psd1

#
# GENERATED by scripts/ConvertTo-ScoutCollectorDefinition.ps1 from Modules/Public/InventoryModules/Databases/POSTGREFlexible.ps1 (AB#5660).
# Field expressions are copied verbatim from the original collector and evaluate in an
# equivalent scope -- see docs/design/decisions/declarative-collectors.md.
# Review before trusting; regenerate rather than hand-patch if the source collector changes.
#
@{
    ResourceTypes = @(
        'Microsoft.DBforPostgreSQL/flexibleServers'
    )

    AdditionalFilter = $null

    RowLoopVariable = '1'

    Preamble = @'
$ResUCount = 1
                $sub1 = $SUB | Where-Object { $_.id -eq $1.subscriptionId }
                $data = $1.PROPERTIES
                $sku = $1.SKU
                $Retired = $Retirements | Where-Object { $_.id -eq $1.id }
                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
                    }
                $DelegatedVNET = if(![string]::IsNullOrEmpty($data.network.delegatedsubnetresourceid)){$data.network.delegatedsubnetresourceid.split('/')[8]}else{$null}
                $DelegatedSubnet = if(![string]::IsNullOrEmpty($data.network.delegatedsubnetresourceid)){$data.network.delegatedsubnetresourceid.split('/')[10]}else{$null}
                $PrivateDNSZone = if(![string]::IsNullOrEmpty($data.network.privatednszonearmresourceid)){$data.network.privatednszonearmresourceid.split('/')[8]}else{$null}
                $Tags = if(![string]::IsNullOrEmpty($1.tags.psobject.properties)){$1.tags.psobject.properties}else{'0'}
'@

    AdditionalRowLoops = @()

    Fields = @(
        @{
            Name = 'ID'
            Expression = '$1.id'
        }
        @{
            Name = 'Subscription'
            Expression = '$sub1.Name'
        }
        @{
            Name = 'Resource Group'
            Expression = '$1.RESOURCEGROUP'
        }
        @{
            Name = 'Name'
            Expression = '$1.NAME'
        }
        @{
            Name = 'Location'
            Expression = '$1.LOCATION'
        }
        @{
            Name = 'Retiring Feature'
            Expression = '$RetiringFeature'
        }
        @{
            Name = 'Retiring Date'
            Expression = '$RetiringDate'
        }
        @{
            Name = 'FQDN'
            Expression = '$data.fullyqualifieddomainname'
        }
        @{
            Name = 'ADMIN Login'
            Expression = '$data.administratorLogin'
        }
        @{
            Name = 'Version'
            Expression = '[string]($data.version+''.''+$data.minorversion)'
        }
        @{
            Name = 'AD Authentication'
            Expression = '$data.authconfig.activedirectoryauth'
        }
        @{
            Name = 'Password Authentication'
            Expression = '$data.authconfig.passwordauth'
        }
        @{
            Name = 'Computer Tier'
            Expression = '$sku.tier'
        }
        @{
            Name = 'Computer Size'
            Expression = '$sku.name'
        }
        @{
            Name = 'Storage Size (GB)'
            Expression = '$data.storage.storagesizegb'
        }
        @{
            Name = 'Availability Zone'
            Expression = '$data.availabilityzone'
        }
        @{
            Name = 'High Availability'
            Expression = '$data.highavailability.state'
        }
        @{
            Name = 'Data Encryption'
            Expression = '$data.dataencryption.type'
        }
        @{
            Name = 'Backup Retention (Days)'
            Expression = '$data.backup.backupretentiondays'
        }
        @{
            Name = 'Geo-Redundant Backup'
            Expression = '$data.backup.geoRedundantBackup'
        }
        @{
            Name = 'Replication Role'
            Expression = '$data.replicationRole'
        }
        @{
            Name = 'Replication Capacity'
            Expression = '$data.replicaCapacity'
        }
        @{
            Name = 'Public Network Access'
            Expression = '$data.network.publicnetworkaccess'
        }
        @{
            Name = 'Delegated VNET'
            Expression = '$DelegatedVNET'
        }
        @{
            Name = 'Delegated Subnet'
            Expression = '$DelegatedSubnet'
        }
        @{
            Name = 'Private DNS Zone'
            Expression = '$PrivateDNSZone'
        }
        @{
            Name = 'Resource U'
            Expression = '$ResUCount'
        }
        @{
            Name = 'Tag Name'
            Expression = '[string]$Tag.Name'
        }
        @{
            Name = 'Tag Value'
            Expression = '[string]$Tag.Value'
        }
    )

    Export = @{
        WorksheetName = 'PostgreSQL Flexible'
        TableNamePrefix = 'POSTGFlex_'
        Columns = @(
            'Subscription'
            'Resource Group'
            'Name'
            'Location'
            'Retiring Feature'
            'Retiring Date'
            'FQDN'
            'ADMIN Login'
            'Version'
            'AD Authentication'
            'Password Authentication'
            'Computer Tier'
            'Computer Size'
            'Storage Size (GB)'
            'Availability Zone'
            'High Availability'
            'Data Encryption'
            'Backup Retention (Days)'
            'Geo-Redundant Backup'
            'Replication Role'
            'Replication Capacity'
            'Public Network Access'
            'Delegated VNET'
            'Delegated Subnet'
            'Private DNS Zone'
            'Resource U'
        )
        TagColumns = @(
            'Tag Name'
            'Tag Value'
        )
        TagColumnsBefore = 'Resource U'
        NumberFormat = '0'
        ConditionalText = @(
            'New-ConditionalText enabled -Range V:V'
            'New-ConditionalText notenabled -Range P:P'
            'New-ConditionalText -Range E2:E100 -ConditionalType ContainsText'
        )
    }

    SourceCollector = 'Modules/Public/InventoryModules/Databases/POSTGREFlexible.ps1'
}