How to end Excel and repgen tasks from the command line

Issue
The system has a large number of process running Excel.exe and possibly repgen.exe


Product
ION Enterprise 6.0.x
StruxureWare Power Monitoring (SPM) 7.0.x
Power monitoring Expert (PME) 7.2.x, 8.0

Environment
Windows Server 2003, 2008, 2008 R2, 2012, 2012 R2, Windows 7

Cause
At times when "repgen/Reporter" is launched from a scheduled task, the process does not end properly and the task continues to run.

Resolution
1) Create a text file with the following commands

taskkill /f /im "reportgen.exe"
taskkill /f /im "excel.exe"
pause

2) Save this file as batch file 'Filename'.bat

3) Right click on the file and select Run as Administrator

Note:
The above commands will stop all instances of excel and repgen without any prompts. More information about taskkill is included below

TASKKILL [/S system [/U username [/P [password]]]] { [/FI filter] [/PID processid | /IM imagename] } [/T] [/F]

Description:
This tool is used to terminate tasks by process id (PID) or image name.

Parameter List:
/S    system           Specifies the remote system to connect to.

/U    [domain\]user    Specifies the user context under which the command should execute.

/P    [password]       Specifies the password for the given user context. Prompts for input if omitted.

/FI   filter           Applies a filter to select a set of tasks. Allows "*" to be used. ex. imagename eq acme*

/PID  processid        Specifies the PID of the process to be terminated. Use TaskList to get the PID.

/IM   imagename        Specifies the image name of the process to be terminated. Wildcard '*' can be used to specify all tasks or image names.

/T                     Terminates the specified process and any child processes which were started by it.

/F                     Specifies to forcefully terminate the process(es).

/?                     Displays this help message.

Examples:
TASKKILL /IM notepad.exe
TASKKILL /PID 1230 /PID 1241 /PID 1253 /T
TASKKILL /F /IM cmd.exe /T
TASKKILL /F /FI "PID ge 1000" /FI "WINDOWTITLE ne untitle*"
TASKKILL /F /FI "USERNAME eq NT AUTHORITY\SYSTEM" /IM notepad.exe
TASKKILL /S system /U domain\username /FI "USERNAME ne NT*" /IM *
TASKKILL /S system /U username /P password /FI "IMAGENAME eq note*"

Publicado para: Schneider Electric Portugal