Service Desk Practitioners Forum
cancel

Clearing demo data in servicedesk

Highlighted
TGR!!
Honored Contributor.

Clearing demo data in servicedesk

Hi Al,

How can we remove data from sd4.5?


Thanks in Advance,
Tgr!!
2 REPLIES
Tommy Koronen_1
Super Contributor.

Re: Clearing demo data in servicedesk

Use Archiving:
One way to do it is to use Archiving.
This way you will get information about the deleted items into XML-files.
Use archiving views to define what items to delete.

Use Delete:
List all the items you want to delete in a view. Select all items listed, and then Delete.
Repeat this for all item types you want to delete.

Use SQL:
This is the fastest way to delete ALL items!
Connect directly to the database, and execute commands like this:
delete from ITSM_SERVICECALLS;
delete from ITSM_INCIDENTS;
...

You can add a "where" conditions if you want to control what items to delete.

BR/Tommy

The Pike
Acclaimed Contributor.

Re: Clearing demo data in servicedesk

If you go with deleting records directly, make sure you know what you're doing. You might end up with your database in a unsupportable and more importantly... unusable state and render your support contract with HP invalid.