VA summary

The following table list information per test and database key displayed in the VA summary table: test result by unique identifier; cumulative failed age; first failed date/ last failed date; last passed date; and, last scanned date. This information is tracked and users can create a report on this information.

VA Summary

The default summary key for ISO installations includes the datasource name, host, and port.

Use VA Summary Tracking in Query Builder to define queries and reports.

This table can be exported/imported. Import Data will override existing data on the Guardium system (per key).

Table 1. VA Summary
Table Column	Type	Description
VA_SUMMARY_ID	Int	Auto-increment – primary key
DATA_SOURCE_HASH	Varchar(40)	Hash for the Key
DB_TYPE	Varchar	Database Type
SERVICE_NAME	Varchar	Database instance Name (if part of the key, "N/A" otherwise)
DB_PORT	Varchar	Database Port (if part of the key, "N/A" otherwise)
DB_HOST	Varchar	Host / IP (if part of the key, "N/A" otherwise)
TEST_ID	Int	Id of the Test
FIRST_EXECUTION	DateTime	First time the test was executed
LAST_EXECUTION	DateTime	Last time the test was executed
FIRST_FAIL	DateTime	First time the test failed on this DB
LAST_FAIL	DateTime	Last time the Test failed on this DB
FIRST_PASS	DateTime	First time the Test passed on this DB
LAST_PASS	DateTime	Last time the Test passed on this DB
CURRENT_SCORE	varchar	Pass / Fail / Error
CURRENT_SCORE_SINCE	Datetime	Date Since the test is in the current status
CUMULATIVE_FAIL_AGE	Int	Cumulative fail age (in days)
CUMULATIVE_PASS_AGE	Int	Cumulative pass age (in days)

The CLI commands are: store va_test_show_query and show va_test_show_query. Use export va_summary to export this information.

The GuardAPI commands to change or display the key are: grdapi modify_va_summary_key and grdapi reset_va_summary_by_key. The GuardAPI command to reset cumulative ages, both pass and fail, is grdapi reset_va_summary_by_id. Use grdapi export_va_summary to export this information.

An additional parameter, datasourceName, has been added to grdapi reset_va_summary_by_key and grdapi modify_va_summary_key.

The VA Summary entity has an additional attribute, Datasource Name, that is populated ONLY if the datasource name is part of the key.

Note: The GrdAPI command, modify_va_summary_key, will allow the key to be empty by calling the GrdAPI with all four parameters: useHost, usePort, useServiceName, useDatasourceName, equal to false. In this case, when the key is empty, the VA Summary calculation is disabled (no summary data will be calculated, updated or saved).