1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseMigration
  5. getJobAdvisorReportChecks
Viewing docs for Oracle Cloud Infrastructure v4.2.0
published on Friday, Mar 6, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

oci.DatabaseMigration.getJobAdvisorReportChecks

oci logo
Viewing docs for Oracle Cloud Infrastructure v4.2.0
published on Friday, Mar 6, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

    This data source provides the list of Job Advisor Report Checks in Oracle Cloud Infrastructure Database Migration service.

    List of Pre-Migration checks from the advisor.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testJobAdvisorReportChecks = oci.DatabaseMigration.getJobAdvisorReportChecks({
    jobId: testJob.id,
});

    import pulumi
import pulumi_oci as oci

test_job_advisor_report_checks = oci.DatabaseMigration.get_job_advisor_report_checks(job_id=test_job["id"])

    package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v4/go/oci/databasemigration"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := databasemigration.GetJobAdvisorReportChecks(ctx, &databasemigration.GetJobAdvisorReportChecksArgs{
			JobId: testJob.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testJobAdvisorReportChecks = Oci.DatabaseMigration.GetJobAdvisorReportChecks.Invoke(new()
    {
        JobId = testJob.Id,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseMigration.DatabaseMigrationFunctions;
import com.pulumi.oci.DatabaseMigration.inputs.GetJobAdvisorReportChecksArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var testJobAdvisorReportChecks = DatabaseMigrationFunctions.getJobAdvisorReportChecks(GetJobAdvisorReportChecksArgs.builder()
            .jobId(testJob.id())
            .build());

    }
}

    variables:
  testJobAdvisorReportChecks:
    fn::invoke:
      function: oci:DatabaseMigration:getJobAdvisorReportChecks
      arguments:
        jobId: ${testJob.id}

    Using getJobAdvisorReportChecks

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getJobAdvisorReportChecks(args: GetJobAdvisorReportChecksArgs, opts?: InvokeOptions): Promise<GetJobAdvisorReportChecksResult>
function getJobAdvisorReportChecksOutput(args: GetJobAdvisorReportChecksOutputArgs, opts?: InvokeOptions): Output<GetJobAdvisorReportChecksResult>
    def get_job_advisor_report_checks(filters: Optional[Sequence[GetJobAdvisorReportChecksFilter]] = None,
                                  job_id: Optional[str] = None,
                                  opts: Optional[InvokeOptions] = None) -> GetJobAdvisorReportChecksResult
def get_job_advisor_report_checks_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[GetJobAdvisorReportChecksFilterArgs]]]] = None,
                                  job_id: Optional[pulumi.Input[str]] = None,
                                  opts: Optional[InvokeOptions] = None) -> Output[GetJobAdvisorReportChecksResult]
    func GetJobAdvisorReportChecks(ctx *Context, args *GetJobAdvisorReportChecksArgs, opts ...InvokeOption) (*GetJobAdvisorReportChecksResult, error)
func GetJobAdvisorReportChecksOutput(ctx *Context, args *GetJobAdvisorReportChecksOutputArgs, opts ...InvokeOption) GetJobAdvisorReportChecksResultOutput

    > Note: This function is named GetJobAdvisorReportChecks in the Go SDK.

    public static class GetJobAdvisorReportChecks 
{
    public static Task<GetJobAdvisorReportChecksResult> InvokeAsync(GetJobAdvisorReportChecksArgs args, InvokeOptions? opts = null)
    public static Output<GetJobAdvisorReportChecksResult> Invoke(GetJobAdvisorReportChecksInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetJobAdvisorReportChecksResult> getJobAdvisorReportChecks(GetJobAdvisorReportChecksArgs args, InvokeOptions options)
public static Output<GetJobAdvisorReportChecksResult> getJobAdvisorReportChecks(GetJobAdvisorReportChecksArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:DatabaseMigration/getJobAdvisorReportChecks:getJobAdvisorReportChecks
  arguments:
    # arguments dictionary

    The following arguments are supported:

    jobId String
    The OCID of the job
    filters List<Property Map>

    getJobAdvisorReportChecks Result

    The following output properties are available:

    AdvisorReportCheckCollections List<GetJobAdvisorReportChecksAdvisorReportCheckCollection>
    The list of advisor_report_check_collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    JobId string
    Filters List<GetJobAdvisorReportChecksFilter>
    AdvisorReportCheckCollections []GetJobAdvisorReportChecksAdvisorReportCheckCollection
    The list of advisor_report_check_collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    JobId string
    Filters []GetJobAdvisorReportChecksFilter
    advisorReportCheckCollections List<GetJobAdvisorReportChecksAdvisorReportCheckCollection>
    The list of advisor_report_check_collection.
    id String
    The provider-assigned unique ID for this managed resource.
    jobId String
    filters List<GetJobAdvisorReportChecksFilter>
    advisorReportCheckCollections GetJobAdvisorReportChecksAdvisorReportCheckCollection[]
    The list of advisor_report_check_collection.
    id string
    The provider-assigned unique ID for this managed resource.
    jobId string
    filters GetJobAdvisorReportChecksFilter[]
    advisor_report_check_collections Sequence[GetJobAdvisorReportChecksAdvisorReportCheckCollection]
    The list of advisor_report_check_collection.
    id str
    The provider-assigned unique ID for this managed resource.
    job_id str
    filters Sequence[GetJobAdvisorReportChecksFilter]
    advisorReportCheckCollections List<Property Map>
    The list of advisor_report_check_collection.
    id String
    The provider-assigned unique ID for this managed resource.
    jobId String
    filters List<Property Map>

    Supporting Types

    GetJobAdvisorReportChecksAdvisorReportCheckCollection

    items List<Property Map>
    Array of advisor check items.
    summaries List<Property Map>
    Pre-Migration extended advisor report summary.

    GetJobAdvisorReportChecksAdvisorReportCheckCollectionItem

    AdvisorReportCheckId string
    IsReviewed bool
    User flag for advisor report check.
    Items List<GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItem>
    Array of advisor check items.
    JobId string
    The OCID of the job
    Summaries List<GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemSummary>
    Pre-Migration extended advisor report summary.
    AdvisorReportCheckId string
    IsReviewed bool
    User flag for advisor report check.
    Items []GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItem
    Array of advisor check items.
    JobId string
    The OCID of the job
    Summaries []GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemSummary
    Pre-Migration extended advisor report summary.
    advisorReportCheckId String
    isReviewed Boolean
    User flag for advisor report check.
    items List<GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItem>
    Array of advisor check items.
    jobId String
    The OCID of the job
    summaries List<GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemSummary>
    Pre-Migration extended advisor report summary.
    advisorReportCheckId string
    isReviewed boolean
    User flag for advisor report check.
    items GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItem[]
    Array of advisor check items.
    jobId string
    The OCID of the job
    summaries GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemSummary[]
    Pre-Migration extended advisor report summary.
    advisor_report_check_id str
    is_reviewed bool
    User flag for advisor report check.
    items Sequence[GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItem]
    Array of advisor check items.
    job_id str
    The OCID of the job
    summaries Sequence[GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemSummary]
    Pre-Migration extended advisor report summary.
    advisorReportCheckId String
    isReviewed Boolean
    User flag for advisor report check.
    items List<Property Map>
    Array of advisor check items.
    jobId String
    The OCID of the job
    summaries List<Property Map>
    Pre-Migration extended advisor report summary.

    GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItem

    Action string
    Fixing the issue.
    Columns List<GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItemColumn>
    Array of the column of the objects table.
    DisplayName string
    Pre-Migration сheck display name.
    FixupScriptLocation string
    The path to the fixup script for this check.
    Impact string
    Impact of the issue on data migration.
    IsExclusionAllowed bool
    If false, objects cannot be excluded from migration.
    IsReviewed bool
    User flag for advisor report check.
    Issue string
    Description of the issue.
    Key string
    Pre-Migration сheck id.
    Metadatas List<GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItemMetadata>
    Metadata of object.
    ObjectCount int
    Number of database objects to migrate.
    ResultType string
    Pre-Migration advisor result.
    Action string
    Fixing the issue.
    Columns []GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItemColumn
    Array of the column of the objects table.
    DisplayName string
    Pre-Migration сheck display name.
    FixupScriptLocation string
    The path to the fixup script for this check.
    Impact string
    Impact of the issue on data migration.
    IsExclusionAllowed bool
    If false, objects cannot be excluded from migration.
    IsReviewed bool
    User flag for advisor report check.
    Issue string
    Description of the issue.
    Key string
    Pre-Migration сheck id.
    Metadatas []GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItemMetadata
    Metadata of object.
    ObjectCount int
    Number of database objects to migrate.
    ResultType string
    Pre-Migration advisor result.
    action String
    Fixing the issue.
    columns List<GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItemColumn>
    Array of the column of the objects table.
    displayName String
    Pre-Migration сheck display name.
    fixupScriptLocation String
    The path to the fixup script for this check.
    impact String
    Impact of the issue on data migration.
    isExclusionAllowed Boolean
    If false, objects cannot be excluded from migration.
    isReviewed Boolean
    User flag for advisor report check.
    issue String
    Description of the issue.
    key String
    Pre-Migration сheck id.
    metadatas List<GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItemMetadata>
    Metadata of object.
    objectCount Integer
    Number of database objects to migrate.
    resultType String
    Pre-Migration advisor result.
    action string
    Fixing the issue.
    columns GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItemColumn[]
    Array of the column of the objects table.
    displayName string
    Pre-Migration сheck display name.
    fixupScriptLocation string
    The path to the fixup script for this check.
    impact string
    Impact of the issue on data migration.
    isExclusionAllowed boolean
    If false, objects cannot be excluded from migration.
    isReviewed boolean
    User flag for advisor report check.
    issue string
    Description of the issue.
    key string
    Pre-Migration сheck id.
    metadatas GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItemMetadata[]
    Metadata of object.
    objectCount number
    Number of database objects to migrate.
    resultType string
    Pre-Migration advisor result.
    action str
    Fixing the issue.
    columns Sequence[GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItemColumn]
    Array of the column of the objects table.
    display_name str
    Pre-Migration сheck display name.
    fixup_script_location str
    The path to the fixup script for this check.
    impact str
    Impact of the issue on data migration.
    is_exclusion_allowed bool
    If false, objects cannot be excluded from migration.
    is_reviewed bool
    User flag for advisor report check.
    issue str
    Description of the issue.
    key str
    Pre-Migration сheck id.
    metadatas Sequence[GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItemMetadata]
    Metadata of object.
    object_count int
    Number of database objects to migrate.
    result_type str
    Pre-Migration advisor result.
    action String
    Fixing the issue.
    columns List<Property Map>
    Array of the column of the objects table.
    displayName String
    Pre-Migration сheck display name.
    fixupScriptLocation String
    The path to the fixup script for this check.
    impact String
    Impact of the issue on data migration.
    isExclusionAllowed Boolean
    If false, objects cannot be excluded from migration.
    isReviewed Boolean
    User flag for advisor report check.
    issue String
    Description of the issue.
    key String
    Pre-Migration сheck id.
    metadatas List<Property Map>
    Metadata of object.
    objectCount Number
    Number of database objects to migrate.
    resultType String
    Pre-Migration advisor result.

    GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItemColumn

    DisplayName string
    Pre-Migration сheck display name.
    Key string
    Pre-Migration сheck id.
    DisplayName string
    Pre-Migration сheck display name.
    Key string
    Pre-Migration сheck id.
    displayName String
    Pre-Migration сheck display name.
    key String
    Pre-Migration сheck id.
    displayName string
    Pre-Migration сheck display name.
    key string
    Pre-Migration сheck id.
    display_name str
    Pre-Migration сheck display name.
    key str
    Pre-Migration сheck id.
    displayName String
    Pre-Migration сheck display name.
    key String
    Pre-Migration сheck id.

    GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemItemMetadata

    ObjectNameColumn string
    The field that stores the name of the object.
    ObjectTypeColumn string
    The field that stores the type of the object.
    ObjectTypeFixed string
    The field that stores the fixed type of the object.
    SchemaOwnerColumn string
    The field that stores the owner of the object.
    ObjectNameColumn string
    The field that stores the name of the object.
    ObjectTypeColumn string
    The field that stores the type of the object.
    ObjectTypeFixed string
    The field that stores the fixed type of the object.
    SchemaOwnerColumn string
    The field that stores the owner of the object.
    objectNameColumn String
    The field that stores the name of the object.
    objectTypeColumn String
    The field that stores the type of the object.
    objectTypeFixed String
    The field that stores the fixed type of the object.
    schemaOwnerColumn String
    The field that stores the owner of the object.
    objectNameColumn string
    The field that stores the name of the object.
    objectTypeColumn string
    The field that stores the type of the object.
    objectTypeFixed string
    The field that stores the fixed type of the object.
    schemaOwnerColumn string
    The field that stores the owner of the object.
    object_name_column str
    The field that stores the name of the object.
    object_type_column str
    The field that stores the type of the object.
    object_type_fixed str
    The field that stores the fixed type of the object.
    schema_owner_column str
    The field that stores the owner of the object.
    objectNameColumn String
    The field that stores the name of the object.
    objectTypeColumn String
    The field that stores the type of the object.
    objectTypeFixed String
    The field that stores the fixed type of the object.
    schemaOwnerColumn String
    The field that stores the owner of the object.

    GetJobAdvisorReportChecksAdvisorReportCheckCollectionItemSummary

    BlockerResultsTotalCount int
    Number of BLOCKER results in the extended advisor report.
    FatalResultsTotalCount int
    Number of FATAL results in the extended advisor report.
    InformationalResultsTotalCount int
    Number of INFORMATIONAL results in the extended advisor report.
    PassResultsTotalCount int
    Number of PASS results in the extended advisor report.
    WarningResultsTotalCount int
    Number of WARNING results in the extended advisor report.
    BlockerResultsTotalCount int
    Number of BLOCKER results in the extended advisor report.
    FatalResultsTotalCount int
    Number of FATAL results in the extended advisor report.
    InformationalResultsTotalCount int
    Number of INFORMATIONAL results in the extended advisor report.
    PassResultsTotalCount int
    Number of PASS results in the extended advisor report.
    WarningResultsTotalCount int
    Number of WARNING results in the extended advisor report.
    blockerResultsTotalCount Integer
    Number of BLOCKER results in the extended advisor report.
    fatalResultsTotalCount Integer
    Number of FATAL results in the extended advisor report.
    informationalResultsTotalCount Integer
    Number of INFORMATIONAL results in the extended advisor report.
    passResultsTotalCount Integer
    Number of PASS results in the extended advisor report.
    warningResultsTotalCount Integer
    Number of WARNING results in the extended advisor report.
    blockerResultsTotalCount number
    Number of BLOCKER results in the extended advisor report.
    fatalResultsTotalCount number
    Number of FATAL results in the extended advisor report.
    informationalResultsTotalCount number
    Number of INFORMATIONAL results in the extended advisor report.
    passResultsTotalCount number
    Number of PASS results in the extended advisor report.
    warningResultsTotalCount number
    Number of WARNING results in the extended advisor report.
    blocker_results_total_count int
    Number of BLOCKER results in the extended advisor report.
    fatal_results_total_count int
    Number of FATAL results in the extended advisor report.
    informational_results_total_count int
    Number of INFORMATIONAL results in the extended advisor report.
    pass_results_total_count int
    Number of PASS results in the extended advisor report.
    warning_results_total_count int
    Number of WARNING results in the extended advisor report.
    blockerResultsTotalCount Number
    Number of BLOCKER results in the extended advisor report.
    fatalResultsTotalCount Number
    Number of FATAL results in the extended advisor report.
    informationalResultsTotalCount Number
    Number of INFORMATIONAL results in the extended advisor report.
    passResultsTotalCount Number
    Number of PASS results in the extended advisor report.
    warningResultsTotalCount Number
    Number of WARNING results in the extended advisor report.

    GetJobAdvisorReportChecksAdvisorReportCheckCollectionSummary

    BlockerResultsTotalCount int
    Number of BLOCKER results in the extended advisor report.
    FatalResultsTotalCount int
    Number of FATAL results in the extended advisor report.
    InformationalResultsTotalCount int
    Number of INFORMATIONAL results in the extended advisor report.
    PassResultsTotalCount int
    Number of PASS results in the extended advisor report.
    WarningResultsTotalCount int
    Number of WARNING results in the extended advisor report.
    BlockerResultsTotalCount int
    Number of BLOCKER results in the extended advisor report.
    FatalResultsTotalCount int
    Number of FATAL results in the extended advisor report.
    InformationalResultsTotalCount int
    Number of INFORMATIONAL results in the extended advisor report.
    PassResultsTotalCount int
    Number of PASS results in the extended advisor report.
    WarningResultsTotalCount int
    Number of WARNING results in the extended advisor report.
    blockerResultsTotalCount Integer
    Number of BLOCKER results in the extended advisor report.
    fatalResultsTotalCount Integer
    Number of FATAL results in the extended advisor report.
    informationalResultsTotalCount Integer
    Number of INFORMATIONAL results in the extended advisor report.
    passResultsTotalCount Integer
    Number of PASS results in the extended advisor report.
    warningResultsTotalCount Integer
    Number of WARNING results in the extended advisor report.
    blockerResultsTotalCount number
    Number of BLOCKER results in the extended advisor report.
    fatalResultsTotalCount number
    Number of FATAL results in the extended advisor report.
    informationalResultsTotalCount number
    Number of INFORMATIONAL results in the extended advisor report.
    passResultsTotalCount number
    Number of PASS results in the extended advisor report.
    warningResultsTotalCount number
    Number of WARNING results in the extended advisor report.
    blocker_results_total_count int
    Number of BLOCKER results in the extended advisor report.
    fatal_results_total_count int
    Number of FATAL results in the extended advisor report.
    informational_results_total_count int
    Number of INFORMATIONAL results in the extended advisor report.
    pass_results_total_count int
    Number of PASS results in the extended advisor report.
    warning_results_total_count int
    Number of WARNING results in the extended advisor report.
    blockerResultsTotalCount Number
    Number of BLOCKER results in the extended advisor report.
    fatalResultsTotalCount Number
    Number of FATAL results in the extended advisor report.
    informationalResultsTotalCount Number
    Number of INFORMATIONAL results in the extended advisor report.
    passResultsTotalCount Number
    Number of PASS results in the extended advisor report.
    warningResultsTotalCount Number
    Number of WARNING results in the extended advisor report.

    GetJobAdvisorReportChecksFilter

    Name string
    Values List<string>
    Regex bool
    Name string
    Values []string
    Regex bool
    name String
    values List<String>
    regex Boolean
    name string
    values string[]
    regex boolean
    name str
    values Sequence[str]
    regex bool
    name String
    values List<String>
    regex Boolean

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Viewing docs for Oracle Cloud Infrastructure v4.2.0
    published on Friday, Mar 6, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-oci
      Try Pulumi Cloud free. Your team will thank you.