CORE:Frequently Asked Questions

Database

• Size Comparison of SwSQL with MS SQL
• Increasing the Maximum Size of the Analyst E-Mail Address Field | (Forum thread)
• Adding Extra Filter Columns to the Call-Index Table
• How to Run a Batch Update of All Customer Records for Web Access | (Forum thread)
• Changing the SwSQL Account Password | (Forum thread)
• How to Identify the Database that Holds a Specific Table
• How to repair all system tables (sw_systemdb)| wiki
• The Root Causes of Database Table Corruption
• Database Migration using the Database Migration Wizard
• Minimum Number of Characters search
• How to add a column to the database using the Database Schema Editor
• Moving SwSQL Databases to another drive
• Unable to connect to target database: Call to SQLError Failed
• Causes of Database table corruption
• Repairing a Corrupt Index File in ESP 7.x
• Repairing a Corrupt Table in ESP 8.x
• ODBC connection to sql server
• Historical data extract from Old version of supportworks
• How to remove ticket data from the database
• MSSQL Sorting or binary data would be truncated
• Deletion of Calls, Emails and Attachments before a certain date
• Special characters cause SQL insert/update statements to fail in Mariadb

Security

• Security audits reporting potential vulnerabilities in Core Services 3.X
• Apache Web Server Hardening
• Setting Up Single Sign-On for the Web Client
• Setting Up Single Sign-On for SelfService
• Configuring SSL and Using Your Own Certificate/Key on the Web Server

The Apache Web Server

• Unable to start SwHTTPServer due to port conflict
• Unable to start SwHTTPServer following an upgrade to Supportworks 7.6.2
• Rotate Apache Logs

Installation

• System Requirements