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...")
 
No edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
{{Template:Basic Cover
== Supportworks ITSM Enterprise ==
|title=How to Delete Supportworks ITHD Call Data Using SQL
|type=FAQ
}}


{{Template:Basic Status
This section lists all FAQs specific to Supportworks ITSM Enterprise.
|status=Published
|version=1.0
|authors=Hornbill Support
|applicableto=Supportworks ITHD
}}


* [[FAQ:How to Delete all Supportworks ITSM Call Data|How to Delete all Supportworks ITSM Call Data]] | ([http://forums.hornbill.com/index.php?showtopic=22 Forum thread]) - ITSM 2.x
* [[FAQ:ITSM Known Issues with ESP 7.5|ITSM Known Issues with ESP 7.5]] - ITSM 3.2.x


== How to Delete Supportworks ITHD Call Data Using SQL ==
== Supportworks ITHD ==


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.
This section lists all FAQs specific to Supportworks ITHD.


Please note that the procedure will not remove any e-mail messages linked to calls.
* [[FAQ:How to Delete all Supportworks ITHD Call Data|How to Delete all Supportworks ITHD Call Data]] | ([http://forums.hornbill.com/index.php?showtopic=23 Forum thread])
 
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.

Latest revision as of 18:06, 9 April 2015

Supportworks ITSM Enterprise

This section lists all FAQs specific to Supportworks ITSM Enterprise.

Supportworks ITHD

This section lists all FAQs specific to Supportworks ITHD.

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