Get-AzResource -Name filtering doesn't work with nested databases for Azure SQL #11692
Description
Description
Not sure if that's intended change but running Get-AzResource with the correct value for Name filter doesn't bring any results if its nested resource eg. database under azure sql server
Steps to reproduce
Get-AzResource -ResourceGroupName 'TestResourceGroup'
Name : sqlServerName/DatabaseName
ResourceGroupName : TestResourceGroup
ResourceType : Microsoft.Sql/servers/databases
Location : northeurope
ResourceId : xxxxx
Name : sqlServerName
ResourceGroupName : TestResourceGroup
ResourceType : Microsoft.Sql/servers
Location : northeurope
ResourceId : xxxxx
Input:
Get-AzResource -ResourceGroupName 'TestResourceGroup' -Name 'sqlServerName/DatabaseName'
Comment:
Above command below doesn't bring any results although the value for "Name" is correct. That's working correctly with previous version of Azure Powershell - AzureRM.
oddly enough running it without SQL server name works:
Input:
Get-AzResource -ResourceGroupName 'TestResourceGroup' -Name 'DatabaseName'
Output:
Name : sqlServerName/DatabaseName
ResourceGroupName : TestResourceGroup
ResourceType : Microsoft.Sql/servers/databases
Location : northeurope
ResourceId : xxxxx
Environment data
Name Value
---- -----
PSVersion 5.1.14393.2879
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.14393.2879
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1
Module versions
ModuleType Version Name ExportedCommands
---------- ------- ---- ----------------
Script 1.7.0 Az.Accounts {Disable-AzDataCollection, Disable-AzContextAutosave, Enable-AzDataCollection, Enable-AzContextAutosave...}
Script 1.1.1 Az.Advisor {Get-AzAdvisorRecommendation, Enable-AzAdvisorRecommendation, Disable-AzAdvisorRecommendation, Get-AzAdvi...
Script 1.0.3 Az.Aks {Get-AzAks, New-AzAks, Remove-AzAks, Import-AzAksCredential...}
Script 1.1.2 Az.AnalysisServices {Resume-AzAnalysisServicesServer, Suspend-AzAnalysisServicesServer, Get-AzAnalysisServicesServer, Remove-...
Script 1.3.3 Az.ApiManagement {Add-AzApiManagementApiToProduct, Add-AzApiManagementProductToGroup, Add-AzApiManagementRegion, Add-AzApi...
Script 1.0.3 Az.ApplicationInsights {Get-AzApplicationInsights, New-AzApplicationInsights, Remove-AzApplicationInsights, Set-AzApplicationIns...
Script 1.3.5 Az.Automation {Get-AzAutomationHybridWorkerGroup, Remove-AzAutomationHybridWorkerGroup, Get-AzAutomationJobOutputRecord...
Script 2.0.2 Az.Batch {Remove-AzBatchAccount, Get-AzBatchAccount, Get-AzBatchAccountKey, New-AzBatchAccount...}
Script 1.0.2 Az.Billing {Get-AzBillingInvoice, Get-AzBillingPeriod, Get-AzEnrollmentAccount, Get-AzConsumptionBudget...}
Script 1.4.2 Az.Cdn {Get-AzCdnProfile, Get-AzCdnProfileSsoUrl, New-AzCdnProfile, Remove-AzCdnProfile...}
Script 1.2.2 Az.CognitiveServices {Get-AzCognitiveServicesAccount, Get-AzCognitiveServicesAccountKey, Get-AzCognitiveServicesAccountSku, Ge...
Script 3.3.0 Az.Compute {Remove-AzAvailabilitySet, Get-AzAvailabilitySet, New-AzAvailabilitySet, Update-AzAvailabilitySet...}
Script 1.0.3 Az.ContainerInstance {New-AzContainerGroup, Get-AzContainerGroup, Remove-AzContainerGroup, Get-AzContainerInstanceLog}
Script 1.1.1 Az.ContainerRegistry {New-AzContainerRegistry, Get-AzContainerRegistry, Update-AzContainerRegistry, Remove-AzContainerRegistry...
Script 1.1.0 Az.DataBoxEdge {Get-AzDataBoxEdgeJob, Get-AzDataBoxEdgeDevice, Invoke-AzDataBoxEdgeDevice, New-AzDataBoxEdgeDevice...}
Script 1.6.0 Az.DataFactory {Set-AzDataFactoryV2, Update-AzDataFactoryV2, Get-AzDataFactoryV2, Remove-AzDataFactoryV2...}
Script 1.0.2 Az.DataLakeAnalytics {Get-AzDataLakeAnalyticsDataSource, New-AzDataLakeAnalyticsCatalogCredential, Remove-AzDataLakeAnalyticsC...
Script 1.2.6 Az.DataLakeStore {Get-AzDataLakeStoreTrustedIdProvider, Remove-AzDataLakeStoreTrustedIdProvider, Remove-AzDataLakeStoreFir...
Script 1.0.2 Az.DeploymentManager {Get-AzDeploymentManagerArtifactSource, New-AzDeploymentManagerArtifactSource, Set-AzDeploymentManagerArt...
Script 1.0.2 Az.DevTestLabs {Get-AzDtlAllowedVMSizesPolicy, Get-AzDtlAutoShutdownPolicy, Get-AzDtlAutoStartPolicy, Get-AzDtlVMsPerLab...
Script 1.1.2 Az.Dns {Get-AzDnsRecordSet, New-AzDnsRecordConfig, Remove-AzDnsRecordSet, Set-AzDnsRecordSet...}
Script 1.2.3 Az.EventGrid {New-AzEventGridTopic, Get-AzEventGridTopic, Set-AzEventGridTopic, New-AzEventGridTopicKey...}
Script 1.4.3 Az.EventHub {New-AzEventHubNamespace, Get-AzEventHubNamespace, Set-AzEventHubNamespace, Remove-AzEventHubNamespace...}
Script 1.3.0 Az.FrontDoor {New-AzFrontDoor, Get-AzFrontDoor, Set-AzFrontDoor, Remove-AzFrontDoor...}
Script 3.0.2 Az.HDInsight {Get-AzHDInsightJob, New-AzHDInsightSqoopJobDefinition, Wait-AzHDInsightJob, New-AzHDInsightStreamingMapR...
Script 1.0.1 Az.HealthcareApis {New-AzHealthcareApisService, Remove-AzHealthcareApisService, Set-AzHealthcareApisService, Get-AzHealthca...
Script 2.0.1 Az.IotHub {Add-AzIotHubKey, Get-AzIotHubEventHubConsumerGroup, Get-AzIotHubConnectionString, Get-AzIotHubJob...}
Script 1.4.0 Az.KeyVault {Add-AzKeyVaultCertificate, Update-AzKeyVaultCertificate, Stop-AzKeyVaultCertificateOperation, Get-AzKeyV...
Script 1.3.2 Az.LogicApp {Get-AzIntegrationAccountAgreement, Get-AzIntegrationAccountAssembly, Get-AzIntegrationAccountBatchConfig...
Script 1.1.3 Az.MachineLearning {Move-AzMlCommitmentAssociation, Get-AzMlCommitmentAssociation, Get-AzMlCommitmentPlanUsageHistory, Remov...
Script 1.0.2 Az.ManagedServices {Get-AzManagedServicesAssignment, New-AzManagedServicesAssignment, Remove-AzManagedServicesAssignment, Ge...
Script 1.0.2 Az.MarketplaceOrdering {Get-AzMarketplaceTerms, Set-AzMarketplaceTerms}
Script 1.1.1 Az.Media {Sync-AzMediaServiceStorageKey, Set-AzMediaServiceKey, Get-AzMediaServiceKey, Get-AzMediaServiceNameAvail...
Script 1.5.0 Az.Monitor {Get-AzMetricDefinition, Get-AzMetric, Remove-AzLogProfile, Get-AzLogProfile...}
Script 2.2.1 Az.Network {Add-AzApplicationGatewayAuthenticationCertificate, Get-AzApplicationGatewayAuthenticationCertificate, Ne...
Script 1.1.1 Az.NotificationHubs {Get-AzNotificationHub, Get-AzNotificationHubAuthorizationRule, Get-AzNotificationHubListKey, Get-AzNotif...
Script 1.3.4 Az.OperationalInsights {New-AzOperationalInsightsAzureActivityLogDataSource, New-AzOperationalInsightsCustomLogDataSource, Disab...
Script 1.1.4 Az.PolicyInsights {Get-AzPolicyEvent, Get-AzPolicyState, Get-AzPolicyStateSummary, Get-AzPolicyRemediation...}
Script 1.1.1 Az.PowerBIEmbedded {Remove-AzPowerBIWorkspaceCollection, Get-AzPowerBIWorkspaceCollection, Get-AzPowerBIWorkspaceCollectionA...
Script 1.0.2 Az.PrivateDns {Get-AzPrivateDnsZone, Remove-AzPrivateDnsZone, Set-AzPrivateDnsZone, New-AzPrivateDnsZone...}
Script 2.4.0 Az.RecoveryServices {Get-AzRecoveryServicesBackupProperty, Get-AzRecoveryServicesVault, Get-AzRecoveryServicesVaultSettingsFi...
Script 1.2.1 Az.RedisCache {Remove-AzRedisCachePatchSchedule, New-AzRedisCacheScheduleEntry, Get-AzRedisCachePatchSchedule, New-AzRe...
Script 1.0.3 Az.Relay {New-AzRelayNamespace, Get-AzRelayNamespace, Set-AzRelayNamespace, Remove-AzRelayNamespace...}
Script 1.9.1 Az.Resources {Get-AzProviderOperation, Remove-AzRoleAssignment, Get-AzRoleAssignment, New-AzRoleAssignment...}
Script 1.4.1 Az.ServiceBus {New-AzServiceBusNamespace, Get-AzServiceBusNamespace, Set-AzServiceBusNamespace, Remove-AzServiceBusName...
Script 2.0.1 Az.ServiceFabric {Add-AzServiceFabricClientCertificate, Add-AzServiceFabricClusterCertificate, Add-AzServiceFabricNode, Ad...
Script 1.1.1 Az.SignalR {New-AzSignalR, Get-AzSignalR, Get-AzSignalRKey, New-AzSignalRKey...}
Script 2.1.2 Az.Sql {Get-AzSqlDatabaseTransparentDataEncryption, Get-AzSqlDatabaseTransparentDataEncryptionActivity, Set-AzSq...
Script 1.0.2 Az.SqlVirtualMachine {New-AzSqlVM, Get-AzSqlVM, Update-AzSqlVM, Remove-AzSqlVM...}
Script 1.11.0 Az.Storage {Get-AzStorageAccount, Get-AzStorageAccountKey, New-AzStorageAccount, New-AzStorageAccountKey...}
Script 1.2.2 Az.StorageSync {Invoke-AzStorageSyncCompatibilityCheck, New-AzStorageSyncService, Get-AzStorageSyncService, Remove-AzSto...
Script 1.0.1 Az.StreamAnalytics {Get-AzStreamAnalyticsFunction, Get-AzStreamAnalyticsDefaultFunctionDefinition, New-AzStreamAnalyticsFunc...
Script 1.0.3 Az.TrafficManager {Add-AzTrafficManagerCustomHeaderToEndpoint, Remove-AzTrafficManagerCustomHeaderFromEndpoint, Add-AzTraff...
Script 1.5.1 Az.Websites {Get-AzAppServicePlan, Set-AzAppServicePlan, New-AzAppServicePlan, Remove-AzAppServicePlan...}
Script 5.3.0 Azure {Get-AzureAutomationCertificate, Get-AzureAutomationConnection, New-AzureAutomationConnection, Remove-Azu...
Script 0.5.4 Azure.AnalysisServices {Add-AzureAnalysisServicesAccount, Restart-AzureAnalysisServicesInstance, Export-AzureAnalysisServicesIns...
Script 4.6.1 Azure.Storage {Get-AzureStorageTable, New-AzureStorageTableSASToken, New-AzureStorageTableStoredAccessPolicy, New-Azure...
Script 6.13.1 AzureRM
Script 0.6.14 AzureRM.AnalysisServices {Resume-AzureRmAnalysisServicesServer, Suspend-AzureRmAnalysisServicesServer, Get-AzureRmAnalysisServices...
Script 6.1.7 AzureRM.ApiManagement {Add-AzureRmApiManagementRegion, Get-AzureRmApiManagementSsoToken, New-AzureRmApiManagementHostnameConfig...
Script 0.1.8 AzureRM.ApplicationInsights {Get-AzureRmApplicationInsights, New-AzureRmApplicationInsights, Remove-AzureRmApplicationInsights, Set-A...
Script 6.1.1 AzureRM.Automation {Get-AzureRMAutomationHybridWorkerGroup, Remove-AzureRmAutomationHybridWorkerGroup, Get-AzureRmAutomation...
Script 4.0.11 AzureRM.Backup {Backup-AzureRmBackupItem, Enable-AzureRmBackupContainerReregistration, Get-AzureRmBackupContainer, Regis...
Script 4.1.5 AzureRM.Batch {Remove-AzureRmBatchAccount, Get-AzureRmBatchAccount, Get-AzureRmBatchAccountKeys, New-AzureRmBatchAccoun...
Script 0.14.6 AzureRM.Billing {Get-AzureRmBillingInvoice, Get-AzureRmBillingPeriod, Get-AzureRmEnrollmentAccount}
Script 5.0.6 AzureRM.Cdn {Get-AzureRmCdnProfile, Get-AzureRmCdnProfileSsoUrl, New-AzureRmCdnProfile, Remove-AzureRmCdnProfile...}
Script 0.9.12 AzureRM.CognitiveServices {Get-AzureRmCognitiveServicesAccount, Get-AzureRmCognitiveServicesAccountKey, Get-AzureRmCognitiveService...
Script 5.9.1 AzureRM.Compute {Remove-AzureRmAvailabilitySet, Get-AzureRmAvailabilitySet, New-AzureRmAvailabilitySet, Update-AzureRmAva...
Script 0.3.7 AzureRM.Consumption {Get-AzureRmConsumptionBudget, Get-AzureRmConsumptionMarketplace, Get-AzureRmConsumptionPriceSheet, Get-A...
Script 0.2.12 AzureRM.ContainerInstance {New-AzureRmContainerGroup, Get-AzureRmContainerGroup, Remove-AzureRmContainerGroup, Get-AzureRmContainer...
Script 1.0.10 AzureRM.ContainerRegistry {New-AzureRmContainerRegistry, Get-AzureRmContainerRegistry, Update-AzureRmContainerRegistry, Remove-Azur...
Script 5.0.3 AzureRM.DataFactories {Remove-AzureRmDataFactory, Get-AzureRmDataFactoryRun, Get-AzureRmDataFactorySlice, Save-AzureRmDataFacto...
Script 0.5.11 AzureRM.DataFactoryV2 {Set-AzureRmDataFactoryV2, Update-AzureRmDataFactoryV2, Get-AzureRmDataFactoryV2, Remove-AzureRmDataFacto...
Script 5.1.4 AzureRM.DataLakeAnalytics {Get-AzureRmDataLakeAnalyticsDataSource, New-AzureRmDataLakeAnalyticsCatalogCredential, Remove-AzureRmDat...
Script 6.2.1 AzureRM.DataLakeStore {Get-AzureRmDataLakeStoreTrustedIdProvider, Remove-AzureRmDataLakeStoreTrustedIdProvider, Remove-AzureRmD...
Script 4.0.9 AzureRM.DevTestLabs {Get-AzureRmDtlAllowedVMSizesPolicy, Get-AzureRmDtlAutoShutdownPolicy, Get-AzureRmDtlAutoStartPolicy, Get...
Script 5.1.0 AzureRM.Dns {Get-AzureRmDnsRecordSet, New-AzureRmDnsRecordConfig, Remove-AzureRmDnsRecordSet, Set-AzureRmDnsRecordSet...
Script 0.3.7 AzureRM.EventGrid {New-AzureRmEventGridTopic, Get-AzureRmEventGridTopic, Set-AzureRmEventGridTopic, New-AzureRmEventGridTop...
Script 0.7.0 AzureRM.EventHub {New-AzureRmEventHubNamespace, Get-AzureRmEventHubNamespace, Set-AzureRmEventHubNamespace, Remove-AzureRm...
Script 4.1.8 AzureRM.HDInsight {Get-AzureRmHDInsightJob, New-AzureRmHDInsightSqoopJobDefinition, Wait-AzureRmHDInsightJob, New-AzureRmHD...
Script 5.1.5 AzureRM.Insights {Get-AzureRmMetricDefinition, Get-AzureRmMetric, Remove-AzureRmLogProfile, Get-AzureRmLogProfile...}
Script 3.1.8 AzureRM.IotHub {Add-AzureRmIotHubKey, Get-AzureRmIotHubEventHubConsumerGroup, Get-AzureRmIotHubConnectionString, Get-Azu...
Script 5.2.1 AzureRM.KeyVault {Add-AzureKeyVaultCertificate, Update-AzureKeyVaultCertificate, Stop-AzureKeyVaultCertificateOperation, G...
Script 4.1.4 AzureRM.LogicApp {Get-AzureRmIntegrationAccountAgreement, Get-AzureRmIntegrationAccountCallbackUrl, Get-AzureRmIntegration...
Script 0.18.5 AzureRM.MachineLearning {Move-AzureRmMlCommitmentAssociation, Get-AzureRmMlCommitmentAssociation, Get-AzureRmMlCommitmentPlanUsag...
Script 0.4.8 AzureRM.MachineLearningCompute {Get-AzureRmMlOpCluster, Get-AzureRmMlOpClusterKey, Test-AzureRmMlOpClusterSystemServicesUpdateAvailabili...
Script 0.2.7 AzureRM.MarketplaceOrdering {Get-AzureRmMarketplaceTerms, Set-AzureRmMarketplaceTerms}
Script 0.10.4 AzureRM.Media {Sync-AzureRmMediaServiceStorageKeys, Set-AzureRmMediaServiceKey, Get-AzureRmMediaServiceKeys, Get-AzureR...
Script 6.11.1 AzureRM.Network {Add-AzureRmApplicationGatewayAuthenticationCertificate, Get-AzureRmApplicationGatewayAuthenticationCerti...
Script 5.0.3 AzureRM.NotificationHubs {Get-AzureRmNotificationHub, Get-AzureRmNotificationHubAuthorizationRules, Get-AzureRmNotificationHubList...
Script 5.0.6 AzureRM.OperationalInsights {New-AzureRmOperationalInsightsAzureActivityLogDataSource, New-AzureRmOperationalInsightsCustomLogDataSou...
Script 1.1.0 AzureRM.PolicyInsights {Get-AzureRmPolicyEvent, Get-AzureRmPolicyState, Get-AzureRmPolicyStateSummary, Get-AzureRmPolicyRemediat...
Script 4.1.10 AzureRM.PowerBIEmbedded {Remove-AzureRmPowerBIWorkspaceCollection, Get-AzureRmPowerBIWorkspaceCollection, Get-AzureRmPowerBIWorks...
Script 5.8.2 AzureRM.Profile {Disable-AzureRmDataCollection, Disable-AzureRmContextAutosave, Enable-AzureRmDataCollection, Enable-Azur...
Script 4.1.9 AzureRM.RecoveryServices {Get-AzureRmRecoveryServicesBackupProperty, Get-AzureRmRecoveryServicesVault, Get-AzureRmRecoveryServices...
Script 4.5.2 AzureRM.RecoveryServices.Backup {Backup-AzureRmRecoveryServicesBackupItem, Get-AzureRmRecoveryServicesBackupManagementServer, Get-AzureRm...
Script 0.2.12 AzureRM.RecoveryServices.SiteRec... {Edit-AzureRmRecoveryServicesAsrRecoveryPlan, Get-AzureRmRecoveryServicesAsrAlertSetting, Get-AzureRmReco...
Script 5.1.0 AzureRM.RedisCache {Remove-AzureRmRedisCachePatchSchedule, New-AzureRmRedisCacheScheduleEntry, Get-AzureRmRedisCachePatchSch...
Script 0.3.12 AzureRM.Relay {New-AzureRmRelayNamespace, Get-AzureRmRelayNamespace, Set-AzureRmRelayNamespace, Remove-AzureRmRelayName...
Script 6.7.3 AzureRM.Resources {Get-AzureRmProviderOperation, Remove-AzureRmRoleAssignment, Get-AzureRmRoleAssignment, New-AzureRmRoleAs...
Script 0.16.10 AzureRM.Scheduler {Disable-AzureRmSchedulerJobCollection, Enable-AzureRmSchedulerJobCollection, Get-AzureRmSchedulerJobColl...
Script 0.6.13 AzureRM.ServiceBus {New-AzureRmServiceBusNamespace, Get-AzureRmServiceBusNamespace, Set-AzureRmServiceBusNamespace, Remove-A...
Script 0.3.15 AzureRM.ServiceFabric {Add-AzureRmServiceFabricApplicationCertificate, Add-AzureRmServiceFabricClientCertificate, Add-AzureRmSe...
Script 1.0.0 AzureRM.SignalR {New-AzureRmSignalR, Get-AzureRmSignalR, Get-AzureRmSignalRKey, New-AzureRmSignalRKey...}
Script 4.12.1 AzureRM.Sql {Get-AzureRmSqlDatabaseTransparentDataEncryption, Get-AzureRmSqlDatabaseTransparentDataEncryptionActivity...
Script 5.2.0 AzureRM.Storage {Get-AzureRmStorageAccount, Get-AzureRmStorageAccountKey, New-AzureRmStorageAccount, New-AzureRmStorageAc...
Script 4.0.10 AzureRM.StreamAnalytics {Get-AzureRmStreamAnalyticsFunction, Get-AzureRmStreamAnalyticsDefaultFunctionDefinition, New-AzureRmStre...
Script 4.0.5 AzureRM.Tags {Remove-AzureRmTag, Get-AzureRmTag, New-AzureRmTag}
Script 4.1.3 AzureRM.TrafficManager {Add-AzureRmTrafficManagerCustomHeaderToEndpoint, Remove-AzureRmTrafficManagerCustomHeaderFromEndpoint, A...
Script 4.0.5 AzureRM.UsageAggregates Get-UsageAggregates
Script 5.2.0 AzureRM.Websites {Get-AzureRmAppServicePlan, Set-AzureRmAppServicePlan, New-AzureRmAppServicePlan, Remove-AzureRmAppServic...
Script 1.3 FileSplitter {Join-File, Split-File}
Script 1.0.1 Microsoft.PowerShell.Operation.V... {Get-OperationValidation, Invoke-OperationValidation}
Binary 1.0.0.1 PackageManagement {Find-Package, Get-Package, Get-PackageProvider, Get-PackageSource...}
Script 3.4.0 Pester {Describe, Context, It, Should...}
Script 1.0.0.1 PowerShellGet {Install-Module, Find-Module, Save-Module, Update-Module...}
Script 1.2 PSReadline {Get-PSReadlineKeyHandler, Set-PSReadlineKeyHandler, Remove-PSReadlineKeyHandler, Get-PSReadlineOption...}
Script 0.1.0 PuppetBolt {bolt, bolt-inventory-pdb}
Script 1.7.1 PuppetDevelopmentKit pdk
Debug output
DEBUG: 14:28:24 - GetAzureResourceCmdlet begin processing with ParameterSet 'ByTagNameValueParameterSet'.
DEBUG: 14:28:24 - using account id 'xxxxxxx'...
DEBUG: [Common.Authentication]: Authenticating using Account: 'xxxxxxx', environment: 'xxxxxxx', tenant: 'xxxxxxx
'
DEBUG: [Common.Authentication]: Authenticating using configuration values: Domain: 'xxxxxxx', Endpoint: 'https://login.microsoftonline.com
/', ClientId: 'xxxxxxx', ClientRedirect: 'urn:ietf:wg:oauth:2.0:oob', ResourceClientUri: 'https://management.core.windows.net/', ValidateA
uthority: 'True'
DEBUG: [Common.Authentication]: Acquiring token using context with Authority 'https://login.microsoftonline.com/xxxxxxx/', CorrelationId:
'00000000-0000-0000-0000-000000000000', ValidateAuthority: 'True'
DEBUG: [Common.Authentication]: Acquiring token using AdalConfiguration with Domain: 'xxxxxxx', AdEndpoint: 'https://login.microsoftonline
.com/', ClientId: 'xxxxxxx', ClientRedirectUri: urn:ietf:wg:oauth:2.0:oob
DEBUG: [ADAL]: Information: 2020-04-25T13:28:24.2151891Z: xxxxxxx - LoggerBase.cs: ADAL PCL.Desktop with assembly version '3.19.2.6005', f
ile version '3.19.50302.0130' and informational version '2a8bec6c4c76d0c1ef819b55bdc3cda2d2605056' is running...
DEBUG: [ADAL]: Information: 2020-04-25T13:28:24.2151891Z: xxxxxxx - LoggerBase.cs: ADAL PCL.Desktop with assembly version '3.19.2.6005', f
ile version '3.19.50302.0130' and informational version '2a8bec6c4c76d0c1ef819b55bdc3cda2d2605056' is running...
DEBUG: [ADAL]: Information: 2020-04-25T13:28:24.2151891Z: xxxxxxx - LoggerBase.cs: === Token Acquisition started:
CacheType: null
Authentication Target: User
, Authority Host: login.microsoftonline.com
DEBUG: [ADAL]: Information: 2020-04-25T13:28:24.2151891Z: xxxxxxx - LoggerBase.cs: === Token Acquisition started:
Authority: https://login.microsoftonline.com/xxxxxxx/
Resource: https://management.core.windows.net/
ClientId: xxxxxxx
CacheType: null
Authentication Target: User
DEBUG: [ADAL]: Verbose: 2020-04-25T13:28:24.2156870Z: xxxxxxx - LoggerBase.cs: Loading from cache.
DEBUG: [ADAL]: Verbose: 2020-04-25T13:28:24.2156870Z: xxxxxxx - LoggerBase.cs: Loading from cache.
DEBUG: [ADAL]: Information: 2020-04-25T13:28:24.2161871Z: 00000000-0000-0000-0000-000000000000 - LoggerBase.cs: Deserialized 1 items to token cache.
DEBUG: [ADAL]: Verbose: 2020-04-25T13:28:24.2161871Z: xxxxxxx - LoggerBase.cs: Looking up cache for a token...
DEBUG: [ADAL]: Verbose: 2020-04-25T13:28:24.2161871Z: xxxxxxx - LoggerBase.cs: Looking up cache for a token...
DEBUG: [ADAL]: Information: 2020-04-25T13:28:24.2161871Z: xxxxxxx - LoggerBase.cs: An item matching the requested resource was found in th
e cache
DEBUG: [ADAL]: Information: 2020-04-25T13:28:24.2161871Z: xxxxxxx - LoggerBase.cs: An item matching the requested resource was found in th
e cache
DEBUG: [ADAL]: Information: 2020-04-25T13:28:24.2166873Z: xxxxxxx - LoggerBase.cs: 59.1243052116667 minutes left until token in cache expi
res
DEBUG: [ADAL]: Information: 2020-04-25T13:28:24.2166873Z: xxxxxxx - LoggerBase.cs: 59.1243052116667 minutes left until token in cache expi
res
DEBUG: [ADAL]: Information: 2020-04-25T13:28:24.2166873Z: xxxxxxx - LoggerBase.cs: A matching item (access token or refresh token or both)
was found in the cache
DEBUG: [ADAL]: Information: 2020-04-25T13:28:24.2166873Z: xxxxxxx - LoggerBase.cs: A matching item (access token or refresh token or both)
was found in the cache
DEBUG: [ADAL]: Information: 2020-04-25T13:28:24.2171859Z: xxxxxxx - LoggerBase.cs: === Token Acquisition finished successfully. An access
token was returned: Expiration Time: 25/04/2020 14:27:31 +00:00
DEBUG: [ADAL]: Information: 2020-04-25T13:28:24.2171859Z: xxxxxxx - LoggerBase.cs: === Token Acquisition finished successfully. An access
token was returned: Expiration Time: 25/04/2020 14:27:31 +00:00Access Token Hash: xxxxxxx
User id: xxxxxxx
DEBUG: [Common.Authentication]: Renewing Token with Type: 'Bearer', Expiry: '04/25/2020 14:27:31 +00:00', MultipleResource? 'True', Tenant: 'xxxxxxx', UserId: 'xxxxxxx'
DEBUG: [Common.Authentication]: User info for token DisplayId: 'xxxxxxx', Name: xxxxxxx, IdProvider: 'xxxxxxx', Uid: 'xxxxxxx'
DEBUG: [Common.Authentication]: Checking token expiration, token expires '04/25/2020 14:27:31 +00:00' Comparing to '04/25/2020 13:28:24 +00:00' With threshold '00:05:0
0', calculated time until token expiry: '00:59:07.4543112'
DEBUG: ============================ HTTP REQUEST ============================
HTTP Method:
GET
Absolute Uri:
https://management.azure.com/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/resources?api-version=2019-05-10
Headers:
x-ms-client-request-id : xxxxxxx
accept-language : en-US
Body:
DEBUG: ============================ HTTP RESPONSE ============================
Status Code:
OK
Headers:
Pragma : no-cache
x-ms-ratelimit-remaining-subscription-reads: 11967
x-ms-request-id : xxxxxxx
x-ms-correlation-request-id : xxxxxxx
x-ms-routing-request-id : UKSOUTH:20200425T132824Z:xxxxxxx
Strict-Transport-Security : max-age=31536000; includeSubDomains
X-Content-Type-Options : nosniff
Cache-Control : no-cache
Date : Sat, 25 Apr 2020 13:28:23 GMT
Body:
{
"value": [
{
"id": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Logic/workflows/xxxxxxx",
"name": "xxxxxxx",
"type": "Microsoft.Logic/workflows",
"location": "northeurope",
},
{
"id": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Logic/workflows/xxxxxxx",
"name": "xxxxxxx",
"type": "Microsoft.Logic/workflows",
"location": "northeurope",
},
{
"id": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Sql/servers/xxxxxxx",
"name": "xxxxxxx",
"type": "Microsoft.Sql/servers",
"kind": "v12.0",
"location": "northeurope",
},
{
"id": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Sql/servers/xxxxxxx/databas
es/xxxxxxx",
"name": "xxxxxxx/xxxxxxx",
"type": "Microsoft.Sql/servers/databases",
"sku": {
"name": "GP_S_Gen5",
"tier": "GeneralPurpose",
"family": "Gen5",
"capacity": 16
},
"kind": "v12.0,user,vcore,serverless",
"location": "northeurope",
},
{
"id": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Sql/servers/xxxxxxx/xxxxxxx",
"name": "xxxxxxx/xxxxxxx",
"type": "Microsoft.Sql/servers/databases",
"sku": {
"name": "GP_S_Gen5",
"tier": "GeneralPurpose",
"family": "Gen5",
"capacity": 16
},
"kind": "v12.0,user,vcore,serverless",
"location": "northeurope",
},
{
"id": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Sql/servers/xxxxxxx/databas
es/master",
"name": "xxxxxxx/master",
"type": "Microsoft.Sql/servers/databases",
"sku": {
"name": "System",
"tier": "System",
"capacity": 0
},
"kind": "v12.0,system",
"managedBy": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Sql/servers/xxxxxxx"
,
"location": "northeurope"
},
{
"id": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Sql/servers/xxxxxxx/databas
es/SSISDB",
"name": "xxxxxxx/SSISDB",
"type": "Microsoft.Sql/servers/databases",
"sku": {
"name": "Standard",
"tier": "Standard",
"capacity": 400
},
"kind": "v12.0,user",
"location": "northeurope"
},
{
"id": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Web/connections/azureblob",
"name": "azureblob",
"type": "Microsoft.Web/connections",
"location": "northeurope",
},
{
"id": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Web/connections/azureblob-1",
"name": "azureblob-1",
"type": "Microsoft.Web/connections",
"location": "northeurope",
},
{
"id": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Web/connections/azureblob-2",
"name": "azureblob-2",
"type": "Microsoft.Web/connections",
"location": "northeurope",
},
{
"id": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Web/connections/azuredatafactory",
"name": "azuredatafactory",
"type": "Microsoft.Web/connections",
"location": "northeurope",
},
{
"id": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Web/connections/excelonlinebusiness",
"name": "excelonlinebusiness",
"type": "Microsoft.Web/connections",
"location": "northeurope",
},
{
"id": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Web/connections/office365",
"name": "office365",
"type": "Microsoft.Web/connections",
"location": "northeurope",
},
{
"id": "/subscriptions/xxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Web/connections/office365-1",
"name": "office365-1",
"type": "Microsoft.Web/connections",
"location": "northeurope",
}
]
}
DEBUG: AzureQoSEvent: CommandName - Get-AzResource; IsSuccess - True; Duration - 00:00:00.1205418; Exception - ;
DEBUG: Finish sending metric.
DEBUG: 14:28:24 - GetAzureResourceCmdlet end processing.
DEBUG: 14:28:24 - GetAzureResourceCmdlet end processing.
Error output
No Error