Create a column type check

Retrieve all records containing a specific column field type from all tables in an instance by selecting Create a new Column Type Check. The Column Type Check type implements the rule you created to iterate all records matching the target column field type.

Before you begin

Role required: scan_admin

Before performing this task you must complete Create a check.

Procedure

1. Select Create a new Column Type Check.
   A New record form appears.
2. On the form, fill in the fields.

   Fields	Description
   Name	Name of the check record.
   Application	Application that has the check record.
   Category	Category of the check record.
   Priority	Priority at which the findings should be resolved.
   Version	Current version of the check record. Note: If you want to update an already existing check, the Version field increments itself.
   Active	Option to activate this check record.
   Short Description	Mandatory description about the check records.
   Description	Additional information about the check records.
   Resolution Details	Guideline to avoid check to go off against one or more tables.
   Column Type	Column type queried for this check.
   Documentation URL	Documentation link for the check details. Note: A scan_user can't edit the Documentation URL field.
   Run Condition	Boolean field that determines if the check should be run.
   Column Type	Type of columns that will run.
   Script	Script that executes against each record in a table containing a field of the defined column type.