Alternativ to sys_audit table for REST api

Benedikt Kaiser · ‎02-19-2024

Hi all,

I have currently a use-case where I need to retrieve the following information from a change-task:

- The exact time-stamp when the change-task was set to open

- The exact time-stamp when the assignment group was changed

I know there is the sys_audit table. However, I cannot use this table due to reasons.

Is there any alternative where I can get the needed information?

Best regards,

Benedikt

Robbie · ‎02-19-2024

Hi @Benedikt Kaiser,

The 'Metric Definition' feature of ServiceNow allows you to track the timestamp of any record. Commonly known as 'Metrics', they can also be used (and are more commonly used) to track duration periods such as the time between certain states for example New to Assigned.

Find the link below where Armit has provided a tutorial if you're not familiar with Metrics.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

Thanks, Robbie

https://www.servicenow.com/community/developer-articles/servicenow-introduction-to-metric-instance-s...

View solution in original post

James Chun · ‎02-19-2024

Hi @Benedikt Kaiser,

Looks like you are collecting these information into another system.

If so, another option is to push the data from ServiceNow into the 3rd party application. For example, you can create a Business Rule that is triggered when a record is updated and using REST API, update the target application (if it supports REST API)

Thanks