Get Dell service tag on Ubuntu

$: sudo dmidecode -t system | grep Serial

Tags: Dell BIOS Service Tag

Check domain controllers from command line

c:\> netdom query dc

Tags: Active Directory, Command Line

Can't install Pop!_OS 20.10 without disk encryption

 This is my first time to install Pop!_OS (20.10) on VirtualBox (6.1.16). I tried to install 3 times but I can't find an option to install it without disk encryption. What was also confusing was that I am not seeing any option to go Back or Next or Confirm the options, see below.

Figure 1. First Screen

Figure 2. Encryption page - no option for no encryption

Given the size of the window I was suspecting that there must be areas not shown on the screen. So, I killed (xkill) the installation then changed display settings to 1024x768 and behold - now I can see the install buttons!

Figure 3. Change display settings to 1024x768

After changing screen resolution, buttons are now visible during installation.

Getting "Native error= Cannot find the specified file" when running a console app in MonoDevelop

On Ubuntu 20.10 with MonoDevelop 7.8.4 build (2), running a console application generates the following error message: 

ApplicationName='/usr/lib/gnome-terminal/gnome-terminal-server', CommandLine='--app-id mono.develop.id5647740ca7f5455da9c27ab2c320a029', CurrentDirectory='', Native error= Cannot find the specified file

 

To fix this do:

$: sudo mkdir /usr/lib/gnome-terminal
$: cd /usr/lib/gnome-terminal
$: sudo ln -s /usr/libexec/gnome-terminal-server

 

Reference: https://stackoverflow.com/questions/59336129/error-when-trying-to-run-code-debugger-operation-failed-native-error-cannot-f

Installing MonoDevelop on Ubuntu 20.04

 To install MonoDevelop on Ubuntu 20.04/20.10, do:

$: sudo apt install apt-transport-https dirmngr
$: sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 3FA7E0328081BFF6A14DA29AA6A19B38D3D831EF
$: echo "deb https://download.mono-project.com/repo/ubuntu vs-bionic main" | sudo tee /etc/apt/sources.list.d/mono-official-vs.list
$: sudo apt update
$: sudo apt-get install monodevelop
$: echo "deb https://download.mono-project.com/repo/ubuntu vs-focal main" | sudo tee /etc/apt/sources.list.d/mono-official-vs.list
$: sudo apt update
$: sudo apt upgrade

Note that:

• As of this writing (12/22/2020) https://www.monodevelop.com/download/ only shows support for Ubuntu 18.04
• I have only tested this on very simple application - console and Gtk2 dialog app
• You will notice that I started installing using Bionic (Ubuntu 18.04) and then changed to Focal (Ubuntu 20.04) to upgrade all the libraries
• This applies to Pop!_OS 20.10
  

Display SQL Server version from the command line

 To get the version of SQL Server, run the following:

c:\> osql /E /S .\INSTANCE_NAME -Q "select @@version"

Log ping output with timestamp

Log ping output with a timestamp to a file. This will create a new log file every hour.

@echo off

SETLOCAL EnableDelayedExpansion

REM set /p host=host Address: 

set host=%1

echo Host target : %host%

:Ping

for /F "tokens=* skip=2" %%A in ('ping %host% -n 1 ') do (  

    REM Get the hour

    SET X=%time:~0,2%

    REM Remove space

    SET "X=!X: =!"

    REM Pad with zero

    SET PADDED=0!X!

    REM Get the last 2 chars

    SET PADDED=!PADDED:~-2!

    REM Get the expanded value

    SET CURVAL=!PADDED!

    SET logfile=log_!date:~10,4!-!date:~4,2!-!date:~7,2!_!CURVAL!.log

    echo %date% %time:~0,2%:%time:~3,2%:%time:~6,2% %%A>>!logfile!

    echo %date% %time:~0,2%:%time:~3,2%:%time:~6,2% %%A

    timeout 1 >NUL 

    rem GOTO END

    GOTO Ping

)

:END

Reference:

https://stackoverflow.com/questions/24906268/ping-with-timestamp/40591307#40591307

 

Convert binary performance data to CSV

Convert binary performance (perfmon) data to CSV:

c:\> relog logfile.blg -f csv -o logfile.csv

References:

https://community.microfocus.com/t5/Silk-Performer-Knowledge-Base/How-can-I-convert-a-Windows-Performance-Monitor-file-from-blg-to/ta-p/1743393