User management in Ubuntu

Posted on Posted in Linux-Ubuntu, Programming

Show last user logins into the system lastlog | less Currently logged in users in the system who Add new user adduser username usergroupname (perl calling useradd) useradd username Delete user userdel username userdel -r username removing home directory deluser with /etc/deluser.conf (Debian and derivatives) deluser –remove-home    

Windows 10 Add better sendto functionality

Posted on Posted in Programming, Windows

Adds multiple file send to functionality Create SendToMailRecipient.vbs somewhere executable with the code below Create a shortcut link to it Put the link in the directory opened with shell:sendto Option Explicit Dim objArgs, OutApp, oNameSpace, oInbox, oEmailItem, olMailItem Dim a, oAttachments, subjectStr, olFormatHTML olMailItem = 0 olFormatHTML = 2 Set objArgs = WScript.Arguments ‘gets paths […]

Inverse selection in File Explorer

Posted on Posted in Windows

Use Invert Selection for Easier File Selection in Windows Explorer The next time you need to select most of the files in an open Explorer window don’t waste your time holding down Ctrl and clicking each file manually. It’s much easier to select the ones you DON’T need, and then let Windows reverse your selection. […]

Excel tips

Posted on Posted in Windows

Freezing Rows and Columns If you have a lengthy spreadsheet containing tons of data, you may have to scroll too far down or even across to view it all. This means you will lose sight of your headings and find yourself constantly scrolling back to see them. However, if you freeze the rows and columns, […]

Windows 10 annoyances

Posted on Posted in Windows

1. You can not map a network drive with different users on the same remote server. Microsoft says “it is by design”. Why?. There is no clear answer… but there are no technical barriers. 2. Control Panel has disappeared. But there is no substitute for many functionalities. 3. Selecting default app for a file extension […]

Bash Reference

Posted on Posted in Linux-Ubuntu, Programming

The Shebang (#!) In the beginning, first line of the file, no spaces. Next, absolute path to the script interpreter (might change, but better to execute anywhere), in this case: /bin/bash Call to the script does not look in current directory, so ./ is necessary or it has to be included in PATH Special System […]

Check Ubuntu Hardware

Posted on Posted in Linux-Ubuntu, Programming

List summary of hardware: lshw -short List summary of PCI devices: lspci -v H/W path Device Class Description =========================================================== system PowerEdge R420 (SKU=NotProvided;ModelName=PowerEdge R420) /0 bus 0K29HN /0/0 memory 64KiB BIOS /0/400 processor Intel(R) Xeon(R) CPU E5-2403 v2 @ 1.80GHz /0/400/700 memory 128KiB L1 cache /0/400/701 memory 1MiB L2 cache /0/400/702 memory 10MiB L3 cache […]

How to check the MySql version

Posted on Posted in MySql, Programming, Uncategorized

Create a query with: SHOW VARIABLES LIKE “%version%”; Result is similar to: Variable_name            Value                          ———————–  —————————— innodb_version           5.6.35                         protocol_version         10                             slave_type_conversions                                  version                  5.6.35-log                     version_comment          MySQL Community Server (GPL)   version_compile_machine  x86_64                         version_compile_os       Win64