Hans hansgafriedzal
hansgafriedzal
/ sharepoint-add-pssnapin.ps1
Last active
September 10, 2018 07:40
hansgafriedzal
/ get-top-unused-logspace.sql
Last active
April 17, 2018 10:32
This file contains hidden or 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
| DECLARE @logspace TABLE ( | |
| db_name VARCHAR(255) | |
| ,size FLOAT | |
| ,used FLOAT | |
| ,[status] INT | |
| ) | |
| INSERT INTO @logspace | |
| EXEC ('dbcc sqlperf(logspace)'); |
hansgafriedzal
/ get-w3wp-process-ids.bat
Created
April 26, 2018 02:17
This file contains hidden or 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
| %systemroot%\System32\inetsrv\appcmd.exe list wp |
hansgafriedzal
/ gsheet-left-vlookup-first-non-blank-cell.txt
Last active
May 17, 2018 08:40
This file contains hidden or 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
| =index(A:B,match(+filter(B:B,B:B<>""),B:B,0),1) |
hansgafriedzal
/ excel-left-vlookup-last-non-blank-cell.txt
Last active
April 1, 2019 11:52
This file contains hidden or 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
| =index(A:B,max(row(B:B)*(B:B<>"")),1) |
hansgafriedzal
/ Template.ps1
Last active
May 8, 2020 04:32
This file contains hidden or 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
| function Log | |
| { | |
| param ( | |
| $Object, | |
| $ForegroundColor, | |
| $BackgroundColor, | |
| [switch] $NoNewLine | |
| ) | |
| Write-Host @PSBoundParameters |
hansgafriedzal
/ shortcut-keys-whatsapp.txt
Last active
September 10, 2018 07:39
This file contains hidden or 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
| Ctrl + N : start new chat | |
| Ctrl + Shift + ] : next chat | |
| Ctrl + Shift + [ : previous chat | |
| Ctrl + E : archive chat | |
| Ctrl + Shift + M : mute | |
| Ctrl + Backspace : delete chat | |
| Ctrl + Shift + U : mark as unread | |
| Ctrl + Shift + = : zoom in | |
| Ctrl + 0 : default zoom level | |
| Ctrl + - : zoom out |
hansgafriedzal
/ excel-substr.file.extension.txt
Created
July 25, 2018 11:39
This file contains hidden or 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
| =REPLACE(RIGHT(A1,5),1,SEARCH(".",RIGHT(A1,5)),"") |
hansgafriedzal
/ Get-DisabledUac.txt
Last active
July 30, 2018 12:42
This file contains hidden or 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 * -Property userAccountControl ` | |
| | Where {[Convert]::ToString($_.useraccountcontrol,2).PadLeft(25,'0').substring(23,1) -eq '1'} ` | |
| | Select userAccountControl -Unique ` | |
| | Sort -Property userAccountControl |
hansgafriedzal
/ sharepoint-userdisp-force.txt
Last active
August 6, 2018 03:53