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](hs-create-health-check.md).
Procedure
Select Create a new Column Type Check.
A New record form appears.
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. |
Parent Topic:Create a check