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

Document created by MarcyNunns Employee on Jan 2, 2019
Version 1Show Document
  • View in full screen mode
Question:
In order to comply with my companies 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.

We request that you identify any tables/columns within the db instances as generated by our install/use of DevTest that may contain this type of data.
Answer:
Table NameDatabaseColumn 1Column 2Column 3
hst_criterialisadb.reportingcreated_by  
hst_filterlisadb.reportingcreated_by  
hst_filter_datalisadb.reportingcreated_by  
hst_suite_runlisadb.reportinguser_name  
hst_test_runlisadb.reportinguser_name  
hst_property_infolisadb.reportingprop_value  
hst_step_runlisadb.reportingrequestresponse 
acl_userslisadb.acluser_nameuser_passworduser_unique_id
     
lisa_frame_datalisadb.brokerrequestresponse 
lisa_manual_caselisadb.brokercreator  
lisa_ticket lisadb.brokercustomer_idreporter_email 
     
access_event_logdradis.dbuser_id  
     
    

Attachments

    Outcomes