Question

Reset Event Reference Number

  • 20 October 2023
  • 0 replies
  • 12 views

Badge

Morning everyone. I’m working with 11.3.9 and we are going to archive events out of an existing database to standup a new initiative. I want to reset the starting reference numbers for all event types. I know that the event reference numbers for Problems is determined based on the problem_hk table and that the change_hk table determines the event reference numbers for service requests and changes. The incident_hk is used to determine the incident_id (not the incident rerfernce). I also know that Incident, Task and Decisions are sequential and I would assume use the same table to determine the next reference number.

My question is this, what table is used to determine the event reference number of Incident/Task/Decision events.


0 replies

Be the first to reply!

Reply