Category: Windows

EXCEL IP address management

Excel Formulars for German Excel: B1 : =LINKS(A1;FINDEN(“.”;A1)-1) C1 : =TEIL(A1;FINDEN(“.”;A1)+1;FINDEN(“#”;WECHSELN(A1;”.”;”#”;2))-FINDEN(“.”;A1)-1) D1 : =TEIL(A1;FINDEN(“#”;WECHSELN(A1;”.”;”#”;2))+1;FINDEN(“#”;WECHSELN(A1;”.”;”#”;3))-FINDEN(“#”;WECHSELN(A1;”.”;”#”;2))-1) E1 : =TEIL(A1;FINDEN(“#”;WECHSELN(A1;”.”;”#”;3))+1;255)    

Putty Logfiles with timestamp

I am just trying to automate my Cisco telnet and SSH connection to get nice information that is not provided by the Cisco SNMP Mib jet. I am talking about the “show crypto session” command. The output looks a little…

NTP management on windows

Windows has a very different approach to handle NTP timeserver configuration and management. You can either use the the time configuration panel “internet time” or the “new” cmd command w32tm.     Or you use the much more reliable w32tm…