Database Auditor elements

These tables describe elements on the Database Auditor page.

Table 6-16 Single Subscriber or Pool Audit Elements

Field	Description	Data Input Notes
Key Type	Select the type of key used to identify the subscriber or pool for checking the foreign key inconsistency. The value selected here defines what can be entered in the next field, Key Value.	Format: Pulldown menu Range: IMSI, MSISDN, Account Id, PoolID Default: Blank
Key Value	Enter the key value used to identify the subscriber or pool for checking the foreign key inconsistency.	Format: Numeric Range: 1 - 255 digits Note: For MSISDN the value must be 8 - 15 digits; for IMSI the value must be 10 - 15 digits; for PoolId the value can be 1 - 22 digits. Default: Blank
Result File Name	Enter a filename to be used for the log file.	Format: String - valid characters are alphanumeric and underscore; must contain at least one alphabetic or numeric character, and cannot start with a number Range:1-32 characters Default: Blank

Table 6-17 Complete Database Audit Element

Field	Description	Data Input Notes
Result File Name	Enter a filename to be used for the output files. Filenames are prepended with Audit_ and appended with _<timestamp> plus the file format extension (either .ixml or .dbauditor)	Format: String - valid characters are alphanumeric and underscore; must contain at least one alphabetic or numeric character, and cannot start with a number Range:1-32 characters Default: Blank

Table 6-18 Clean Element

Field	Description	Data Input Notes
Input File Name	Select the name of the file containing the subscriber/pool records with inconsistencies to be cleaned from the pulldown menu.	Format: Pulldown menu Range: List of existing audit files Default: Blank

Table 6-19 State Table Elements

Field	Description
Process Type	Displays the type of process running. Processes are: Single Subscriber Audit or Pool Audit, Complete Database Audit, and Clean.
Result Logs	Displays the name of the log files generated by the audit/clean process. Filename format: For the audit process: Audit_<x>_201503142216.dbauditor Audit_<x>_201503142216.ixml For the clean process: Audit_<x>_201503142216.dbauditor Clean_<x>_201503150216.ixml The filenames in this column are hyperlinks. Clicking on a link pops up a window and displays the contents of the file as text. Right-clicking a link allows you to save the file.
Time Started	Displays the time when the audit/clean process was started.
Time Completed	Displays the time when the audit/clean process was completed.
Audited subscriber and pool count	Displays the number of subscriber or pool records audited/scanned.
Inconsistent subscriber and pool count	Displays the number of subscriber or pool records that have inconsistency.
Cleaned subscriber and pool count	Displays the number of subscriber or pool records that were deleted.
State	Displays the state of the audit/clean process. States are: In Progress, Completed, Failed, Aborted, and Paused.