{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":46820,"path":"servicenow-platform/configuration-management-database-cmdb/cmdb-coverage-scheduled-jobs.md","title":"CMDB Coverage scheduled jobs","bundle":null,"doc_type":null,"release":"australia","body":"\n# CMDB Coverage scheduled jobs\n\nCMDB Coverage uses scheduled jobs to identify stale and missing data.\n\nTo view the list of scheduled jobs, enter `sysauto_script.list` in the navigation filter.\n\n## PopulateBinaryTable\n\nThe **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.\n\n## InitializeAllocatedIPTable\n\nThe **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:\n\n-   Processes the historical records in the Allocated IP Address \\[cmdb\\_ci\\_allocated\\_ip\\_address\\] table.\n-   Updates the value of the `ci_match_status` attribute for the records in the Allocated IP Address \\[cmdb\\_ci\\_allocated\\_ip\\_address\\] table.\n-   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.\n\nThe possible values of the `ci_match_status` attribute are:\n\n-   none: No CI matches the IP​ address, which indicates a discovery gap.\n-   single: Exactly one CI matches​ the IP address.\n-   multiple: Multiple CIs match​ the IP address.\n-   not\\_evaluated: The record isn’t processed yet.\n\n## ProcessStagingTable\n\nThe **ProcessStagingTable** scheduled job processes the records that are created by the DB Listener after the CMDB Coverage application is configured.\n\nYou 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.\n\nThe DB Listener performs the following tasks:\n\n-   Detects real-time changes in IP address information.\n-   Monitors the tables that are configured in the IP Coverage CI Table Configuration \\[sn\\_cmdb\\_ip\\_cov\\_ci\\_config\\] table.\n-   Identifies new and updated IP addresses and creates corresponding records in the IP Address Staging \\[sn\\_cmdb\\_ip\\_cov\\_ip\\_staging\\] table.\n-   Pushes changes to the Allocated IP Address \\[cmdb\\_ci\\_allocated\\_ip\\_address\\] table.\n\nThe Platform DB Listener doesn’t rely on polling. Therefore, all updates to IP addresses are identified.\n\nThe **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.\n\n## SubnetUsageCount\n\nThis 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.​\n\n## Find missing IPAM ips in discovery\n\nIPAM-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.\n\nThe **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.\n\n**Parent Topic:**[CMDB Coverage reference](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/servicenow-platform/configuration-management-database-cmdb/cmdb-coverage-reference.md)\n\n"}}