Application FAQs: Difference between revisions

From support-works
Jump to navigation Jump to search
(Created page with "{{Template:Basic Cover |title=How to Delete Supportworks ITHD Call Data Using SQL |type=FAQ }} {{Template:Basic Status |status=Published |version=1.0 |authors=Hornbill Suppor...")
 
(Blanked the page)
Line 1: Line 1:
{{Template:Basic Cover
|title=How to Delete Supportworks ITHD Call Data Using SQL
|type=FAQ
}}


{{Template:Basic Status
|status=Published
|version=1.0
|authors=Hornbill Support
|applicableto=Supportworks ITHD
}}
== How to Delete Supportworks ITHD Call Data Using SQL ==
This document gives you instructions on how to remove all call-related data within Supportworks IT Helpdesk (ITHD) manually by direct access to the databases concerned. You may need to do this if you find yourself in a fault situation where you are unable to delete calls normally from within the Supportworks client.
Please note that the procedure will not remove any e-mail messages linked to calls.
The deletion procedure is as follows:
# Run the Supportworks Server Configuration utility by selecting Start > Programs > Supportworks Server > Supportworks Server Configuration.
# On the Server tab, stop the SwServerService.
# Run the Interactive SQL utility by selecting Start > Programs > Hornbill Core Services > Interactive SQL. Alternatively, if you are using a third-party database, run the query tool of choice.
# Enter the following SQL statements (followed by appropriate <code>where</code> clauses if you wish to delete the call data selectively):
#: <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>use sw_systemdb; </code>
#: <code>delete from  opencall_sla_evts;</code>
#: <code>delete from opencall_sla_exc; </code>
#: <code>delete from  opencall_sla; </code>
#: <code>delete from system_cfastore; </code>
#: <code>update  system_counters set count = 0 where name ='NextCallReference';</code>
#:
#: <code>use sw_knowledgebase; </code>
#: <code>delete from  kbdocuments where callref > 0;</code>
#: <code>delete from  kbunpubcalls;</code>
#: <code>Exit;</code>
# Delete the following files:
#: C:\Program Files\Hornbill\Supportworks Server\Data\cfa_store\''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 utility, start the SwServerService.
Once you have completed the above procedure, all required call data, together with the calls' file attachments, will have been removed.

Revision as of 18:03, 9 April 2015

Retrieved from ‘https://wiki.support-works.com/index.php?title=Application_FAQs&oldid=50’