Andrew Foster at Topland Communications reached me via Upwork looking to customize and fine tune a existing Spiceworks installation.
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.
![](https://i0.wp.com/arturobaldo.com.ar/wordpress/wp-content/uploads/image-1.png?resize=580%2C307&ssl=1)
And the user portal was customized to match the company colors and logo.
![](https://i0.wp.com/arturobaldo.com.ar/wordpress/wp-content/uploads/image-2.png?resize=580%2C635&ssl=1)