An overview of the SWCS 4.2 Company Maintenance Utility

An overview of the SWCS 4.2 Company Maintenance Utility

Summary

This article provides an overview of the SWCS 4.2 Company Maintenance Utility, what it is and when you should use it.

More Information

The SWCS 4.2 Company Maintenance Utility was created to automate some basic maintenance functions that should be performed on any SWCS company database on a regular basis. The functions that this utility performs are:

  • Cleaning up the event log
  • Cleaning up the audit log
  • Optimizing the database

Cleaning up the event log

During normal operation of the Solatech Window Covering Software various events are recorded in the event log for diagnostic purposes. Over time this log can grow causing the database to grow in size. In order to reduce the size of the database the event log must be purged. This can be done in the SWCS software but it's easier to do it using this utility. If the box 'Cleanup the event log' is checked then the utility will look for any events that are six months or older. These events will be saved to a text file in the folder \ProgramData\Solatech\SWCS42CMU and then deleted from the company database.

Cleaning up the audit log

Just like the event log, the audit log can also grow over time, usually faster than the event log. If the box 'Cleanup the audit log' is checked then the utility will look for any audit event older than six months, save them and then delete them.

Optimizing the database

During normal operation of your software the database can grow in size and become fragmented. By checking the box 'Optimize the database' the utility will attempt to speed up the performance of the database by reindexing the tables, removing unused space and shrinking the size of the  database files.

Using the utility

To run the SWCS 4.2 Company Maintenance Utility, run the Solatech Window Covering Software. From the File menu click Utilities. Then find the program called 'swcs42cmu' and double-click it. Follow the instructions.

APPLIES TO

  • Solatech Window Covering Software 4.2

    • Related Articles

    • Overview of the SWCS 4.2 Shipping and Delivery Manifest

      Summary This article provides an overview of the SWCS 4.2 Shipping and Delivery Manifest and explains how to setup and use this feature in the software.  To add this feature to the software, download and install this hotfix: ...
    • Overview of Inventory Control

      Summary This article provides a broad overview of the steps and detail required to successfully implement Inventory Control within the Solatech Window Covering Software package. More Information Most people tend to oversimplify the requirements for ...
    • How to rename a SWCS company database

      Summary This article explains how to rename a SWCS 4.2 company database. More Information There are a few prerequisites that must be met before you rename the company database: The Microsoft SQL Server Management Studio Express tool must be installed ...
    • Creating mailing labels for your SWCS customers

      Summary Using the SWCS 4.2 Export Utility and Microsoft Word, create mailing labels for the customers in your Solatech Window Covering Software. More Information Microsoft Word has powerful mail merge capabilities that can be used to easily create ...
    • Performing advanced database tasks with SWCS 4.2

      Summary This article explains how a user can perform advanced database management tasks on a SWCS 4.2 company database. More Information The Solatech Window Covering Software version 4.2 uses Microsoft SQL Server 2005 as it's database engine. During ...