Service Desk Practitioners Forum
cancel

How to reset or change Call ID number

Highlighted
raam.mk
Respected Contributor.

How to reset or change Call ID number

In HPOV SD 4.5 with service pack13 how can i reset or change the starting call ID.

With Thanx and Regards
Raam.MK
1 REPLY
George M. Meneg
Acclaimed Contributor.

Re: How to reset or change Call ID number

Hello,

The last ID of service calls/work orders/incidents/changes/problems/projects are stored on the table ifc_sequences.

To get it run the follow query:

select seq_usn from ifc_sequences inner join ifc_entities on ent_oid=seq_cat_oid
where ent_name='Service Call'

You can alter seq_usn however you have to take care if you don't want to have duplicate IDs.
menes fhtagn