The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How to reset or change Call ID number

Highlighted
raam.mk
Super Collector

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
Honored 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
//Add this to "OnDomLoad" event