Press "Enter" to skip to content

Posts published in “Software”

Windows Free Email Server -MailEnable Installation and Configuration

0

MailEnable is the software I installed on my lab environment DC server, which has been used to testing other system's email function. It is free, integrated well with AD, Web Login/Web Admin supported, smtp/pop supported. No complaints to this software for its functionality.

Here I posts some configuration tips my own notes. In case I forgot some settings during re-installation.

Putty Tips and Tricks

0

1. Putty Auto Login into Session with Username and Password
Create a bat file and you can schedule it to run with following command:
C:\tools\putty.exe -load session_name -l your_user_name -pw your_password
Wherein session_name is the saved session name, your_user_name is your SSH login user name and your_password is the password. Change “C:\tools\putty.exe” to the path of your own putty.exe.
You can use this to make the SSH Socks5 VPN even more easier to use with a bat file to become schedule task

VanDyke SecureCRT Settings (Tips and Tricks)

0

VanDyke SecureCRT provides  IT pros a very user-friendly client to manage command line devices and SSH hosts with. Connecting to devices securely is one thing, and there are other products that can achieve this goal, but with SecureCRT, multiple connections can be managed in tabs to allow you to work between sessions without changing windows.

Here are some my favourite settings to customize SecureCRT:

1. Edit Default Settings for terminal Emulation
If you are using Linux devices, please choose Linux as your Terminal. For network / security devices, use VT100 will be best choice.

I also like to set Scrollback Buffer to 5000. If you choose ANSI color, the appearance color will be depending on the color codes sent by the remote application.

Using Group Policy to Deploy Software Packages (MSI, MST, EXE)

0

Group Policy is a feature of Windows Server using which admins can install software on all user computers. It can be done remotely without manual intervention. GPO is short for Group Policy. It becomes so popular among companies because it can make deployment clear and easy due to the technology of group policy. 

1. Deploy Windows MSI or MST package Using Group Policy Software Installation
YouTube GPO Deployment Video:

Windows Server Configuration Tips and Tricks

0

Building a lab to test some Windows services , AD, DNS, DHCP, ADCS, etc. in my VMware ESXi 6 environment, to get it running smoothly and reduce some headache, I used following tricks to make my life easier.

Most of work has to be done by Group Policy Management Editor. If you are running in a domain environment, create this setting accordingly in a GPO, otherwise configure the local GPO (gpedit.msc):

Edit Default Group Policy
Launch Group Policy Management

Common Used Excel Formulas

0

一、数字处理


1、取绝对值
=ABS(数字)
2、取整
=INT(数字)
3、四舍五入
=ROUND(数字,小数位数)

二、判断公式

1、把公式产生的错误值显示为空
公式:C2
=IFERROR(A2/B2,"")
说明:如果是错误值则显示为空,否则正常显示。