CORE:Frequently Asked Questions: Difference between revisions
Jump to navigation
Jump to search
| (39 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
{{DISPLAYTITLE:Frequently Asked Questions}} | |||
===Database=== | |||
* [[Size Comparison of SwSQL with MS SQL ]] | * [[Size Comparison of SwSQL with MS SQL ]] | ||
* [[Increasing the Maximum Size of the Analyst E-Mail Address Field]] | ([http://forums.hornbill.com/index.php?showtopic=4773 Forum thread]) | * [[Increasing the Maximum Size of the Analyst E-Mail Address Field]] | ([http://forums.hornbill.com/index.php?showtopic=4773 Forum thread]) | ||
* [[Adding Extra Filter Columns to the Call-Index Table]] | * [[Adding Extra Filter Columns to the Call-Index Table]] | ||
| Line 9: | Line 10: | ||
* [[How to Identify the Database that Holds a Specific Table]] | * [[How to Identify the Database that Holds a Specific Table]] | ||
* [[How to repair all system tables (sw_systemdb)]][http://wikisvr1/wikifiles/Userwiki/FAQs/ESP/Database/SwRepairAll.zip | wiki] | * [[How to repair all system tables (sw_systemdb)]][http://wikisvr1/wikifiles/Userwiki/FAQs/ESP/Database/SwRepairAll.zip | wiki] | ||
* [[The Root Causes of Database Table Corruption]] | |||
* [[Database Migration using the Database Migration Wizard]] | |||
* [https://www.youtube.com/watch?v=w-L3nGZh1WA 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=== | ||
* [[Security audits reporting potential vulnerabilities in Core Services 3.X]] | |||
* [[Apache Web Server Hardening]] | * [[Apache Web Server Hardening]] | ||
* [[Setting Up Single Sign-On for the Web Client]] | * [[Setting Up Single Sign-On for the Web Client]] | ||
* [[Setting Up Single Sign-On for SelfService]] | * [[Setting Up Single Sign-On for SelfService]] | ||
* [[Configuring SSL and Using Your Own Certificate/Key on the Web Server]] | * [[Configuring SSL and Using Your Own Certificate/Key on the Web Server]] | ||
* [[Creating a Self-Signed Certificate]] | |||
* [[Creating a Self-Signed Certificate CS 7.x]] | |||
* [[IE-11 Not able to connect via Core Services 3.1.4 Apache Server using TLS v1.2]] | |||
===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]] | |||
Latest revision as of 07:34, 31 May 2023
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
- Creating a Self-Signed Certificate
- Creating a Self-Signed Certificate CS 7.x
- IE-11 Not able to connect via Core Services 3.1.4 Apache Server using TLS v1.2
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