by ezs | Jun 26, 2020 | evilzenscientist
More to come on this – here’s my placeholder to do a cleaner write up.
Notes:
[Zoom] – OAUTH – API – PowerShell – Excel
Great Zoom PowerShell module from Joseph McEvoy
Quick and dirty PowerShell to read meeting registrants and values of custom questions.
$ZoomRegistrants = Get-ZoomMeetingRegistrants [meetingid] -pagesize 300
$reghashtable = $zoomregistrants.registrants
$outputs = $reghashtable |foreach-object {
return [pscustomobject]@{
regtime = “$($_.create_time)”
email = “$($_.email)”
fname = “$($_.first_name)”
lname = “$($_.last_name)”
member = “$($_.custom_questions.value[0])”
pco = “$($_.custom_questions.value[1])”
campaign = “$($_.custom_questions.value[2])”
}
}
$outputs | convertto-csv
by ezs | Jun 23, 2020 | evilzenscientist
Weekend – “cases surge” in US sun belt states. Another delve into Google search to find the missing Saturday BBC update.
Now over 10MM global cases – and the daily cases is quickly picking up again. Sustained 170k new cases per day.
US new cases is massive – 40k plus per day. Even comparing against Tuesday this is horrific. Again – from JHU.
Weekly update from The Seattle Times. That long slow uptick in cases looks to be mainly from Yakima county. Moving average of around 400 cases/day – which is similar to early April.
Friday – 40k daily cases in the US, TX bars ordered to close. The status quo isn’t working. Social distancing and wearing a mask does. VP Pence claims “US Progress” which is not clear.
Thursday – UK sun – and tens of thousands crowding beaches. US cases continue to climb.
Wednesday – over 9M global positive cases; 500K deaths.
Tuesday – WA Statewide requirement to wear masks in public. Booming cases in Yakima county and broad uptick across the state.
Global daily cases is growing; US daily cases dipped in May after the NY outbreak slowed; but is now picking up again. Back at March/April new cases rates. Graphs from JHU.
Monday – UK starts to open up fully. UK considers social distancing change from 2m to 1m.
Local and global coverage for future reference.
by ezs | Jun 15, 2020 | evilzenscientist
Weekend – WHO reports 150k new cases globally on Thursday. Almost 9M reported cases. 2.2M in US.
Usual weekend update via The Seattle Times.
Friday – UK alert system lowered, King county (and Issaquah) move to Phase 2 of reopening. Meanwhile cases are picking up again and WHO warns against a new danger. Virus detected in sewage water from Turin and Milan that was collected in December.
Thursday – contact tracing is hard. Contact tracing with untested mobile applications is even harder. Google and Apple built a framework; UK NHS decided otherwise. It doesn’t work.
Wednesday – WA cases, like in many other states, have ticked upwards. There’s a big argument whether this is more exposure and transmission (warmer weather, folk not distancing, holidays) or through more testing (I don’t believe so). Dexamethasone improves clinical outcomes. No vaccine in sight.
Tuesday – slowly and carefully WA state opens up. King County applies for “Phase 2 reopening”. New Zealand has two cases via travellers from the UK – quarantine testing wasn’t consistent.
Monday – another week. The news continues to oscillate between coronavirus, BLM protests and other news. June gloom (overcast, cool, raining) as always. Looking back – I didn’t think this would be a quarter of the year spent collecting news and data. Looking forward – what is the appropriate update frequency? So much was new and concerning back in early March. That now seems the new normal. Documenting the changes so there is a contemporaneous record I think will be important.
Concerning this morning: new hotspots in Beijing (see yesterday), India and Iran. This looks like a second wave.
Local and global coverage for future reference.
by ezs | Jun 14, 2020 | evilzenscientist
Since adding the Ubiquiti access points and security gateway – I’ve been using the Unifi Controller on an Ubuntu server.
Much hackiness to get this installed on Ubunto 20.04 with a newer Mongodb. The good news is that the newest release (5.13.29) has the correct metadata to support installing on a new Ubuntu, with newer mongodb.
Happy news – and no more reliance on community hacks.
by ezs | Jun 8, 2020 | evilzenscientist
Weekend – Second wave stories everywhere – US states, Beijing, UK.
UK death rate slowing quickly. Latin America growth; Brazil as epicenter.
Seattle Times data for the week.
Friday – UK GDP shrank by 20% in April. Lots of discussion about the steps needed to “be in the office” to get a task done – VP approval, limited ingress and egress routes, security notification, masks required.
Thursday – the news cycle slowly pivots back to coronavirus. US at more than 2 million positive cases. Contact tracing not working well in the UK – third of positive cases missed.
Wednesday – UK needs planning for return to school in September. Work is looking at “next year” for return.
Another reminder on searching for specific day coronavirus coverage:
The Guardian: https://www.theguardian.com/world/live/2020/mmm/dd/coronavirus
BBC News: https://www.bbc.com/news/live/world and “As it happened”
Tuesday – Somehow my post from this day got deleted – rewrite time. Lots of examples of “early reopening” causing a huge uptick in positive coronavirus cases.
Arizona:
Monday – yes, this is week 14. We will be at day 100.
As we approach the end of the school year (in the Northern hemisphere at least) – eyes are looking forward to school and university return. Still unknown what any of that really looks like.
Good news: Berlin, Paris, Dublin reopening. UK reports lowest coronavirus death toll since 22 March.
Bad news: More reports of moving average positive cases ticking up across multiple US states.
It looks like The Seattle Times have stopped with their live local updates page for coronavirus. I’m not surprised – the massive protests across Seattle have drained their newsroom.
Local and global coverage for future reference.
by ezs | Jun 1, 2020 | evilzenscientist
Weekend – retrospectively – is this the week that changed the US? When will that be clear? Certainly there is a large grass roots outpouring of anger, support and a desire for change. An enormous story that knocked the coronavirus story from the front pages. Ironic (infuriating?) that on the anniversary of D Day that “anti antifa” is the Trump campaign slogan.
Almost two million cases in the US – and still climbing. I expect a pretty rapid rise in the non-distancing states, as well as second waves in others.
More counties opening in Washington state. A slight uptick in positive confirmed cases at the tail end of last week. More testing or a result of folk being out for the sunny weekend at the end of May?
Dozens of coronavirus victims being found weeks after death. That is distressing.
Lowest UK numbers of new cases – and zero deaths in NI and Scotland.
Sunday updates from The Seattle Times
Friday – hydroxychloroquine does not work against coronavirus – again.
Thursday – multiple states reporting upticks in number of cases; aligning closely with the lack of social distancing.
Wednesday – Brazil overtakes Italy in terms of deaths. Very avoidable.
Tuesday – truly exhausting. I couldn’t imagine that anything would take a global pandemic off the headlines.
Monday – my entire newsfeed has switched from coronavirus reporting and emerging from lockdown, to majority peaceful Black Lives Matter protests and the parallel violence, looting and associated police responses. There is even a curfew in Issaquah , WA.
Local and global coverage for future reference.
by ezs | May 25, 2020 | evilzenscientist
Weekend – Lockdown relaxation bringing spikes in new cases. Open too soon? Probable. Sports are slowly returning. Continued protests across the US. Continuing rioting in some areas. Seattle has 1700-0500 curfew in place. Attacks against the press.
Weekly look at WA state numbers via the Seattle Times.
Friday – Minneapolis burning. Trump tweets inciteful language. CNN camera crew arrested while broadcasting live. None of it COVID related. Lockdown being relaxed across the globe.
Thursday – sunny and warm again. Trump threatening “action” against social media companies by Executive Order. New cases of COVID in WA are mainly in under 40s. That’s worrying. Potential mutation?
Wednesday – after a week of gloom – the sun is out again – and warming up. Hopefully local social distancing and masks prevail. 100k US deaths from Covid – that’s over a 90 day period. That’s 3-4 plane crashes per day. The scale of deaths is just not comprehended. 50% of US people would not take a vaccine.
Tuesday – back to work. Cummings fallout continues in the UK. Hydroxychloroquine trials are dropped. WHO warns of second peak. Second COVID birthday in the family.
Monday – Memorial Day in the US. The start of summer. A holiday. For week 12 – it’s another day at home. Too many reports of folk out and not distancing or wearing masks. I suspect a combination of tribal politics, fatigue and “it only gets old people”. New case rate in Washington State is relatively flat (~250 per day), and death rate is slowly going down (single digit trend). I think early action had a massive effect.
Local and global coverage for future reference.
by ezs | May 19, 2020 | evilzenscientist
Weekend – a long weekend. Dominic Cummings row is slowly coming to the boil in the UK. BBC summary search optimisation: https://www.bbc.com/news/live/world as the root. Horrible.
Saturday data from The Seattle Times
Friday – plenty of discussion about Washington State unemployment and how it’s been hit by online fraud. Identity theft and reuse of PII seem to be the cause. Good results from a project at work – “six months of work done in two weeks”. Churches “essential” says Trump, pandering to the base.
Thursday – another day of triple booked meetings. Urg. Work now realise that meetings are sucking every morsel of productive time out of the day. It’s like Microsoft again. Looking to reduce meeting load for the team. Daily standup and get to work.
Wednesday – 16 hours back to back on calls. Some work, some for 5th LD Dems. Online voting went really well. Cloudflare fronting a huge Azure E20s_v3 (160GB RAM, 20 vCPU) and zero issues.
Tuesday – continued linear growth of the number of cases around the globe. Second peaks appearing in the US. Lockdown isn’t consistent. Counting of deaths in the US is being fudged for political reasons. US trailing 7 day trend is down – but it’s mainly bubbling out the New York cases, remove that data and it’s up, up, up. 22k/day new cases.
Monday – Week 11. Really? Week 11? This week looks busy – AP exams for the eldest, big project trying to go live at work, building a voting mechanism for the local Dems. News continues to look positive (careful reopening of parts of WA State), negligent (widespread, willful ignoring of masks) and terrifying (Russia and Brazil cases)
Local and global coverage for future reference.
by ezs | May 12, 2020 | evilzenscientist
Weekend – first time out without the kids in 10 weeks. Socially distanced barbecue in the mountains. Brazil and Russia cases are growing quickly. UK daily deaths dropping.
Seattle Times continues with great local coverage; The Guardian summaries are another good archive (note: Google/Bing for site includes https://www.theguardian.com/world/live/2020/mmm/dd/uk-cornavirus-live to find the majority of hits; BBC urls are really unfindable if you miss them).
Friday – echoing the experience in WA state – care homes, nursing homes and similar are a real hotspot for infection. “Warp Speed” for vaccine.
Thursday – 36M unemployed in the US, quarter of workforce on benefits, this winter could be “bleakest ever”.
Global case count is still increasing.
Wednesday – Coronavirus may never go away say WHO.
Tuesday – Russia coronavirus cases explode. Brazil 881 deaths today. Fauci says US not under control.
Tuesday data from The Seattle Times:
Monday – Week 10. UK lockdown guidance
Local and global coverage for future reference.
by ezs | May 10, 2020 | evilzenscientist
Last year I noted that the ASUS Access Points were pretty much end of life. A pair of RT-AC66U and RT-AC68U had been providing pretty solid wifi coverage for trusted, untrusted and guest devices for around seven years. Sporadic updates from ASUS; more frequent updates from RMerlinDev – but a clear sunsetting of seven year old hardware.
I had been eying multiple vendors over the last year or so – with an eye to replace both the trusted, untrusted and guest wifi with a consolidated set of hardware. In addition the edge firewall/IDS/IPS running IPfire was due for a replacement. Everything gets old.
I settled on Ubiquiti and their Unifi range. A couple of Unifi-AP-HD Access Points and a Unifi Security Gateway Pro should last a while. Future proofing – with an eye on end-to-end IP6 and fibre to the home – both should easily handle the additional complexity.
I built the Unifi Controller on a dedicated Ubuntu 20.04 server. That was a pain. Notes: MongoDB versions, JRE versions – and installation of the deb package. All too painful.
Recent Comments