Wed, Jan 10
Tue, Jan 9
Tue, Jan 2
Fri, Dec 22
We've held all the workshops—the final one was on December 14.
@bbogaert, from my perspective (as someone who both works with Qualtrics and manages temporary contractors), that would work perfectly!
@bbogaert, there are multiple uses for a limited-access OU (strategy contractors, other temporary contractors with different situations, Qualtrics email sending), so I think it makes more sense to have a generic OU and deal with changing situations by moving accounts between OUs. That way, we don't ask Ops to replicate a new OU every time a new use case comes up.
Dec 12 2017
Dec 11 2017
Dec 9 2017
Done! As before, the results are in this spreadsheet (this time in a tab named "2017-12 run").
Dec 8 2017
Another update: I'm through the infrastructure automation, and now I'm actually running the queries. I should be finished by the end of the day.
Dec 6 2017
I've been working on this over the past couple of days. It's taking longer than normal because I'm trying to get it fully automated so future iterations will be easier, but I'm still hoping to finish by the end of the day.
Dec 5 2017
Dec 4 2017
The underlying data is the user preferences that are actually operational now, which these queries will accurately reflect. If you think more remediation for the preferences corruption needs to be done, you can take that discussion to the engineers and ops folks who work in that area. As far as I can tell, they disagree with you, and to be honest I trust them more.
Dec 1 2017
Yep, those queries would still work if you wanted to do it yourself. A few notes:
- The query for creating the intermediate table pulls from my editor-month table. I'm still keeping that updated, so that's not an issue.
- You'd need to install the multiquery package.
- I took the multiquery output and manually adjusted it in a spreadsheet to total across wikis and assign users with deactivated skins set to Vector. If I were doing it again, I'd automate that and put it in a Jupyter notebook so it was trival to rerun.
Nov 28 2017
Nov 27 2017
Nov 21 2017
Nov 20 2017
Nov 18 2017
I'm happy to do this! But it's a busy time for me and I can't make any particularly promises about timing. Feel free to ping me in the future if you want an update :)
Nov 17 2017
Nov 15 2017
Nov 14 2017
I'm happy to do this, and I'm pretty sure I can get it by December 6 as well.