TEM Computer Remover

This page has not been liked. Updated 7/9/15, 11:42 PM by KarenKueTags:

This page contains information about the TEM Computer Remover tool for Windows and Linux servers.

 

Note: Starting from version 9.2 Patch 3, you can manage expired and deleted computers also through the BESAdmin command. The new advanced options inactiveComputerDeletionDays, inactiveComputerPurgeDays, and inactiveComputerPurgeBatchSize provide the same functions as the BigFix Computer Remover arguments -e, -t, -E, -T, -b. For more information, see Advanced options for customizing computer removal in List of advanced options.

 

For Windows Servers

Download Links

Download - version 3.0.1.159 (4.16 MB)

Download - version 3.0.1.157 (4.16 MB)

Download - version 3.0.1.156 (4.16 MB)

 

Usage Help file for the current version

This command line utility is designed to automate the process of removing computers from the BigFix Console and deleting the data from the database.

The tool breaks up the deletion operations into several categories to allow lots of flexibility and options in how data is removed. Some operations will simply mark a computer as being deleted in the database. In this way the computer does not appear in the BigFix Console or Web Reports. However, marking a computer as being deleted does not remove any data from the database and if the computer reports back in, it is restored. The tool also supports the removal of data about computers from the database to free up disk space and allow the database to run faster. Computers that have data physically removed from the database will have to send a full refresh report if they report in again. The full refresh report contains all of the data from the client and replaces the data that was removed by this tool.

This tool will perform database operations for the following sets of data:

  • Removal of Computers by name - Accepts a text file with a list of computer names separated by new lines and removes them from the deployment.
  • Duplicate Computers - Marks older computers as deleted if a computer exists with the same computer name.
  • NotReported Computers - Marks computers as deleted if there are no property results being reported and schedule a full refresh for the computer.
  • Expired Computers - Marks computers as deleted if they have not reported in recently.
  • Deleted Computers - Physically removes computer data from the database for computers that are already marked as deleted and have not reported in for a long period of time.

 

Note on expected behavior

When removing computer information from the database using the -E option, the BESComputerRemover.exe tool will only remove QUESTIONRESULTS, ACTIONRESULTS, and FIXLETRESULTS information associated with the computers on the COMPUTERS table in the BFEnterprise database. The tool will not remove the actual computer records that are in the COMPUTERS table.
 
When you check the COMPUTERS table in the database you will never see the number of computer records decrease that have a value of 1 in their IsDeleted columns: select count(*) as 'Total IsDeleted Computers' from COMPUTERS where (ISDeleted=1)

 

Additional Information

Batched deletion - Deleting large sets of data causes the SQL transaction log to grow quickly. The log will temporarily be larger than the data being removed until the database is shrunk. Batched deletion removes results in sets and pauses between each set, giving you time to shrink and reclaim disk space as you proceed.

Note: Batched deletion is supported only when cleaning up deleted computers.

 

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 BESComputerRemover-3.0.1.159.log.
-L <Folder> : Specify a folder to create logs in. Do not include a file name.
-d <BigFix DSN> : Used to specify a DSN to connect to the BigFix 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.
-A : Run all database cleaning operations.
-D : Mark Duplicate Computers as deleted.
-P <PropertyName> : Use the specified retrieved property to find duplicate computers, like "IP Address".  (Default "Computer Name")
-N : Specify a text file with computer names to be deleted.
-e : Mark Expired Computers as deleted.
-t <days>: Specify the number of days after which an Expired Computer will be marked as deleted. (Default 30)
-E : Remove data from the database for Deleted Computers.
-T <days>: Specify the number of days after which computers marked as deleted will have their data removed. (Default 90)
-c : Do NOT count data before deleting.
-b <batch size> : Performs database deletion operations in batches of this size. The tool will pause between batches until the user presses a key (unless run in silent mode with -f).
 



Sample calls:

BESComputerRemover-3.0.1.159.exe -h

BESComputerRemover
-3.0.1.159.exe -l

BESComputerRemover
-3.0.1.159.exe -l -L "C:\Temp"

BESComputerRemover
-3.0.1.159.exe -d database_dsn -u database_user -p database_password

BESComputerRemover
-3.0.1.159.exe -A -f -l

BESComputerRemover
-3.0.1.159.exe -A -b 2500000 -l





 

For Linux Servers

Download Links

Download - version 3.0.2.11 (5.29 MB)

Download - version 3.0.2.9 (5.29 MB)

Download - version 3.0.2.8 (5.29 MB)

Download - version 3.0.2.7 (5.29 MB)

Download - version 3.0.2.6 (5.29 MB)

Download - version 3.0.2.5 (5.29 MB)

Download - version 3.0.2.4 (5.29 MB)

Download - version 3.0.2.3 (5.29 MB)

 

Usage Help file for the current version

The downloaded package includes the three files: BESComputerRemover.shBESComputerRemover binary, and BESComputerRemover_linux_help.txt.

To use the tool, you just need to:
  1. Extract the tar file (BESComputerRemover_v3.0.2.#.tar) on the server system.
  2. Edit the file BESComputerRemover.sh to update the DB2LIBPATH and DB2INSTANCE variables (if needed).
  3. Run the tool using the command the command ./BESComputerRemover.sh  with the proper options. 
NOTE: Make sure you run the BESComputerRemover.sh, instead of the BESComputerRemover binary, because the environment has to be properly set to allow the tool to run.

To display the usage of the tool your can use the option "-h" or look at the BESComputerRemover_linux_help.txt.

This command-line utility is designed to automate the process of removing computers from the BigFix Console and deleting the data from the database. The tool breaks up the deletion operations into several categories to allow lots of flexibility and options in how data is removed. Some operations will simply mark a computer as being deleted in the database. In this way the computer does not appear in the BigFix Console or Web Reports. However, marking a computer as being deleted does not remove any data from the database and if the computer reports back in, it is restored.  The tool also supports the removal of data about computers from the database to free up disk space and allow the database to run faster.  Computers that have data physically removed from the database will have to send a full refresh report if they report in again.  The full refresh report contains all of the data from the client and replaces the data that was removed by this tool.

 
This tool will perform database operations for the following sets of data:
  • Removal of Computers by name - accepts a text file with a list of computer names separated by new lines and removes them from the deployment.
  • Duplicate Computers - Marks older computers as deleted if a computer exists with the same computer name.
  • NotReported Computers - Marks computers as deleted if there are no property results being reported and schedules a full refresh for the computer.
  • Expired Computers - Marks computers as deleted if they have not reported in recently.
  • Deleted Computers - Physically removes computer data from the database for computers that are already marked as deleted and have not reported in for a long period of time.

 

Additional Information

Batched deletion - Deleting large sets of data causes the SQL transaction log to grow quickly. The log will temporarily be larger than the data being removed until the database is shrunk.  Batched deletion removes results in sets and pause between each set, giving you time to shrink and reclaim disk space as you proceed.

Note: Batched deletion is supported only when cleaning up deleted computers.

 

Command Line Arguments

Optional Arguments:

-h : Displays this help message.
-? : Displays this help message.
-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 BESComputerRemover.log
-L <Folder> : Specify a folder to create logs in. Do not include a file name.
-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.
-H <hostname> : Used to specify a hostname for SQL authentication to the database.
-d <port>     : Used to specify a port for SQL authentication to the database.
-C <db name>  : Used to specify the database name.
-A : Run all database cleaning operations.
-D : Mark Duplicate Computers as deleted.
-P <PropertyName> : Use the specified retrieved property to find duplicate computers, like "IP Address".  (Default "Computer Name")
-n : Mark NotReported Computer as deleted.
-N : Specify a text file with computer names to be deleted (One entry for each line).
-e : Mark Expired Computers as deleted.
-t <days>: Specify the number of days after which an Expired Computer will be marked as deleted. (Default 30)
-E : Remove data from the database for Deleted Computers.
-T <days>: Specify the number of days after which computers marked as deleted will have their data removed. (Default 90)
-c : Do NOT count data before deleting.
-b <batch size> : Performs database deletion operations in batches of this size. The tool will pause between batches until the user presses a key (unless run in silent mode with -f).
  

Sample calls:

./BESComputerRemover -h
./BESComputerRemover -l
./BESComputerRemover -l -L "/tmp"
./BESComputerRemover -u database_user -p database_password -H database_hostname -d database_port -C database_name
./BESComputerRemover -A -f -l
./BESComputerRemover -A -b 2500000 -l