Pinned topic BES Utilities
SY57_Jim_Montgomery 270004SY5732 PostsACCEPTED ANSWER
Re: BES Utilities2009-12-10T23:25:49Z in response to jpeppers91We want to run it weekly as a scheduled task with a service account. We get some access denied problems when testing with that account, even though he's admin on the box. He's not allowed to restart filldb. We thought it may be UAC, but it looks like its turned off. We run it manually with our admin accounts for now.
I don't know enough about how Win 7 and Win 2008 run processes securely. I don't think its a tool problem; its our configuration/understanding of Win 2008 problem.
manjukris91 270004W1531 PostACCEPTED ANSWER
Re: BES Utilities2010-03-25T09:47:43Z in response to jpeppers91Hi. I am new using BESComputerRemover.exe. I tried deleting computers which has IsDeleted=1. But this doesn't seem to delete. The following is the log. Everytime I run, I get the same log message. Please let me know if i am missing something.
START: BESComputerRemover v. 184.108.40.206 started at: Thu Mar 25 15:05:46 2010
No time specified for deletion of Expired Computers, defaulting to 30 days.
No time specified for deletion of Deleted Computers, defaulting to 90 days.
- Duplicate Computers *
Total Number of Duplicate Computers: 1
- NotReported Computers *
Total Number of NotReported Computers: 0
- Expired Computers *
Expiration Period: 30 Days
Total Number of Expired Computers: 4
- Deleted Computers *
Expiration Period: 90 Days
Total number of Computers affected: 2
Number of rows in ACTIONRESULTS table: 1
Number of rows in QUESTIONRESULTS table: 652
Number of rows in LONGQUESTIONRESULTS table: 0
Number of rows in FIXLETRESULTS table: 277
Number of rows in COMPUTER_ADMINISTRATORS table: 0
Number of rows in COMPUTER_COMMENTS table: 0
Total Number of Rows for Deleted Computers: 930
END: BESComputerRemover completed at: Thu Mar 25 15:05:47 2010
mbp911 270003XN3N5 PostsACCEPTED ANSWER
Re: BES Utilities2011-08-11T00:42:07Z in response to jpeppers91I am looking for a solution that allows me to delete computers from the database older than X days. The Bes Computer Remover does this efficiently and can be used as a sheduled task, however, I need to be a bit more targeted. I would like to perform a deletion using a group(s). Is there anything in terms of a sql script that may accomodate this? Is there any plans to include this in a new revision of the tool.
Also, I have used the revised Bes Computer Remover in our QA TEM 8.1 environment and see that passing the days doesn't seem to work correctly. I attempted to remove machines that have not reported in 15 days and noticed that it only deleted machines greater than 30.
mbp911 270003XN3N5 PostsACCEPTED ANSWER
Re: BES Utilities2011-08-18T19:04:29Z in response to jpeppers91Ultimately, a tool or script that can have machines passed to it to mark it as â€œIs deletedâ€ would be perfect. We routinely review our clients to verify if the machine is valid or if it is orphaned using AD and other sources. Using this method we could utilize the BES Computer Remover to delete on â€œIs Deletedâ€ Machines rather than all machines based on a specified number of days.
jdefilip 2700069Y456 PostsACCEPTED ANSWER
Re: BES Utilities2013-09-26T20:13:04Z in response to mbp911
I'm using the following as a scheduled task:
BESComputerRemover-220.127.116.11.exe -u <sql user> -p <password> -A -f -l -L . -D -C -T 90 -t 60
I'm having issues though after upgrading the environment to 9.0.777.0.
Taken directly from the page I linked to in the previous posting ...
This tool will perform database operations for the following sets of data:
- 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.
I use a batch file with the following line ... BESComputerRemover-18.104.22.168.exe -f -l -L . -D -c -T 180 -t 90
- It runs silently (-f)
- Standard output goes to a log file (-l)
- I specify the folder to create the logs in (-L)
- It removes duplicate computers based on Computer Name. (-D)
- It removes Computers that have not reported in 90 days. (-t)
- It purges Computer data for computers that have not reported for 180 days. (-T)
- I don't want the tool to waste time counting the rows it will delete. (-c)
All of the optional arguments are spelled out on the page.
- -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.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.
- -A : Run all database cleaning operations.
- -D : Mark Duplicate Computers as deleted. -N : Specify a text file with computer names to be deleted. -P <PropertyName> : Use the specified retrieved property to find duplicate computers, like "Mac Address". (Default "Computer Name")
- -n : Mark NotReported Computer as 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).