When troubleshooting via remote desktop or remote assistance I tend to use Tcpview.exe, Procexp.exe and Procmon.exe. To help with expediting the process of me copying these tools over to the target workstation or server I created a cmd file which I can execute as a Maven Menu item from within Maven.
Creating a Menu Item That Copies Tools
Here is a step-by-step list of instructions.
1) Create a local tools folder that will hold all of your commonly used support tools. I created mine in the root of my C:\ drive and called it “tools”.
2) Copy all of your support tools to this folder. You can download PSTOOLs from Microsoft here.
3) Create a command file in the C:\tools called copytools.cmd. If you are not sure how to do this: Open Notepad select the File menu, then Save. Add the following text:
REM %1 - computername
xcopy c:\tools\tcpview.exe \\%1\c$\
xcopy c:\tools\procmon.exe \\%1\c$\
xcopy c:\tools\procexp.exe \\%1\c$\
echo done!
2) Copy all of your support tools to this folder. You can download PSTOOLs from Microsoft here.
3) Create a command file in the C:\tools called copytools.cmd. If you are not sure how to do this: Open Notepad select the File menu, then Save. Add the following text:
REM %1 - computername
xcopy c:\tools\tcpview.exe \\%1\c$\
xcopy c:\tools\procmon.exe \\%1\c$\
xcopy c:\tools\procexp.exe \\%1\c$\
echo done!
4) Save the file.
5) Open Maven.
6) Open the Tools menu and select Configure.
7) Navigate to Main/All/Datagridview/SQL Queries/YOURQUERY/columns where YOURQUERY is the name of your main query.
8) Now on the Columns node, click the “Show” button to go to our Maven Menu.
9) Right-click on your Maven Menu and select the “Add Menu Item”.
10) In the Menu Text textbox type: Copy Tools.
11) In the Command textbox type: c:\tools\copytools.cmd.
12) In the Parameters textbox type: %computername%.
13) Press the OK button.
14) The controls will now be refreshed on the screen.
5) Open Maven.
6) Open the Tools menu and select Configure.
7) Navigate to Main/All/Datagridview/SQL Queries/YOURQUERY/columns where YOURQUERY is the name of your main query.
8) Now on the Columns node, click the “Show” button to go to our Maven Menu.
9) Right-click on your Maven Menu and select the “Add Menu Item”.
10) In the Menu Text textbox type: Copy Tools.
11) In the Command textbox type: c:\tools\copytools.cmd.
12) In the Parameters textbox type: %computername%.
13) Press the OK button.
14) The controls will now be refreshed on the screen.
Whenever you right-click on a computer from your main grid you will now be able to use your new menu called Copy Tools. You can use the above technique to copy any files. Be aware that you may be prompted to overwrite the files if they already exist.