Skip to content

Latest commit

 

History

History
61 lines (44 loc) · 2.62 KB

ssh client session export file generator.md

File metadata and controls

61 lines (44 loc) · 2.62 KB
Raw

ssh client session export file generator

When you need dynamic changed ssh client session for large scale of networking, or need to migrate session between different workstation, one click to create a export session file will be handy.

SecureCRT and mobaXterm are most common used ssh clients in daily work.

How to run it

  • build up host access info table in excel: column Hostname,HostIP,RemotePort,Username
  • select range of above 4 colmuns
  • run macro from excel Developer tab or create a customzied ribbon
  • run office scripts from excel Automate tab

VBA macro list

Source code here.

Sub ScrtExport()

secureCRT export session xml generator

  • input data is selection of column Hostname,HostIP,RemotePort,Username
  • will generate session file .\Export\Session\scrt-<active-sheet>-<timestamp>.xml
  • all sessions will be under folder which name from active sheet
  • open generated secureCRT session file in notepad for review

Sub mobaExport()

mobaXterm export session mxtsessions generator

  • input data is selection of column Hostname,HostIP,RemotePort,Username
  • will generate session file .\Export\Session\mobaxterm-<active-sheet>-<timestamp>.mxtsessions
  • all sessions will be under folder which name from active sheet
  • open generated mobaXterm session file in notepad for review

Office Scripts list

Source code here.

ScrtExport-console.osts

secureCRT export session generator to console

  • input data is selection of column Hostname,HostIP,RemotePort,Username
  • will generate session content and output to console
  • all sessions will be under folder which name from active sheet

ScrtExport-sheet.osts

secureCRT export session generator to new sheet

  • input data is selection of column Hostname,HostIP,RemotePort,Username
  • will generate session content and output to new sheet 'scrtExport'
  • all sessions will be under folder which name from active sheet

mobaExport-console.osts

mobaXterm export session mxtsessions generator to console

  • input data is selection of column Hostname,HostIP,RemotePort,Username
  • will generate session content and output to console
  • all sessions will be under folder which name from active sheet

mobaExport-sheet.osts

mobaXterm export session mxtsessions generator to new sheet

  • input data is selection of column Hostname,HostIP,RemotePort,Username
  • will generate session content and output to new sheet 'mobaExport'
  • all sessions will be under folder which name from active sheet