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
○ MO222965 - What is the point of posting this to a portal nobody can get to?
○ Root Cause Analysis posted
○ Also the Vmware VMWorld post-game show within a show
○ Physical Ignite is so much better
○ 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
○ 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.
○ Say your master server inventory is inconsistent with your VMWare inventory, how do you find out what's missing? Vlookup
○ Syntax: Source cell, Range to look up, column index, exact match (false most of the time)
○ 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)
• 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
• 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
• 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
• 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]?
• We help you, you help us: Rate us on iTunes
