Sunday, 10 September 2023

Show SSID Password in WIndows

netsh wlan show profile

netsh wlan show profile name="SSID" key=clear

netsh wlan show profile name="SSID" key=clear | findstr Key



Monday, 10 April 2023

Finding the Manufacturing Date on Cisco Switches

switch# show version

The serial number is in this format: LLLYYWWSSSS

LLL = location of the supplier
YY = year of manufacture
WW = week of manufacture
SSSS = serial-id

Year codes:
01 = 1997
02 = 1998
03 = 1999
04 = 2000
05 = 2001
06 = 2002
07 = 2003
08 = 2004
09 = 2005
10 = 2006
11 = 2007
12 = 2008


Tuesday, 28 March 2023

Cannot connect to one of many SSIDs on a AP

AP has multiple SSIDs but randomly cannot connect to one SSID. The device is trying to negotiate and authenticate but cannot receive an IP address from the AP.  This can cause due to DHCP pool of available IP addresses being exhausted and there are many conflicts. To resolve the issue:

  • connect to the main switch at the site
  • show run | section dhcp
  • clear all conflicts: clear ip dhcp conflict *
  • ip dhcp pool guest_wireless
  • lease for 8 hours: lease 0 8
  • end
  • wr
  • show interface counters errors 


Sunday, 26 March 2023

Testing the Internet Speed via CLI

  • Speed test: npm install -g speed-test
  • to run: speed-test
  • Fast.com: npm install -g fast-cli
  • to run: fast -u


Sunday, 8 January 2023

HCI - Calculating the Available Storage

 For calculating the available storage given a certain number of disks, nodes, and RF:

((disk-size * #disks * #nodes)/RF) * 0.92

OR 

((#disks * #nodes * disk size)*0.93(Metadata)*0.7(Storage Operating Threshold))/(RF(replication Factor)*0.63(Storage Optimization Gain))


SQL: Generate a range of numbers

SELECT ones.n + 10*tens.n + 100*hundreds.n + 1000*thousands.n FROM       (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) ones(n),      (VALU...