CMDB Coverage scheduled jobs

  • Release version: Australia
  • Updated March 12, 2026
  • 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 CMDB Coverage scheduled jobs

    CMDB Coverage leverages a series of scheduled jobs to identify stale and missing IP address data in your CMDB. These jobs help ensure accurate tracking and matching of IP addresses to configuration items (CIs), improving the reliability of your CMDB’s IP address information.

    Show full answer Show less

    Key Scheduled Jobs and Their Functions

    • PopulateBinaryTable: A one-time initialization job that converts historical IPv4 addresses into binary format for fast matching and stores them in the Binary IP Address table. IPv6 addresses are processed without conversion.
    • InitializeAllocatedIPTable: Runs after PopulateBinaryTable to process historical allocated IP address records. It updates the cimatchstatus attribute to indicate if IP addresses match no, one, or multiple CIs and creates relationships between discovered CIs and allocated IP addresses.
    • ProcessStagingTable: Processes new and updated IP address records detected in real time by the Platform DB Listener. It updates the Allocated IP Address table with changes to maintain current coverage data. The DB Listener monitors configured tables and captures IP address changes without relying on polling.
    • SubnetUsageCount: A daily job that calculates subnet usage statistics, including counts of free, allocated, and reserved IP addresses, based on cimatchstatus values.
    • Find missing IPAM ips in discovery: Identifies gaps between IP Address Management (IPAM) data and configured discovery ranges and schedules, highlighting missing or unmanaged IP address ranges. Missing coverage data is recorded for operational review.

    Practical Use for ServiceNow Customers

    These scheduled jobs enable you to maintain accurate and up-to-date IP address coverage within your CMDB by automating the detection of stale, missing, or unmatched IP addresses. Understanding and using these jobs allows you to:

    • Initialize and process historical IP address data efficiently.
    • Track real-time IP address changes and ensure your CMDB reflects current network information.
    • Monitor subnet utilization and identify free vs. allocated IPs.
    • Detect and remediate gaps between IPAM data and discovery schedules to improve CMDB completeness.

    By leveraging these jobs, you can proactively manage IP address data quality and enhance the accuracy of your CMDB’s IP-related configuration items, supporting better operational decision-making and discovery alignment.

    CMDB Coverage uses scheduled jobs to identify stale and missing data.

    To view the list of scheduled jobs, enter sysauto_script.list in the navigation filter.

    PopulateBinaryTable

    The PopulateBinaryTable scheduled job is a one-time initialization job that processes the historical records that existed before the CMDB Coverage was configured. All historical IP addresses (IPv4 addresses) are converted into binary format for fast matching. The records are added to the Binary IP Address [sn_cmdb_ip_cov_binary_ip_address] table. IPv6 addresses are processed as is.

    InitializeAllocatedIPTable

    The InitializeAllocatedIPTable scheduled job is another one-time initialization job that runs after the PopulateBinaryTable job. This scheduled job performs the following tasks and populates records in the CMDB Coverage Initialization Tracker [sn_cmdb_ip_cov_init_tracker] table:
    • Processes the historical records in the Allocated IP Address [cmdb_ci_allocated_ip_address] table.
    • Updates the value of the ci_match_status attribute for the records in the Allocated IP Address [cmdb_ci_allocated_ip_address] table.
    • Creates relationships between the discovered CIs and the records in the Allocated IP Address [cmdb_ci_allocated_ip_address] table. That is, corresponding records are created in the CMDB [cmdb_ci_rel] table.
    The possible values of the ci_match_status attribute are:
    • none: No CI matches the IP​ address, which indicates a discovery gap.
    • single: Exactly one CI matches​ the IP address.
    • multiple: Multiple CIs match​ the IP address.
    • not_evaluated: The record isn’t processed yet.

    ProcessStagingTable

    The ProcessStagingTable scheduled job processes the records that are created by the DB Listener after the CMDB Coverage application is configured.

    You can configure the list of tables that the DB Listener should monitor in the IP Coverage CI Table Configuration [sn_cmdb_ip_cov_ci_config] table. The Validate IP Coverage CI Config business rule validates the records that are created in the IP Coverage CI Table Configuration [sn_cmdb_ip_cov_ci_config] table to verify that only the IP address field is updated.

    The DB Listener performs the following tasks:
    • Detects real-time changes in IP address information.
    • Monitors the tables that are configured in the IP Coverage CI Table Configuration [sn_cmdb_ip_cov_ci_config] table.
    • Identifies new and updated IP addresses and creates corresponding records in the IP Address Staging [sn_cmdb_ip_cov_ip_staging] table.
    • Pushes changes to the Allocated IP Address [cmdb_ci_allocated_ip_address] table.
    The Platform DB Listener doesn’t rely on polling. Therefore, all updates to IP addresses are identified.

    The ProcessStagingTable scheduled job identifies the new records that were added by the DB Listener to the IP Address Staging [sn_cmdb_ip_cov_ip_staging] table. Subsequently, the ci_match_status attribute in the Allocated IP Address [cmdb_ci_allocated_ip_address] table is updated for all new records.

    SubnetUsageCount

    This daily scheduled job tracks subnet usage. Based on the value of the ci_match_status attribute in the Allocated IP Address [cmdb_ci_allocated_ip_address] table, the SubnetUsageCount scheduled job counts the number of free IP addresses, allocated IP addresses, and reserved IP addresses for each subnet.​

    Find missing IPAM ips in discovery

    IPAM-managed networks, subnets, and allocated IP addresses are managed separately from the configured discovery ranges and schedules of organizations. This often leads to stale and missing data (such as IP address ranges that are never scanned) in the CMDB.

    The Find missing IPAM ips in discovery scheduled job compares the IPAM data (networks, subnets, and allocated IP addresses) and the configured discovery ranges and schedules (IPv4 and IPv6 addresses) to identify gaps in IP address coverage, such as missing IPv4 address ranges and the number of IPAM IP addresses that don't have a discovery schedule. The data about gaps in IP address coverage is added to the Discovery schedule gap [sn_cmdb_ip_cov_discovery_schedule_gap]​ table, and is then available for operational review.