Table Data Comparison and Auto-Insertion Script
Overview
Command
Arguments
Parameter | Description |
<masId> | The Probe server ID |
<apiKey> | The API key of the server where the script is being executed, used for authentication. |
<queryFilePath> | Path to the query file containing the table comparison SQL. |
<direction> | Comparison direction: - BD → Compare both directions (default). - MAS-NOT-IN-ADMIN → Find missing entries in Central server that exist in Probe server. - ADMIN-NOT-IN-MAS → Find missing entries in Probe server that exist in Central server. |
<asInsertQuery> | true → Generates INSERT queries instead of just reporting. (Default: false) |
<isMissingEntriesNeedToInsert> | true → Automatically inserts missing entries to the Central server and Probe server. (Default: false) |
<batchSize> | Number of records to process in a batch. (Default: 100) |
<timeoutInSeconds> | Default value for <timeoutInSeconds> is 30 seconds if not provided. |
Examples
Compares both directions (Central server → Probe server and Probe server → Central server) without inserting missing entries../runTableDataComparisonReport.sh 1 884ff42xxxxxxxxxxxxxxxxxxx3d6d5 /path/to/query.txt
Finds entries that are present in the Central server but missing in the Probe server.
./runTableDataComparisonReport.sh 1 884ff42xxxxxxxxxxxxxxxxxxx3d6d5 /path/to/query.txt ADMIN-NOT-IN-MAS
Finds entries that are present in the Probe server but missing in the Central server.
./runTableDataComparisonReport.sh 1 884ff42xxxxxxxxxxxxxxxxxxx3d6d5 /path/to/query.txt MAS-NOT-IN-ADMIN
Compares in both directions and automatically inserts the missing records in both the Central and Probe server.
./runTableDataComparisonReport.sh 1 884ff42xxxxxxxxxxxxxxxxxxx3d6d5 /path/to/query.txt BD false true
Generates SQL INSERT statements without executing them.
./runTableDataComparisonReport.sh 1 884ff42xxxxxxxxxxxxxxxxxxx3d6d5 /path/to/query.txt BD true false
Compare and insert missing entries with a batch size of 500.
./runTableDataComparisonReport.sh 1 884ff42xxxxxxxxxxxxxxxxxxx3d6d5 /path/to/query.txt BD false true 500
Compare and insert missing entries with a timeout.
./runTableDataComparisonReport.sh 1 884ff42xxxxxxxxxxxxxxxxxxx3d6d5 /path/to/query.txt BD false true 500 60
Expected Output
A mismatch report displaying the missing entries.
If isMissingEntriesNeedToInsert=true, it automatically inserts missing entries.
If asInsertQuery=true, it generates INSERT statements instead of executing them.
- This script can be run on both Central and Probe servers.
- The script supports only columns that contain textual or numeric values. Columns of other types, such as BLOB or encrypted VARCHAR values, are not supported.
- The Central and Probe Server must be up and running for the script to execute successfully.
- Input queries should include the range column to define the Probe server.
- If the query file contains a DELETE query, cleanup will begin on both Central and Probe servers, irrespective of the specified direction. Always place DELETE queries first in the file, followed by SELECT queries.
Troubleshooting
Ensure the API key is correct.
Check if the query file path is valid and accessible.
If insertions fail, check for unique constraints or foreign key dependencies in stdout logs .
New to ADSelfService Plus?
Related Articles
Script/Custom Monitors - Alarms configured for Table rows were missing
In the Applications manager , users have the ability to manage the table rows of a script or custom monitor type according to their specific requirements. This can be done by enabling the "Enable Script Row Deletion" option. For example, let's ...How to configure Output Settings for Script Monitor?
Below are the details on how to configure Script Monitor Output Settings and expected output format, Output Configuration: Expected Output File Format: In the output file, Scalar data should be separated by scalar delimiter, here name, cpu, javaHeap ...APMInsight Data Cleanup Standalone script - Usage
The APMInsight Data clean up standalone script can be used to clean up the data tables for below : Data / Table Description Partition tables These data tables are used to store the performance metric raw data for APM Insight Monitors for every ...Script Monitor FAQs
Common queries, errors and troubleshooting: 1. To execute scripts other than .bat /.vbs in Windows and .sh / .bash in Linux: It is better to execute the script in the form of a command. Eg. To execute python script, you can use command py ...No data available or error in Port Connectivity table
1. In Applications Manager console, go to Admin -> Performance Polling -> Optimize Data Collection. 2. Select Active Directory as monitor type and choose the required metric under 'Metric Name'. Select Collect data in every poll option and ...