Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete the service calls from SD DB?

SOLVED
Go to solution
Highlighted
Fenny_1
Collector

How to delete the service calls from SD DB?

Hi,
During the implementation phase of HP SD5.1, for testing purposes we have created alot of test Service calls now we are planning to move the system in production.
How can i delete all the Service calls from SQL server DB and start with new Service call id 1?

Waiting for feedback.
9 REPLIES
Rajesh Nair
Esteemed Contributor
Solution

Re: How to delete the service calls from SD DB?

Hi,

Yes you can but you have to do at the database level and should only reset it to a number which is higher than any records of the type in the system (i.e. delete all old records first.)

The SQL is something like:

UPDATE IFC_SEQUENCES
SET SEQ_USN=new value
WHERE SEQ_CAT_OID in (
SELECT ENT_OID
FROM IFC_ENTITIES
WHERE ENT_NAME=â  nameâ  );

where ent_name is object type and new value is the number you want.

Hope this helps

Regards

Rajesh
Fenny_1
Collector

Re: How to delete the service calls from SD DB?

Hi,
thanks for the quick response.
I cant do it by some other way from SD client. Actually am not the SQL expert and i dnt wana mess up things.
BTW: if i try this command what would be the impact of it other than deleting the service calls?
Fenny_1
Collector

Re: How to delete the service calls from SD DB?

Rajesh,
I think the update query will only update the sequence no. What abt deleting the test service calls?
Rajesh Nair
Esteemed Contributor

Re: How to delete the service calls from SD DB?

Hi,

You can delete the service calls from the client..but the service call ID will not get reset to 1. If you create a new service call after deleting all the existing service calls then the new call will have the number after the last number which was deleted. It will not be number 1.

Regards

Rajesh
Fenny_1
Collector

Re: How to delete the service calls from SD DB?

Hi Rajesh,
U didnt tell me which query to use for deleting service calls. i got your point abt the number sequence.
Ruth Porter
Honored Contributor

Re: How to delete the service calls from SD DB?

hi Fenny,

You do not need to use SQL to delete the old calls, just do it through the client: use advanced find to get all the calls, then select all and delete.

Hope this helps, Ruth
http://www.teamultra.net
Fenny_1
Collector

Re: How to delete the service calls from SD DB?

Hi Ruth,
Thanks for the suggestion.
By deleting the SC this way can remove them from DB also. right?
Ruth Porter
Honored Contributor

Re: How to delete the service calls from SD DB?

Hi Fenny,

Yes - they will go from the DB and it will also warn you of any related records and let you delete those too.

Regards, Ruth
http://www.teamultra.net
Fenny_1
Collector

Re: How to delete the service calls from SD DB?


thanks alot for everyone's help.
I deleted all the service call as per Ruth's suggestion.
//Add this to "OnDomLoad" event