Sample payload for Oracle software install records

  • Release version: Yokohama
  • Updated January 30, 2025
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Sample payload for Oracle software install records

    This document provides a sample payload format for integrating Oracle software install records into the ServiceNow CMDB, specifically targeting thecmdbcidborainstancetable. It is designed for use with third-party discovery sources to populate Oracle Instance records along with associated Oracle options.

    Show full answer Show less

    After discovering Oracle software installations via an external discovery tool, customers can send a structured payload containing Oracle instances and options. This enables automatic population of software install fields and creation of related software install records through the scheduled job SAM- Software Asset Connections.

    Key Configuration Requirement

    • Enable the property com.snc.samp.ire.datasource.integration ("Enable scheduled jobs") on the Properties page to allow integration with third-party data sources.
    • The scheduled job SAM- Software Asset Connections processes records with null software installs, linking Oracle instances with software install records correctly.

    Sample Payload Structure

    The payload includes:

    • Oracle Instance (className: cmdbcidborainstance) with attributes such as name, edition, sid, and version.
    • Multiple Oracle Options (className: samporacleoptions) related to the instance, each specifying the option name and whether it is currently used.
    • A related Linux Server (className: cmdbcilinuxserver) with hardware and OS details.
    • Relationships defining that the Oracle instance "Runs on" the Linux server.

    Practical Benefits for ServiceNow Customers

    • Enables seamless import and synchronization of Oracle software install data from external discovery tools into the CMDB.
    • Maintains accurate and up-to-date records of Oracle database instances and their enabled options, improving asset and configuration management.
    • Supports tracking of Oracle software deployments on underlying infrastructure such as Linux servers.
    • Automates creation and association of software install records, reducing manual effort and ensuring data consistency.

    Key Elements Explained

    • cmdbcidborainstance: Table storing Oracle database instance records.
    • samporacleoptions: Table for Oracle database options linked to instances, with flags indicating currently enabled options.
    • cmdbcilinuxserver: Table capturing details about the physical or virtual Linux server hosting the Oracle instance.
    • Relationship type Runs on::Runs connects Oracle instance to its host server.

    A sample payload for Oracle publisher pack that populates the Oracle Instance [cmdb_ci_db_ora_instance] table with software install records from third-party discovery sources.

    After you discover Oracle software installs via your discovery source, send a payload that contains the Oracle Instance and the Oracle options associated with the Oracle Instance.
    Note:
    In the Properties page, make sure to select the Enable scheduled jobs when using third party Datasource Integration Framework [com.snc.samp.ire.datasource.integration] property.

    When the schedule job, SAM- Software Asset Connections, runs, it looks for records with null software installs, populates the software install field in the Oracle Instance table and creates the software install record associated to the instance.

    The following is a sample payload to create software install records for Oracle in the Oracle Instance [cmdb_ci_db_ora_instance] table. The sample input contains a list of CIs and relationships that exist between these CIs. The payload states that there is an Oracle database server, Dev development 1969 with a standard edition. The Oracle database server has many Oracle options enabled such as Armstrong, Aldrin, Collins and runs on a Linux server.

    {
  'items': [
    {
      'className': 'cmdb_ci_db_ora_instance',
      'related': [
        {
          'className': 'samp_oracle_options',
          'values': {
            "option": "Armstrong",
            "currently_used": "true"
          }
        },
        {
          'className': 'samp_oracle_options',
          'values': {
            "option": "Aldrin",
            "currently_used": "true"
          }
        },
        {
          'className': 'samp_oracle_options',
          'values': {
            "option": "Collins",
            "currently_used": "true"
          }
        }
      ],
      'values': {
        'name': 'Dev development 1969',
        'edition': 'Standard',
        'sid': '1-2-569',
        'version': '11.2'
      }
    },
    {
      'className': 'cmdb_ci_linux_server',
      'values': {
        'name': 'CI DATAI 6-002',
        'mac_address': '4653XYZAA',
        'ip_address': '10.10.10.8',
        'asset_tag': 'HWR0003',
        'assigned_to': 'a8f98bb0eb32010045e1a5115206fe3a',
        'cpu_count': '16',
        'cpu_manufacturer': '820351a1c0a8018b67c73d51c074097c',
        'manufacturer': '820351a1c0a8018b67c73d51c074097c',
        'os': 'Linux Red Hat',
        'os_version': '2.6.9-22.0.1.ELsmp',
        'ram': '2014'
      }
    }
  ],
  'relations': [
    {
      'type': 'Runs on::Runs',
      'parent': 0,
      'child': 1
    }
  ]
}
    Element Value Description
    className cmdb_ci_db_ora_instance Name of the related Oracle instance table.
    className samp_oracle_options Name of the Oracle database option table.
    option Armstrong Name of the Oracle database option.
    currently_used true Indicates the Armstrong option is currently enabled.
    className samp_oracle_options Name of the Oracle database option table.
    option Aldrin Name of the Oracle database option
    currently_used true Indicates the Aldrin option is currently enabled.
    name Dev Development 69 Name of the Oracle database server
    edition standard edition of the Oracle database server
    sid 1-2-569 Oracle system ID
    version 11.2 Version of the Oracle database server
    className cmdb_ci_linux_server Name of the related Linux Server table.
    mac address 4653XYZAA MAC address of the interface in the Linux server.