One of the many things I do as a union representative, is negotiate wages with management. I argue my point using a number of tools, not least of which is the change in pay over time. I have one set of data which is what we use when negotiating, which represents the estimated change. I have another set which represents the actual change. I wanted to show not only these in relation to each other, but also the relative difference as it changes over time.
(more…)Category: How To
-
Excel: Visualising pay differences
As I’ve mentioned more than once previously, I’m a union representative. Among my many duties in this role is wage negotiations. While we negotiate collectively, I also make sure to dive into the numbers to look for the unexplained outliers, and to have them addressed.
(more…) -
PowerShell: Find User based on partial name
Some time ago, I needed to look up the account names of a handful of users in Active Directory. The information I had beforehand was their names. I did not have ADUC available to me, but I did have PowerShell. This is an excellent use case for the
(more…)Get-ADUsercmdlet when combined with the-Filterparameter. Here’s what my first stab at the problem looked like this: -
PowerShell: Finding host name from IP address
In tech support, resolving IP addresses to host names can be something you do on a relatively frequent basis. While I’ve always used the CLI
(more…)pingcommand with the-aoption, I have also been working towards higher proficiency in PowerShell. Frankly, for a single IP address, I prefer sticking with CLI. When working with a number of addresses, however, it gets a lot more interesting. -
PowerShell: Return multiple specific properties
The script I described a few weeks ago for finding all members of several groups is serving me very well indeed. I was recently asked to provide both the display name and the login name for each member in the group. This was readily achieved by modifying the script slightly. The rest of the script remains the same, so I will leave that well enough alone, and start with the following snippet:
(more…)Get-ADGroupMember $Group -recursive | Get-ADUser -property Displayname | select Displayname -
Notepad++: the Macro recorder
In my last post, I detailed how I solved the challenge of finding all the group members of a set of groups containing more than five hundred groups. While the Powershell script was very effective, I needed one more tool in order to really make quick work of it all; Notepad++.
(more…) -
Facebook: Exporting your data
Last week, I wrote about Twitter, that I’ve stopped posting there, and how I went about exporting my posting history. I actually made a similar decision with regards to Facebook back in the end of June. Like I did with Twitter, I also grabbed a copy of my data on Facebook – here’s how:
(more…) -
Twitter: Exporting your data
I’ve been a Twitter user for the better part of fifteen years, now, and it’s a platform I’ve enjoyed using. With Elon Musks takeover of the site, and the sackings that immediately followed it, I have found continuing to use it much less of an attractive proposition, and I have made the decision not to post until I see what direction the site takes.
(more…) -
Powershell: A script to find all members of several groups refined
One of the scripts that I use most often is the one I wrote about back in September of 2019. Usually, I only run it for up to ten or so groups, so it’s not a big problem to simply swap out the group name, rince and repeat. Recently, however, I needed to run it for more than five hundred groups. The sheer amount of data makes that a very different proposition.
(more…) -
Powershell: Add user to multiple groups
A while back, I had a user that had to be added to a large number (150+) of active directory groups. Rather than doing so manually, I spent a little time looking up how to automate it, and created a script to help me do it. Here’s how I constructed it:
(more…) -
Outlook: Problems opening and organizing calendars
On a relatively regular basis, I find my days packed with appointments, reminders, and meetings. At other times, I need to organize a meeting, or talk to a colleague, and need to check their availability. For these reasons, and others, I’m an active user of digital calendars. Anything that happens during the work day is listed in some way or another in my work calendar (even if simply showing my availability or lack thereof).
(more…)