Example: Read Data From Separate Hosts/Commands File And Log To Individual Files

[rtb]

Demonstrates how to connect to hosts read in from a "hosts" file and for each host, send a list of commands read in from a "commands" file. Results of each command run are (by default) logged to separate, uniquely-named files based on the host address and the command that is run. However, the script code is architected to allow you to change this behavior so that it's all logged to one file per host, or even just to a single file.

Download the example scripts:

Python Version (for use on Mac/Linux/Windows versions of SecureCRT):
RunCommandsOnMultipleHostsAndLogResults.py.txt
Last updated: 08 Jun, 2021

VBScript Version (for use on Windows versions of SecureCRT):
RunCommandsOnMultipleHostsAndLogResults.vbs.txt
Last updated: 21 May, 2018 (this script is no longer being updated/maintained)

Example ##hosts.txt and ##commands.txt files:
The following show you the format of what the ##hosts.txt and ##commands.txt files would look like.

• ##hosts.txt
• ##commands.txt
• ##DeviceType1Commands.txt
• ##DeviceType2Commands.txt

The ##hosts.txt file can contain host-specific command file directives, which is what the ##DeviceType1Commands.txt and ##DeviceType2Commands.txt files exemplify.



.

[Levittown]

Todd:

Also, is there is a way to stop the output from pausing? For instace, if the command output is too long, it will not complte the log file unless I manually press the enter key until the output is completed.

Thank you

[Levittown]

Also,

The first host execute the command, but on the second host, I get the following error:

CRT Scripting Runtime error
Error: Sreen.CurrentRow: not connected
Line 186 which points to the following line of code:
nRow = crt.Screen.CurrentRow

[miked]

The first host execute the command, but on the second host, I get the following error:

CRT Scripting Runtime error
Error: Sreen.CurrentRow: not connected
Line 186 which points to the following line of code:
nRow = crt.Screen.CurrentRow

SecureCRT is not connected at that point. You need to be connected to the server before using crt.Screen.CurrentRow. I think there's probably much more going on here than we know yet, and should see a log file.

Also, is there is a way to stop the output from pausing?

Can you send a SecureCRT raw log file showing the output pausing?

To create a raw log:

1. Before connecting with the session, select "Raw Log Session" from SecureCRT's "File" menu.
   
2. In the "Select Log File" dialog, choose a folder and filename in which you would like the log text to be stored and press the "Save" button. At this point, if you open the "File" menu, you will notice that the "Raw Log Session" menu item now has a check-mark next to it; this indicates that raw logging is activated.
   
3. Now connect to the remote machine and perform the actions which cause the reported problem to occur.
   
4. Once the problem occurs, disconnect the session and select "Raw Log Session" from the "File" menu to turn off the raw logging feature.
   
5. Browse to the location of the raw log file and add the file as an attachment to your e-mail reply.

[Levittown]

I follow your instructions, but the log is empty. I can clearly see that secrteCRT connects to the second host, but it doesnt issue a command, and then I get the error...

Originally Posted by miked

SecureCRT is not connected at that point. You need to be connected to the server before using crt.Screen.CurrentRow. I think there's probably much more going on here than we know yet, and should see a log file.

Can you send a SecureCRT raw log file showing the output pausing?

To create a raw log:

1. Before connecting with the session, select "Raw Log Session" from SecureCRT's "File" menu.
   
2. In the "Select Log File" dialog, choose a folder and filename in which you would like the log text to be stored and press the "Save" button. At this point, if you open the "File" menu, you will notice that the "Raw Log Session" menu item now has a check-mark next to it; this indicates that raw logging is activated.
   
3. Now connect to the remote machine and perform the actions which cause the reported problem to occur.
   
4. Once the problem occurs, disconnect the session and select "Raw Log Session" from the "File" menu to turn off the raw logging feature.
   
5. Browse to the location of the raw log file and add the file as an attachment to your e-mail reply.

[joeboy]

Is there a python version of this example? Thanks!

[rtb]

Hi joeboy,

Thanks for the question. I have one in the works, but it is not yet complete. I will post here when it is.

[Elder]

I second the req for a python version. Well done RTB!

[bgagnon]

Hi Elder,

Todd (RTB) is not available.

I will make sure he knows you "second the motion".

[rtb]

Hi All,

I have finally finished my Python port of the VBScript version of this script. Have at it.

[quinj]

Is the Python program will work for Windows 7 too?

[bgagnon]

Hi quinj,

Yes, SecureCRT is capable of hosting "ActiveX Script" engines. Python scripts can be run in SecureCRT/Windows.

[quinj]

I apologize, the python program on this thread can be used in Windows 7. Looking at it inside, it all shows Windows XP.

Thanks
quinj

[hvh2000]

Hi, I'm using this excellent script. I have a noob question - as it is the script saves the configuration files using the IP address in the filename, I am using fqdn's to connect to the devices, so am curious how one would modify it so that the file name reflects what was passed to the script in the hosts.txt file instead of the IP. There may be cases where I use an IP, but if I use an fqdn, I'd prefer the output file to use it as well.

[rtb]

Hi hvh2000,

Thanks for the post. It seems like you are using the VBScript version. If I am wrong, please correct me because the log file code is different between the VBScript and Python versions.

In the VBScript code starting on line 257, the IPADDRESS portion of the template name gets replaced with the IP address (g_objNewTab.Session.RemoteAddress). Line 260 could be modified to use g_strhost which is obtained on line 136 from the host file.

Does this help you accomplish your goal?