View source for FAQ:How to Delete all Supportworks ITSM Call Data

{{Template:Basic Cover
| title=How to Delete all Supportworks ITSM Call Data
| type=FAQ
}}

{{Template:Basic Status
| status=Published
| version=1.1
| authors=Hornbill Support
| applicableto=Supportworks ITSM 2.x
}}

== How to Delete all Supportworks ITSM 2.x Call Data ==

The following describes how to remove all Call-related data from within Supportworks ITSM (for ITSM 2.x versions).

Please note that this will not remove any mail related data.

A backup of the system is advised before following these instructions.

# Launch the Supportworks Server Configuration Program, via '''Start > Programs > Supportworks Server > Supportworks Server Configuration.
# On the '''Server''' Tab, stop the '''SwServerService''' process.
# Launch the Supportworks Interactive SQL Program, via '''Start > Programs > Hornbill Core Services > Interactive SQL''') (Or If on Third Party Db the Query tool of choice)
# Enter the following statements: (Note: a WHERE clause should be used if you do not wish to DELETE ALL current call data)
#: <code>use swdata;</code>
#: <code>delete from opencall;</code>
#: <code>delete from updatedb;</code>
#: <code>delete from calltasks;</code>
#: <code>delete from swissues;</code>
#: <code>delete from itsm_opencall_problem;</code>
#: <code>delete from itsm_opencall_rfc;</code>
#: <code>delete from cmn_rel_opencall_ci;</code>
#: <code>delete from cmn_rel_opencall_oc;</code>
#: <code>delete from bpm_oc_auth;</code>
#: <code>delete from bpm_oc_hist;</code>
#: <code>delete from bpm_oc_task;</code>
#: <code>delete from  tpperformance</code>
#: <code>delete from extoc_newequip</code>  ''(if present)''
#: <code>delete from  extoc_newstarter </code>  ''(if present)''
#: <code></code>
#: <code>Use sw_systemdb;</code>
#: <code>delete from opencall;</code>
#: <code>delete from updatedb;</code>
#: <code>delete from opencall_sla_evts;</code>
#: <code>delete from opencall_sla;</code>
#: <code>delete from system_cfastore;</code>
#: <code></code>
# Enter the following statements to reset the call reference counters and close the interactive SQL Window:
#: <code>Use sw_systemdb;</code>
#: <code>Update system_counters set  count=1 where name=’nextcallreference’;</code>
#: <code>Exit;</code>
# Delete the following files
#: '''C: /Program Files/Hornbill/Supportworks Server/Data/_cfastore/FOLDER/*.*'''
#:  (Where "C: /Program Files/Hornbill/" is the default installation folder  and "FOLDER" is the folder containing the File attachments for the  given range of calls)
# In the Supportworks Server Configuration Program, restart the '''SwServerService''' process, and check that all test data has been removed.