No resources found about ari HOT 13 CLOSED

Yes to both. Debug isn’t helpful. Doesn’t show any issues, just says it found one resource, which I assume is the subscription. David Monk Cloud Architect – Cloud Transformation From: Claudio Merola ***@***.***> Sent: Monday, March 13, 2023 12:37 PM To: microsoft/ARI ***@***.***> Cc: Monk, David ***@***.***>; Author ***@***.***> Subject: Re: [microsoft/ARI] No resources found (Issue #106) Hello, This is very strange. Running the inventory for other environments is ok? The types of resources in the tenant are like VMs and AKS and etc? — Reply to this email directly, view it on GitHub<#106 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/A45BXCQRAOKNN5SLR3I4YQLW35LKHANCNFSM6AAAAAAVVVH4DI>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>

I set $Limit = 0, and I don’t see any errors. It found resources. "total_records": 559 David Monk Cloud Architect – Cloud Transformation From: Claudio Merola ***@***.***> Sent: Monday, March 20, 2023 1:06 PM To: microsoft/ARI ***@***.***> Cc: Monk, David ***@***.***>; Author ***@***.***> Subject: Re: [microsoft/ARI] No resources found (Issue #106) No, the subscription is sum in another variable.... I'm starting to suspect the script is failing to collect the other resources because some property of the second resource is crashing the Azure Resource Graph query... Can you run the following? Just to see if more resources are listed: az login -t TENANTID $GraphQuery = "resources | where strlen(properties.definition.actions) < 123000 | project id,name,type,tenantId,kind,location,resourceGroup,subscriptionId,managedBy,sku,plan,properties,identity,zones | order by id asc" az graph query -q $GraphQuery --skip $Limit --first 1000 --output json --only-show-errors — Reply to this email directly, view it on GitHub<#106 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/A45BXCWOCQPPXTB6QW6FZWLW5CL6XANCNFSM6AAAAAAVVVH4DI>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>

Yes, those are the only parameters. az version { "azure-cli": "2.46.0", "azure-cli-core": "2.46.0", "azure-cli-telemetry": "1.0.8", "extensions": { "account": "0.2.3", "resource-graph": "2.1.0" } } David Monk Cloud Architect – Cloud Transformation From: Claudio Merola ***@***.***> Sent: Friday, March 24, 2023 3:48 PM To: microsoft/ARI ***@***.***> Cc: Monk, David ***@***.***>; Author ***@***.***> Subject: Re: [microsoft/ARI] No resources found (Issue #106) Ok, The only parameters you are using when running the script are: -tenantID and -SecurityCenter? What version of az cli and resource-graph extension are you running? — Reply to this email directly, view it on GitHub<#106 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/A45BXCTVKJIWLV2VYHHOPATW5YB6PANCNFSM6AAAAAAVVVH4DI>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>

$Resources is empty after running the script. David Monk Cloud Architect – Cloud Transformation From: Claudio Merola ***@***.***> Sent: Wednesday, March 29, 2023 8:13 AM To: microsoft/ARI ***@***.***> Cc: Monk, David ***@***.***>; Author ***@***.***> Subject: Re: [microsoft/ARI] No resources found (Issue #106) I just tested with the exact same version and it runs normally. Let's see what is this one resource it is reporting... Can you see what is inside the variable $Resources after the script is run? Thanks — Reply to this email directly, view it on GitHub<#106 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/A45BXCTZNWB4OMNJILWFHKDW6QYOVANCNFSM6AAAAAAVVVH4DI>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>

Looks like the issue is found. ***@***.*** Here is a list of all the resource types they have in their subscription: App Service plan Runbook API Connection Virtual machine SQL virtual machine Disk Load balancer Network Interface Storage account Log Analytics workspace SQL server SQL database Public IP address Network security group Service Bus Namespace Virtual network Bastion Network Watcher Logic app Logic App (Standard) Application Insights Integration account App Service Azure Database for MySQL flexible server Private DNS zone Synapse workspace Automation Account Dedicated SQL pool Key vault Analysis Services Azure DevOps organization David Monk Cloud Architect – Cloud Transformation From: Claudio Merola ***@***.***> Sent: Friday, March 31, 2023 7:33 AM To: microsoft/ARI ***@***.***> Cc: Monk, David ***@***.***>; Author ***@***.***> Subject: Re: [microsoft/ARI] No resources found (Issue #106) May you run the following to see the types of resources being collected? az login -t TENANTID $Global:Resources = @() $GraphQuery = "resources | where strlen(properties.definition.actions) < 123000 | summarize count()" $EnvSize = az graph query -q $GraphQuery --output json --only-show-errors | ConvertFrom-Json $EnvSizeNum = $EnvSize.data.'count_' Write-Host ('Resources counted: '+$EnvSizeNum) if ($EnvSizeNum -ge 1) { $Loop = $EnvSizeNum / 1000 $Loop = [math]::ceiling($Loop) $Looper = 0 $Limit = 0 while ($Looper -lt $Loop) { $GraphQuery = "resources | where strlen(properties.definition.actions) < 123000 | project id,name,type,tenantId,kind,location,resourceGroup,subscriptionId,managedBy,sku,plan,properties,identity,zones,extendedLocation$($GraphQueryTags) | order by id asc" $Resource = (az graph query -q $GraphQuery --skip $Limit --first 1000 --output json --only-show-errors).tolower() | ConvertFrom-Json write-host ('Resources Inside Loop: '+$Resource.data.count) $Global:Resources += $Resource.data Start-Sleep 2 $Looper ++ $Limit = $Limit + 1000 } } $Resources | Group-Object -Property type | Select-Object -Property Name,Count | Sort-Object -Property count -Descending — Reply to this email directly, view it on GitHub<#106 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/A45BXCWT5FW2E7DC45U62FTW63FJBANCNFSM6AAAAAAVVVH4DI>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>

Is there something else I can do to help identify what is causing the issue with this one tenant? David Monk Cloud Architect – Cloud Transformation From: Monk, David Sent: Friday, March 31, 2023 8:34 AM To: 'microsoft/ARI' ***@***.***>; microsoft/ARI ***@***.***> Cc: Author ***@***.***> Subject: RE: [microsoft/ARI] No resources found (Issue #106) Looks like the issue is found. ***@***.*** Here is a list of all the resource types they have in their subscription: App Service plan Runbook API Connection Virtual machine SQL virtual machine Disk Load balancer Network Interface Storage account Log Analytics workspace SQL server SQL database Public IP address Network security group Service Bus Namespace Virtual network Bastion Network Watcher Logic app Logic App (Standard) Application Insights Integration account App Service Azure Database for MySQL flexible server Private DNS zone Synapse workspace Automation Account Dedicated SQL pool Key vault Analysis Services Azure DevOps organization David Monk Cloud Architect – Cloud Transformation From: Claudio Merola ***@***.******@***.***>> Sent: Friday, March 31, 2023 7:33 AM To: microsoft/ARI ***@***.******@***.***>> Cc: Monk, David ***@***.******@***.***>>; Author ***@***.******@***.***>> Subject: Re: [microsoft/ARI] No resources found (Issue #106) May you run the following to see the types of resources being collected? az login -t TENANTID $Global:Resources = @() $GraphQuery = "resources | where strlen(properties.definition.actions) < 123000 | summarize count()" $EnvSize = az graph query -q $GraphQuery --output json --only-show-errors | ConvertFrom-Json $EnvSizeNum = $EnvSize.data.'count_' Write-Host ('Resources counted: '+$EnvSizeNum) if ($EnvSizeNum -ge 1) { $Loop = $EnvSizeNum / 1000 $Loop = [math]::ceiling($Loop) $Looper = 0 $Limit = 0 while ($Looper -lt $Loop) { $GraphQuery = "resources | where strlen(properties.definition.actions) < 123000 | project id,name,type,tenantId,kind,location,resourceGroup,subscriptionId,managedBy,sku,plan,properties,identity,zones,extendedLocation$($GraphQueryTags) | order by id asc" $Resource = (az graph query -q $GraphQuery --skip $Limit --first 1000 --output json --only-show-errors).tolower() | ConvertFrom-Json write-host ('Resources Inside Loop: '+$Resource.data.count) $Global:Resources += $Resource.data Start-Sleep 2 $Looper ++ $Limit = $Limit + 1000 } } $Resources | Group-Object -Property type | Select-Object -Property Name,Count | Sort-Object -Property count -Descending — Reply to this email directly, view it on GitHub<#106 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/A45BXCWT5FW2E7DC45U62FTW63FJBANCNFSM6AAAAAAVVVH4DI>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>