One line (or very brief) helpers

[jthompson]

Change PowerShell tab autocomplete behaviour to be more like Linux (i.e. complete only as far as uniquely possible, rather than cycling through matches in order).

 

Set-PSReadLineKeyHandler -Key Tab -Function Complete

 

To revert to default behaviour, it would be -Funtion TabCompleteNext

[mavhc]

Now if it would tab complete backwards, because verb-noun. You can type *-X, but that's annoying

[mavhc]

winget upgrade --all

[jthompson]

Quickly enter timestamps into a spreadsheet.

 

Excel and Google Sheets:

Ctrl+; stamps the current date

Shift+Ctrl+; stamps the current time

 

Google Sheets bonus:

Shift+Ctrl+Alt+; stamps the current datetime

[jthompson]

Google Maps. Right-click on the map and select Measure distance to get a handy measuring tool.

 

[jthompson]

Rename a Chrome browser window so that custom text is shown for it in the Windows taskbar, rather than the active page name - Three pips -> More tools -> Name window....

For example, a window that would ordinarily have a name of "Wordle - The New York Times" could be named as "Daily Tasks".

[jthompson]

Generate barcodes in Google Sheets (also Docs, Sites, etc.)

 

To present any text as a barcode, open the font selection list, select More fonts and search for Libre Barcode. There are a few formats to choose from, with or without a text label underneath.

 

You may need to wrap text between asterisks, but that's simple enough to formulate in Sheets.

 

[6Foot2]

G-Mail will soon be enforcing 2-step authentication:

 

[clareq]

At a command prompt:

 

query user /server:

 

will tell you who's logged on, and at which time they did so - useful if Impero isn't working or to check whether a user has really rebooted.

[6Foot2]

[Chromebook] Scroll rapidly by pressing the Alt key, or the Everything key with the cursor key pointing in the direction you want to scroll quickly.

[jthompson]

[Android] Switch quickly between accounts in a Google app (e.g. Gmail) by swiping up or down on the account badge, without having to open the account switcher menu.

[robintech]

Cheap Android projectors used in Textiles/Photography Exams display at the start of each loop an "Unsupported Audio" message with exported PowerPoint videos/ videos that have no audio track

 

FFmpeg can add a silent audio track that stops the message coming up

ffmpeg -f lavfi -i anullsrc=channel_layout=stereo:sample_rate=44100 -i originalvideo.mp4 -c:v copy -c:a aac -shortest output.mp4

[6Foot2]

Percentages are reversible: 50% 0f 15 = 15% of 50. One can be easier to calculate in your head than the other (depending upon the values involved)

[mikeprice]

Percentages are reversible: 50% 0f 15 = 15% of 50. One can be easier to calculate in your head than the other (depending upon the values involved)

 

WOW

 

Kinda obvious when you think of it

 

but I have never though about it!

[6Foot2]

WOW

 

Kinda obvious when you think of it

 

but I have never though about it!

 

Yeah, I think we know intuitively - this just puts it into words quite nicely.

 

[6Foot2]

Yeah, I think we know intuitively - this just puts it into words quite nicely.

 

 

In a similar vein (mathematically) A number squared, is one more than the product of the numbers adjacent to that number: 5² = 25, is one more than 4 x 6 (24)

 

[DalekSec]

Form cool thread: Pro tip: When plugging in USB-A , the plastic bit inside the connector always goes to the bottom of the motherboard (well everything I've ever done!), not much luck for vertical ports im afriad

[mavhc]

Form cool thread: Pro tip: When plugging in USB-A , the plastic bit inside the connector always goes to the bottom of the motherboard (well everything I've ever done!), not much luck for vertical ports I'm afraid

 

I look for the join in the metal, it's on the bottom

[jthompson]

GAM command to clear out any internal addresses from users' Other Contacts, to avoid them appearing as conflicting recipient suggestions in Gmail. This example will clear out any "@myschool.org" addresses from the Other Contacts list of all users in or under the OU "Staff".

 

gam ou_and_children_ns /Staff delete othercontacts emailmatchpattern ".*@myschool.org"

 

Might be particular to gamadv-xtd3.

[robintech]

On older devices that redirect modern browsers to an error page , add the root URL of the device to 'Internet Explorer mode' in Edge before browsing to it, otherwise it will add the only the Error page URL to Internet Explorer mode if you add the site at that point in the process, and you keep getting redirected. Edited October 5, 2023 by ittech2342323

[jthompson]

I've just noticed that you can use Markdown syntax in Google Docs - https://support.google.com/docs/answer/12014036

 

Not all of the Markdown syntax is supported, but headings, bold, italic, strikethrough, lists, links and inline code (`) works.

[mavhc]

Uninstall old versions of Python:

Get-WmiObject -Class Win32_Product |where vendor -eq "Python Software Foundation" |where version -like 3.8.* | foreach-object {$_.Uninstall() }

[jthompson]

[Android] Switch quickly between accounts in a Google app (e.g. Gmail) by swiping up or down on the account badge, without having to open the account switcher menu.

 

Additionally, swiping left or right switches between work and personal profile (if you're using a work profile).

[jthompson]

BIOS password recovery for all sorts of makes and models: https://bios-pw.org/

 

Discovered this whilst needing to clear a BIOS admin password from a Dell Latitude 3190. One of a number of devices that were donated to us from a now defunct organisation. Most had had the password cleared prior to being donated to us, but this one hadn't and there was no contact with previous IT staff.

Somewhat amazed that it worked!

[SimonWindisch]

If you want to find out which computers have metered connections with Configuration Manager (SCCM) then the CMPivot query is

 

Registry('hklm:\SOFTWARE\Microsoft\DusmSvc\Profiles\*\*') | where Property == 'UserCost'

 

Value = 2 means it's metered

Edited March 12, 2024 by SimonWindisch