To access this tool, go to the tools menu in the main menu bar, and select Database Maintenance Tools, then select Delete Records from sub menu. Once this has been done, the following dialog box will appear:
Figure 1: Delete Tool Form
The fields used in this form are described below:
Delete records older than 'x' days
This option allows you to delete the records older than 'x' number of days where x is user defined.
On the basis of
This option allows you to take backup on the basis of DeviceReportedTime and ReceivedAt Time (these fields are defined in the SystemEvents Table).
Note: DeviceReportedTime and ReceivedAt Time are different from each other.
The DeviceReportedTime is actually the time that is there in the Windows Event Log i.e. the time at which the (e.g. syslog) message was written into the Windows Event Log.
ReceivedAt time on the other hand is the time when the (e.g. syslog) message is received at the configuration program e.g. MonitorWare Agent.
Delete All Records
If you check this option than all the records are deleted from the database to which the MonitorWare Console is connected.
Figure 2: Delete Tool Form - Delete all records
Note: If you press the "Backup deleted items in a text file" over here then it will take the backup of all the records and then these records are deleted from the underlying database to which MonitorWare Console is connected.
Delete
When you press this button a message box will appear that will give you a warning that this will delete all the records permanently. If you press yes to it, the records would be deleted permanently.
Backup deleted items in a text file
As you can see from the "Deletion Tool Form" in figure 2, the File Name, File Path and Browse Button are grey-scaled. This scenario occurs if you have not checked "Backup deleted items in a text file" option. Once you have checked the "Backup deleted items in a text file" option these options become valid as shown below:
Figure 3: Delete Tool Form - Backup Deleted item in a text file
If this option is checked then it also takes the backup of deleted (which are to be deleted) records in the specified path.
File Name
This option allows you to define the name of the file in which the backup of the deleted records would be taken.
File Path
This option allows you to define the path of the file where the backup of the deleted records would be taken.
Browse
When this button is pressed, a dialog appears as shown in the figure 4. This allows the user to select the desired path on which the backup file will be saved.
Figure 4: Browse - Select Folder Form
Delete + Backup
When this button is pressed then the records that are defined in the specifed range are deleted from the database to which MonitorWare Console is connected but the backup is taken before hand.
Cancel Backup
By pressing this button, the "Deletion Tool" form is closed.