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' ) ResourceTypeMatching = 'Grouped' AdditionalFilter = $null FilterPreamble = '' RowLoopVariable = '1' Preamble = @' $ResUCount = 1 # An EMPTY $sub1 is not $null -- the match is empty for any resource whose subscription # is outside the requested scope -- and reading .Name off an empty collection throws # under StrictMode (AB#5671). Resolved once here, as VirtualMachine.ps1 already does. $sub1 = $SUB | Where-Object { $_.id -eq $1.subscriptionId } # The else arm is $null, NOT '': with StrictMode off $sub1.Name on an unmatched ($null) # $sub1 evaluated to $null, and the ~110 collectors that still read $sub1.Name directly # emit $null here. '' was a silent behaviour change -- the declarative equivalence proof # caught it on 11 collectors, and it would have been invisible on the rest (AB#5659). $SubscriptionName = if ($sub1) { @($sub1)[0].Name } else { $null } $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((Get-AZSCSafeProperty -InputObject $data -Path 'network.delegatedsubnetresourceid' -Enumerate))){(Get-AZSCIdSegment -Id (Get-AZSCSafeProperty -InputObject $data -Path 'network.delegatedsubnetresourceid' -Enumerate) -Index 8)}else{$null} $DelegatedSubnet = if(![string]::IsNullOrEmpty((Get-AZSCSafeProperty -InputObject $data -Path 'network.delegatedsubnetresourceid' -Enumerate))){(Get-AZSCIdSegment -Id (Get-AZSCSafeProperty -InputObject $data -Path 'network.delegatedsubnetresourceid' -Enumerate) -Index 10)}else{$null} $PrivateDNSZone = if(![string]::IsNullOrEmpty((Get-AZSCSafeProperty -InputObject $data -Path 'network.privatednszonearmresourceid' -Enumerate))){(Get-AZSCIdSegment -Id (Get-AZSCSafeProperty -InputObject $data -Path 'network.privatednszonearmresourceid' -Enumerate) -Index 8)}else{$null} # AB#5671: an untagged resource's Resource Graph row OMITS the tags property rather # than carrying an empty object, so the raw read throws under StrictMode -- and so # does psobject.properties on a $null. The historic '0' sentinel existed only to make # the tag loop below run ONCE for an untagged resource, but '0'.Name throws too; an # empty tag object runs it once AND emits the identical [string]-cast empty Name/Value. $RowTags = Get-AZSCSafeProperty -InputObject $1 -Path 'tags' $TagProps = if ($null -ne $RowTags) { $RowTags.psobject.properties } else { $null } $Tags = if (![string]::IsNullOrEmpty($TagProps)) { $TagProps } else { [pscustomobject]@{ Name = $null; Value = $null } } '@ AdditionalRowLoops = @() TagLoop = @{ Variable = 'Tag' Source = '$Tags' Preamble = '' } Fields = @( @{ Name = 'ID' Expression = '$1.id' } @{ Name = 'Subscription' Expression = '$SubscriptionName' } @{ 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 = '(Get-AZSCSafeProperty -InputObject $data -Path ''fullyqualifieddomainname'' -Enumerate)' } @{ Name = 'ADMIN Login' Expression = '(Get-AZSCSafeProperty -InputObject $data -Path ''administratorLogin'' -Enumerate)' } @{ Name = 'Version' Expression = '[string]((Get-AZSCSafeProperty -InputObject $data -Path ''version'' -Enumerate)+''.''+(Get-AZSCSafeProperty -InputObject $data -Path ''minorversion'' -Enumerate))' } @{ Name = 'AD Authentication' Expression = '(Get-AZSCSafeProperty -InputObject $data -Path ''authconfig.activedirectoryauth'' -Enumerate)' } @{ Name = 'Password Authentication' Expression = '(Get-AZSCSafeProperty -InputObject $data -Path ''authconfig.passwordauth'' -Enumerate)' } @{ Name = 'Computer Tier' Expression = '(Get-AZSCSafeProperty -InputObject $sku -Path ''tier'' -Enumerate)' } @{ Name = 'Computer Size' Expression = '(Get-AZSCSafeProperty -InputObject $sku -Path ''name'' -Enumerate)' } @{ Name = 'Storage Size (GB)' Expression = '(Get-AZSCSafeProperty -InputObject $data -Path ''storage.storagesizegb'' -Enumerate)' } @{ Name = 'Availability Zone' Expression = '(Get-AZSCSafeProperty -InputObject $data -Path ''availabilityzone'' -Enumerate)' } @{ Name = 'High Availability' Expression = '(Get-AZSCSafeProperty -InputObject $data -Path ''highavailability.state'' -Enumerate)' } @{ Name = 'Data Encryption' Expression = '(Get-AZSCSafeProperty -InputObject $data -Path ''dataencryption.type'' -Enumerate)' } @{ Name = 'Backup Retention (Days)' Expression = '(Get-AZSCSafeProperty -InputObject $data -Path ''backup.backupretentiondays'' -Enumerate)' } @{ Name = 'Geo-Redundant Backup' Expression = '(Get-AZSCSafeProperty -InputObject $data -Path ''backup.geoRedundantBackup'' -Enumerate)' } @{ Name = 'Replication Role' Expression = '(Get-AZSCSafeProperty -InputObject $data -Path ''replicationRole'' -Enumerate)' } @{ Name = 'Replication Capacity' Expression = '(Get-AZSCSafeProperty -InputObject $data -Path ''replicaCapacity'' -Enumerate)' } @{ Name = 'Public Network Access' Expression = '(Get-AZSCSafeProperty -InputObject $data -Path ''network.publicnetworkaccess'' -Enumerate)' } @{ 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' } |