We have a requirement to create a report that groups Azure resources by Azure Resource Group.
Current setup:
Azure resources are discovered through ServiceNow Cloud Discovery.
Azure Resource Groups are available as separate CI records.
We need a report showing resources grouped under their respective Azure Resource Groups.
We tried using a Database View to join the Azure Resource Group table and CMDB CI tables, but some Azure resource types are not appearing in the results, making the solution complex and difficult to maintain.
Questions:
What is the recommended approach to report Azure resources grouped by Azure Resource Group?
Is there an out-of-the-box relationship or reference field between Azure Resource Groups and Azure resource CIs that can be leveraged for reporting?
Has anyone successfully used CMDB Query Builder or another reporting approach for this requirement?
Would creating a reference field to the Azure Resource Group on the Azure CI classes be considered a best practice for reporting purposes?
Any guidance or best practices would be appreciated.
