moisei
/ Google sheets. Range from function.
Last active
May 22, 2019 11:48
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| =query(FILTER(B2:B, ISNA(MATCH(B2:B, A2:A, 0))), "select * where Col1 contains 'something'") |
moisei
/ Get-ADUser
Last active
May 2, 2019 09:00
Sorted list of ActiveDirectory users principals in lowercase
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Get-ADUser -Filter * | Sort-Object -Property UserPrincipalName | Select-Object @{E={$_.UserPrincipalName.ToLower()}} |
NewerOlder