- asmt_assessment_instance is the table that contains the survey itself.
- asmt_metric_result is the table that contains the results of the individual surveys. In order to link the survey results to a ticket or agent in a report, you need to dot walk to Instance → Task table; from there, you can select an agent or offering or other filterable field.
- task_assessment_detail is the table that contains the comments of each result. It is a custom database view that is a join of asmt_metric_type, asmt_assessment_instance, task, and asmt_metric_result. Because it is a join of all these tables, listing the fields would be redundant. In order to see the responses, set Metric 'starts with' 'Please help' to focus on the question soliciting comments, Response is the field with the comments themselves so we like to filter Response 'is not empty', and then add any filters you may want off of the task including agent or assignment group.
On this page:
Notable asmt_assessment_instance fields
| sys_name | column_label | element | internal_type | reference | max_length | Reporting Notes |
| Sys ID | sys_id | Sys ID (GUID) | 32 | |||
| Updated | sys_updated_on | Date/Time | 40 | |||
| Created by | sys_created_by | String | 40 | |||
| Updates | sys_mod_count | Integer | 40 | |||
| Created | sys_created_on | Date/Time | 40 | |||
| Updated by | sys_updated_by | String | 40 | |||
| Assessment group | Assessment group | assessment_group | Reference | Assessment Group | 32 | |
| Assigned to | Assigned to | user | Reference | User | 32 | |
| Control/Risk | Control/Risk | sn_grc_item | Reference | Control/Risk | 32 | |
| Domain | Domain | sys_domain | Domain ID | 32 | ||
| Domain Path | Domain Path | sys_domain_path | Domain Path | 255 | ||
| Due date | Due date | due_date | Date | 40 | ||
| Entity | Entity | sn_grc_profile | Reference | Entity | 32 | |
| Expiration date | Expiration date | expiration_date | Date | 40 | ||
| Grouped assessment | Grouped assessment | sn_grc_parent | Reference | Assessment Instance | 32 | |
| Metric type | Metric type | metric_type | Reference | Assessment Metric Type | 32 | |
| Number | Number | number | String | 40 | ||
| Percent answered | Percent answered | percent_answered | Percent Complete | 15 | ||
| Preview | Preview | preview | True/False | 40 | ||
| Processing status | Processing status | sn_grc_status | Choice | 40 | ||
| Related record 1 | Related record 1 | related_id_1 | Document ID | 32 | ||
| Related record 2 | Related record 2 | related_id_2 | Document ID | 32 | ||
| Related record 3 | Related record 3 | related_id_3 | Document ID | 32 | ||
| Related record 4 | Related record 4 | related_id_4 | Document ID | 32 | ||
| Related table 1 | Related table 1 | related_table_1 | Table Name | 80 | ||
| Related table 2 | Related table 2 | related_table_2 | Table Name | 80 | ||
| Related table 3 | Related table 3 | related_table_3 | Table Name | 80 | ||
| Related table 4 | Related table 4 | related_table_4 | Table Name | 80 | ||
| Response type | Response type | sn_grc_group_type | Choice | 40 | ||
| Signature | Signature | signature | Reference | Signature | 32 | |
| Signature result | Signature result | signature_result | String | 40 | ||
| State | State | state | String | 40 | ||
| Take attestation | Take attestation | take_attestation | UI Action List | 4,000 | ||
| Taken on | Taken on | taken_on | Date/Time | 40 | ||
| Task | Task | task_id | Reference | Task | 32 | |
| Trigger condition | Trigger condition | trigger_condition | Reference | Trigger Condition | 32 | |
| Trigger ID | Trigger ID | trigger_id | Document ID | 32 | ||
| Trigger table | Trigger table | trigger_table | Table Name | 80 | ||
| View responses | View responses | view_response | UI Action List | 4,000 | ||
Notable asmt_metric_result fields
| sys_name | column_label | element | internal_type | reference | max_length | Reporting Notes |
| Sys ID | sys_id | Sys ID (GUID) | 32 | |||
| Updated | sys_updated_on | Date/Time | 40 | |||
| Created by | sys_created_by | String | 40 | |||
| Updates | sys_mod_count | Integer | 40 | |||
| Created | sys_created_on | Date/Time | 40 | |||
| Updated by | sys_updated_by | String | 40 | |||
| Actual value | Actual value | actual_value | Decimal | 15 | ||
| Additional Information | Additional Information | add_info | String | 8,000 | ||
| Assessment group | Assessment group | assessment_group | Reference | Assessment Group | 32 | |
| Assign to - order | Assign to - order | assign_to_order | String | 160 | ||
| Assigned to | Assigned to | user | Reference | User | 32 | |
| Domain | Domain | sys_domain | Domain ID | 32 | ||
| Domain Path | Domain Path | sys_domain_path | Domain Path | 255 | ||
| Duration value | Duration value | duration_value | Duration | 40 | ||
| Instance | Instance | instance | Reference | Assessment Instance | 32 | |
| Metric | Metric | metric | Reference | Assessment Metric | 32 | |
| Metric definition | Metric definition | metric_definition | Reference | Assessment Metric Definition | 32 | |
| Normalized value | Normalized value | normalized_value | Decimal | 15 | ||
| NPS value | NPS value | nps_value | Integer | 40 | ||
| Passed | Passed | passed | String | 40 | ||
| Question | Question | instance_question | Reference | Assessment Instance Question | 32 | |
| Question default | Question default | is_default | True/False | 40 | ||
| Reference table | Reference table | reference_table | Table Name | 80 | ||
| Reference value | Reference value | reference_value | Document ID | 32 | ||
| Scaled value | Scaled value | scaled_value | Decimal | 15 | ||
| Source | Source | source_id | Document ID | 32 | ||
| Source table | Source table | source_table | Table Name | 80 | ||
| String value | String value | string_value | String | 8,000 | ||
| Template definition | Template definition | template_definition | Reference | Assessment Template Definition | 32 | |
| Weighted value | Weighted value | weighted_value | Decimal | 15 | ||
If you still have questions or need additional assistance, please use the 'Contact ServiceNow Team' form.