• https://gist.github.com/zthxxx/9ddc171d00df98cbf8b4b0d8469ce90a

Note that Office2019 DO NOT support activate via simple copy/paste plist license file which is the simplest way to activate Office 2016. Fortunately, you can also use the VL Serializer tool, just install Office 2019 and Serializer, then run Serializer to activate.

• Download Office 2019 Volume License Serializer from https://macadmins.software
• Run Serialiser tool after installing - but before - opening Office.

Have a runaway process with hundreds or thousands of programs (eg: cmd.exe) all running and need to kill them all in one go?

taskkill /F /IM cmd.exe
taskkill /F /IM bash.exe

Method 1 with the TSM GUI

• Launch Terminal Services Manager (in Administrative Tools)
• In the menu: Actions “Connect to Computer…”
• Enter name of server you want to get on to
• Right-click and logoff one of the displayed sessions

Method 2 with Command prompt

• Launch Windows (DOS) box
• Enter “query session /server:<servername>”
• Enter “logoff <ID> /server:<servername>”

What an awful language!

set NLS_LANG ======
@echo NLS_LANG has been cleared
@FOR /F "usebackq delims=!" %%i IN (`sqlplus -s /nolog @set_NLS_LANG.sql`) DO @set NLS_LANG=%%i
@echo NLS_LANG has been set to %NLS_LANG%

This one is particularly interesting as I need to start a shell Cygwin shell script on a regular basis
As crontab is not implemented by default, I use the Windows Scheduler to start the jobs.
This one creates a task called dbamon_dblist tat runs a shell every 10 minutes starting at 9 am and going on for 24 hours (so, forever).
It is run a user different from the logged on user. The echo at the start is to answer N to the question “Task exists, do you want to replace it”. For some reason that doesnt work too well :(

echo N|SCHTASKS /Create /SC MINUTE /MO 10 /TN dbamon_dblist /TR "c:\\cygwin\\bin\\bash.exe -l -c /cygdrive/c/home/ibmtools/scripts/oracle/dbamon_dblist.ksh" /ST 09:00 /RU runasuser /RP runaspwd

• Check task scheduler log

Advanced:View log …

"Backup_archivelog_perl_NETTP_auto.job" (perl)
\tFinished 1/9/2015 1:10:00 PM
\tResult: The task completed with an exit code of (80).
"dbamon_datapump.job" (bash.exe)
\tFinished 1/9/2015 1:10:23 PM
\tResult: The task completed with an exit code of (1).

• Check error code given

C:\\ibmtools\\scripts\\oracle\\perl>net helpmsg 80

The file exists.


C:\\ibmtools\\scripts\\oracle\\perl>net helpmsg 1

Incorrect function.

Not very helpful on the part of Microsoft but the 80 error turned out to be a whole load of sqlplus.exe processes (100's) hanging around in the task manager
Killed them and jobs started running again.