Automation Tips

Automation Tips form server managements

Dictionary

• SRE(Site Reliability Enginerring) : jp - https://codezine.jp/article/detail/11002

Linux

SSH

• connect server by ssh with no password(jp)
  • https://qiita.com/m1220/items/9dc3856bbcf985577023

Cron

• See all user's crontab
  • for user in $(cut -f1 -d: /etc/passwd); do echo $user; crontab -u $user -l; done

File control

• split & merge(combine) files
  • https://www.ostechnix.com/split-combine-files-command-line-linux/
• split files with options(jp)
  • https://uxmilk.jp/8584

Configuration

• Change JAVA_HOME path
  • https://www.cyberciti.biz/faq/linux-unix-set-java_home-path-variable/

Windows

github

recent git application does not support windows 2008 server. download below and downgrade git ssh

• https://github.com/git-for-windows/git/releases/tag/v2.16.1.windows.1
  • resolve this error message : fatal: full write to remote helper failed: Broken pipe

SQL Servers

• Export JSON under sql server 2014
  • https://github.com/ahliana/SQLTableOrViewToJSON

AutoHotKey

• Official site : https://www.autohotkey.com/
  • CSV Handling Library : https://github.com/hi5/CSV

Data Aceess

Apache Drill

• Official site : https://drill.apache.org/
  • SQL Server jdbc plugins : https://www.microsoft.com/en-US/download/details.aspx?id=11774