HTH0029 - I Am A Single Core Brain
Outages, Microsoft Ignite reactions and feelings, Excel Vlookup is cool, a story about wifi, a new "That is Accurate," and Question of the Week! Extended show notes available at https://hthpc.com Boot Up • SLACK OUTAGE • M365 outage ○ MO222965 - What is the point of posting this to a portal nobody can get to? ○ Root Cause Analysis posted • Ignite post-game show ○ Thoughts overall ○ NO SWAG! ○ Also the Vmware VMWorld post-game show within a show ○ Physical Ignite is so much better ○ Azure VMware Solution ○ Microsoft Announces Ignite, Part 2, is Happening in March ○ Exchange – Here, There and Everywhere - External Forwarding Command Center and Certificate-Based Authentication (CBA). On-prem Exchange now subscription only ○ PowerShell Unplugged - Challenge Edition ○ Taking your automation to the next level with PowerShell 7 ○ Microsoft Mechanics 2020 ○ RIP Defender ATP, new name Microsoft Defender for Endpoint ○ Video Hub • Random bug of the day ○ When using multiple Container tabs/accounts for the same website, Twitter/Anchor in Firefox seems to require a cached reload (CTRL F5) for likes/retweets/notification counts to clear. Anchor needs it for certain settings to save. ALL HAIL VLOOKUP • Why Vlookup ○ Say your master server inventory is inconsistent with your VMWare inventory, how do you find out what's missing? Vlookup • How Vlookup ○ Syntax: Source cell, Range to look up, column index, exact match (false most of the time) • Who Vlookup ○ People in a hurry • Where Vlookup ○ Say you are trying to merge multiple lists of data. How do you link them? Vlookup + copy + "Paste values" Declassified Sysadmin Stories: The impossible wifi project • (What happens when a sysadmin attempts a wifi project by himself) • Project was in 2016 • Replace ancient HP Procurve wireless infrastructure with Cisco infrastructure ○ ProCurve 420 and 530 WAPs ○ Rebootable via PoE, they frequently died • Perform tests all over campus, run scans, tests, learn a lot of about radios ○ Test with lights on, lights off, doors open/closed, microwaves, bathrooms, water, etc • Vistumbler, Airport Utility, RSSI • Carts with long cables • Limited number of Cisco APs (30 Aironet CAP1602i), not enough to cover the campus • MAC-Daddy registration for all standard wifi devices, ancient Linux box, student project from years past that became production • Learned all about RADIUS (NPS) • MAC registration for non-802.1x compliant devices ○ Test things like Zune HD, Wii U, Wii U in Wii Mode, PS3, PS4, Xbox 360, Xbox One, 3DS, Android Tablets, TVs, etc ○ Visual Studio .NET app called MacDaddyJr - Form to CSV - PS Scheduled Task to create AD Users for MACs, add to group, change primary group • Manually build out two Cisco WLC 2500s for the APs to talk to + interface with parent company controller • Summer of wiring • Impossible fiber line repair: Line going from campus to building we didn't own with difficult owner to athletics building/hangar that was rarely used in the first place That is Accurate • Azure has the most Global regions than any other cloud provider Ask the Stiffs: Question of the Week • What is your favorite current piece of tech [wrong answers only]? Outro - "Plus Delta" • We help you, you help us: Rate us on iTunes --- This episode is sponsored by · Anchor: The easiest way to make a podcast. https://anchor.fm/app