Need identification of DevTest database table/columns that may contain classified data

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)
• Service Virtualization

Issue/Introduction

In order to comply with a company's Data Management requirements, we need to identify database tables/columns within the DevTest created instances which may contain test data inputs and outputs - requests/responses, as well as user info/password data, in order to classify them as potentially containing classified or highly classified data. 

Need to identify any tables/columns within the db instances, as generated by our install/use of DevTest, that may contain this type of data.

Environment

All supported DevTest releases.

Cause

N/A

Resolution

The following DevTest tables/columns may contain sensitive data.

Table Name	Database	Column 1	Column 2	Column 3
hst_criteria	lisadb.reporting	created_by
hst_filter	lisadb.reporting	created_by
hst_filter_data	lisadb.reporting	created_by
hst_suite_run	lisadb.reporting	user_name
hst_test_run	lisadb.reporting	user_name
hst_property_info	lisadb.reporting	prop_value
hst_step_run	lisadb.reporting	request	response
acl_users	lisadb.acl	user_name	user_password	user_unique_id
lisa_frame_data	lisadb.broker	request	response
lisa_manual_case	lisadb.broker	creator
lisa_ticket	lisadb.broker	customer_id	reporter_email
access_event_log	dradis.db	user_id