Avatar RADplus 'Event Log Definition' Data Archive/Purge
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
- Event Log Definition
- System Task Scheduler
Scenario 1: 'Event Log Definition' - Form Verification
Steps
- Open RADplus 'Event Log Definition' form.
- Ensure that on opening form, existing/currently filed location for 'Directory to Place Archive Files In' field is present in form, and is not overwritten/re-defaulted where value defined.
- Note - 'Directory to Place Archive Files In' field may be read-only dependent on user login account/system configuration
- Ensure 'Purge data from SYSTEM.radplus_event_log_audit after selected duration' field is present in form, set to 'Yes' by default.
- This field controls whether Event Log Audit SQL table 'SYSTEM.radplus_event_log_audit' information/records are removed from database upon exceeding the 'Minimum Number of Days to Keep' setting (default) or will remain in/are not removed from 'SYSTEM.radplus_event_log_audit' (if field set to 'No')
- Ensure 'Create file of archived/purged data' field is present in form, with selections for 'SYSTEM.RADplus_event_log' and 'SYSTEM.RADplus_event_log_audit' tables available
- This field controls whether/which Event Log SQL tables create information output files for 'SYSTEM.radplus_event_log'/'SYSTEM.radplus_event_log_audit' archived/deleted records in location specified for 'Directory to Place Archive Files In' (files for both tables created by default) or to not create these output files for either/both tables (if tables deselected)
- Update selected values in 'Purge data from SYSTEM.radplus_event_log_audit after selected duration' and/or 'Create file of archived/purged data' fields if desired.
- Select/enter values for any other fields as required/desired.
- Click 'Submit' button to file 'Event Log Definition' form.
- Re-open 'Event Log Definition' form.
- Ensure that previously selected/filed values are present for all fields in 'Event Log Definition' form (including 'Directory to Place Archive Files In', 'Purge data from SYSTEM.radplus_event_log_audit after selected duration' and 'Create file of archived/purged data' fields).
Scenario 2: 'Event Log Definition' - Verification of Event Log SQL Table information Archive/Purge
Specific Setup:
- RADplus Event Auto Archiving must be enabled, with values selected/defined for 'Purge data from SYSTEM.radplus_event_log_audit after selected duration', 'Create file of archived/purged data', 'Minimum Number of Days to Keep' and 'Directory to Place Archive Files In' fields (via 'Event Log Definition' form)
- 'Event Log Archiving' task must be enabled/scheduled in system (via 'System Task Scheduler' form)
- Crystal Reports or other SQL reporting tool
Steps
- Where RADplus Event Log 'Enable Auto Archiving' is enabled (and archive/purged file settings defined via 'Event Log Definition' form), verify the following items after occurrence and completion of 'Event Log Archiving' scheduled system task:
- Open Crystal Reports or other SQL reporting tool.
- In SQL table 'SYSTEM.radplus_event_log', ensure that records/rows where difference of system task date and 'event_date' exceeds value defined for 'Minimum Number of Days to Keep' Event Log Definition setting are removed from table (to be added to 'SYSTEM.radplus_event_log_audit').
- In SQL table 'SYSTEM.radplus_event_log_audit', ensure that records/rows moved from 'SYSTEM.radplus_event_log' are present.
- Where 'Purge data from SYSTEM.radplus_event_log_audit after selected duration' Event Log Definition setting is 'Yes', ensure that existing 'SYSTEM.radplus_event_log_audit' records/rows where difference of system task date and 'audit_date' exceeds value defined for 'Minimum Number of Days to Keep' setting are removed from table.
- Where 'Purge data from SYSTEM.radplus_event_log_audit after selected duration' Event Log Definition setting is 'No', ensure that existing 'SYSTEM.radplus_event_log_audit' records/rows are not removed from/remain in SQL table.
- Navigate to server output directory defined for 'Directory to Place Archive Files In'.
- If SQL table 'SYSTEM.radplus_event_log' is selected in the 'Create file of archived/purged data' Event Log Definition setting, ensure that output file is created on server containing information for archived rows/records.
- File Name Example: 'EventLogArchive_SBOXSBOX_98_10312023'
- If SQL table 'SYSTEM.radplus_event_log' is not selected/deselected in the 'Create file of archived/purged data' Event Log Definition setting, ensure that no output file is created.
- If SQL table 'SYSTEM.radplus_event_log_audit' is selected in the 'Create file of archived/purged data' Event Log Definition setting, ensure that output file is created on server containing information for audit rows/records which were purged/deleted.
- File Name Example: 'EventLogAuditArchive_SBOXSBOX_98_10312023'
- If SQL table 'SYSTEM.radplus_event_log_audit' is selected in the 'Create file of archived/purged data' Event Log Definition setting, ensure that no output file is created.
|
Topics
• RADplus Utilities
|
Avatar RADplus 'Event Log Definition' Form
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
Scenario 1: 'Event Log Definition' - Form Verification
Steps
- Open RADplus 'Event Log Definition' form.
- Ensure that on opening form, existing/currently filed location for 'Directory to Place Archive Files In' field is present in form, and is not overwritten/re-defaulted where value defined.
- Note - 'Directory to Place Archive Files In' field may be read-only dependent on user login account/system configuration
- Ensure 'Purge data from SYSTEM.radplus_event_log_audit after selected duration' field is present in form, set to 'Yes' by default.
- This field controls whether Event Log Audit SQL table 'SYSTEM.radplus_event_log_audit' information/records are removed from database upon exceeding the 'Minimum Number of Days to Keep' setting (default) or will remain in/are not removed from 'SYSTEM.radplus_event_log_audit' (if field set to 'No')
- Ensure 'Create file of archived/purged data' field is present in form, with selections for 'SYSTEM.RADplus_event_log' and 'SYSTEM.RADplus_event_log_audit' tables available
- This field controls whether/which Event Log SQL tables create information output files for 'SYSTEM.radplus_event_log'/'SYSTEM.radplus_event_log_audit' archived/deleted records in location specified for 'Directory to Place Archive Files In' (files for both tables created by default) or to not create these output files for either/both tables (if tables deselected)
- Update selected values in 'Purge data from SYSTEM.radplus_event_log_audit after selected duration' and/or 'Create file of archived/purged data' fields if desired.
- Select/enter values for any other fields as required/desired.
- Click 'Submit' button to file 'Event Log Definition' form.
- Re-open 'Event Log Definition' form.
- Ensure that previously selected/filed values are present for all fields in 'Event Log Definition' form (including 'Directory to Place Archive Files In', 'Purge data from SYSTEM.radplus_event_log_audit after selected duration' and 'Create file of archived/purged data' fields).
|
Topics
• RADplus Utilities
|
