oci_identity_domain only shows domains in root compartment

[hslange]

Describe the bug
We have multiple identity domains, some are in the root compartment, others are in different compartments.
The query "select * from oci_identity_domain" only shows the domains in the root compartment, not in any other compartment.

Steampipe version (steampipe -v)
v2.1.0

Plugin version (steampipe plugin list)
oci v1.1.0

To reproduce
create a compartment: test
in compartment test, create a new identity domain: test-domain
run steampipe query with "select * from oci_identity_domain", this will show only Identity Domains in the root compartment (at least "Default" but maybe others as well

Expected behavior
All Identity Domains in all compartments should be shown as result of the query.

Additional context

[misraved]

Hi @hslange, I believe you need to follow the resoulution steps mentioned in #661 (comment) to fix this issue as well.

[hslange]

Hi,
Using different profiles does not solve the issue.
The current implementation in steampipe has a hardcoded compartment (TenancyID), while Identity Domains can exist in any compartment (only the Default domain is always in the tenancy root).
In order to get all domains, you would need to go through all compartments and check if there is one existing.

This is a snapshot of the code in table_oci_identity_domain.go, starting at line 172:

// The OCID of the tenancy containing the compartment.
	request := identity.ListDomainsRequest{
		CompartmentId: &session.TenancyID,
		Limit:         types.Int(1000),
		RequestMetadata: common.RequestMetadata{
			RetryPolicy: getDefaultRetryPolicy(d.Connection),
		},
	}

Hop this shows the issue with Identity Domain not in the tenancy root compartment.
Kind regards.