After a quick inspection, I decided to tackle the project by compacting the DB in first place. Spiceworks keeps a lot of logs regarding the system activity, which are located on C:\Program Files\Spiceworks\Log. In order to clean them, the first step is to stop Spiceworks service.
Logs are stored in two main locations:
- C:\Program Files\Spiceworks\Log, for the Spiceworks service
- C:\Program Files\Spiceworks\httpd\log\, where the Apache server keeps them
Once the logs are cleaned, I compacted the DB to increase the performance, and I started the service again.
Ticket rules were configured to auto assign support tickets, thus saving time to the support operators.
And the user portal was customized to match the company colors and logo.