HELP: How do we report on Comments entries in PA > Analytics Hub?

[JohnEJasinski]

HELP:  How do we report on Comments entries in PA > Analytics Hub?

Fame and fortune for correct answer. 

THX-JJ

[SANDEEP DUTTA]

Hi @JohnEJasinski ,

Below are the tables which you can look for  in PA - Performance Analytics for the reporting:

sys_history_set.list

sys_history_line.list

[JohnEJasinski]

The sys_history_set table in ServiceNow is used to track changes made to records in other tables. It provides a high-level overview of changes, and its fields typically include:

• sys_id: A unique identifier for the history set record.
• table: The name of the table where the changes occurred.
• document_id: The unique identifier (sys_id) of the record in the table that was modified.
• update_time: The timestamp when the change was made.
• user: The user who made the change.
• update_reason: The reason for the update (e.g., manual update, system update).
• sys_mod_count: A counter indicating how many times the record has been modified.
• client: The client or source of the update (e.g., UI, API).
• application: The application associated with the change.

This table works in conjunction with the sys_history_line table, which provides more granular details about the specific fields that were changed.

The sys_history_line table in ServiceNow is used to track changes made to records. It contains fields that provide detailed information about these changes. Common fields in the sys_history_line table include:

• sys_id: Unique identifier for the history record.
• table: The name of the table where the change occurred.
• fieldname: The name of the field that was changed.
• oldvalue: The value of the field before the change.
• newvalue: The value of the field after the change.
• update: The reference to the update record (links to the sys_update_xml table).
• sys_created_on: The timestamp when the history record was created.
• sys_created_by: The user who made the change.
• set: Reference to the sys_history_set table, grouping related changes together.
• update_number: Sequence number for the update within the set.

These fields help track and audit changes to records in ServiceNow. If you need more specific details or additional fields, you can explore the table schema directly in your ServiceNow instance.