BESDeletedCompRemover
Version: 3.0.10.7

Summary:
This tool may be used to physically remove computers from the BES database.  It will search for computers that have been marked as deleted in the database and delete the corresponding results from the ActionResults, QuestionResults, LongQuestionResults, FixletResults and ComputerAdministrators tables.  The tool should be run on the main BES Server.

Please be aware that computers removed from the database are assumed to no longer exist.  If a computer that has been removed begins to report into BES after being deleted, it will appear with a <not reported> for most of its properties and it will not appear relevant for any Fixlet messages or appear to have run any actions.  You can fix many of these problems by sending the computer a refresh in the BES Console or running the tool with the -r option.  It is highly recommended to use the -r option.

In a Distributed Server Architecture Deployment (BES 7.0), this tool should be run on every BES Root Server.

Command Line Arguments
Optional Arguments:
-h : Displays this help message
-? : Displays this help message
-help : Displays help message for installing this tool as a service.
-f : Runs in silent mode.  No standard output and script runs automatically to completion.
-l : Sends standard out to logfile created in the directory of this application with name BESDeletedCompRemover.log
-l <Folder> : Specify a folder to create logs in. Do not include a file name.
-d <BES DSN> : Used to specify a DSN to connect to the BES Database with.  Defaults to bes_bfenterprise if not specified
-u <username> : Used to specify a username for SQL authentication to the database.
-p <password> : Used to specify a password for SQL authentication to the database.
-r : Marks computers as needing to perform a full data refresh on the next registration attempt. The BES FillDB service will be restarted by using this option. FillDB needs to be restarted before it will notice the backend change which schedules BES Clients to be refreshed.
-c : Runs additional queries to count the number of rows that will be deleted prior to deletion.
-C : Delete computer comments.  Not enabled by default since computer comment data will not be restored if it is deleted and the BES Client reports in again.  Comments will be restored if they are not deleted and the BES Client reports in again.
-b <Batch Size> : Deletes data in sets of <Batch Size> rows to prevent the database from being locked for an extended period of time.  Using this mode may cause the total amount of time spent deleting to increase however.
-M <minutes> : Only delete computers that have not reported in over <minutes> minutes.
-H <hours> : Only delete computers that have not reported in over <hours> hours.
-D <days> : Only delete computers that have not reported in over <days> days.

Sample calls:
BESDeletedCompRemover.exe -h
BESDeletedCompRemover.exe -l
BESDeletedCompRemover.exe -l -L "C:\Temp"
BESDeletedCompRemover.exe -d database_dsn -u database_user -p database_password
BESDeletedCompRemover.exe -r
BESDeletedCompRemover.exe -D 90 -r -c
BESDeletedCompRemover.exe -D 90 -b 250000