Technical FAQs

Ask a Question

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*"
Was this helpful?
What can we do to improve the information ?