General-purpose PowerShell, F#, and other scripts
Branch: master
Clone or download
Latest commit b357553 Feb 15, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github Add metadata Nov 21, 2017
.vscode Add VSCode repo-level settings; correct raw string Nov 21, 2017
fsxfmt Include .fsx and .vba scripts in readme builder Jan 5, 2017
.editorconfig Add magic number test script Mar 3, 2018
.gitattributes New scripts for hash selection & param passing Dec 2, 2017
Add-CapturesToMatches.ps1 Script to add GitHub metadata; old CLR fix for match captures Dec 4, 2017
Add-GitHubMetadata.ps1 Break out UTF8 BOM/SIG scripts Mar 5, 2018
Add-Utf8Signature.ps1 Break out UTF8 BOM/SIG scripts Mar 5, 2018
Add-VsCodeDatabaseConnection.ps1 Convert PSObject.Properties to Get-Member Jun 29, 2018
Add-Xml.ps1 Add first batch of input & output detail. Jul 30, 2017
Backup-File.ps1 More input & output detail Aug 15, 2017
Backup-SchTasks.ps1 Override contemptable default for Out-File Oct 6, 2017
Convert-ScheduledTasksToJobs.ps1 Fix bad triggers Jun 7, 2018
Convert-Xml.ps1 Add XSLT script and TLS 1.2 as a reasonable default Dec 6, 2018
ConvertFrom-DataRow.ps1 Improve row conversion, use for reporting Jan 2, 2019
ConvertFrom-EscapedXml.ps1 Next batch of input & output detail. Jul 30, 2017
ConvertFrom-Html.ps1 Add progress detail, completion Jan 22, 2019
ConvertFrom-UserAgent.ps1 Add user agent parsing Sep 9, 2018
ConvertFrom-XmlElement.ps1 More input & output detail Aug 15, 2017
ConvertTo-BasicAuthentication.ps1 Complete credential param attributes Dec 21, 2017
ConvertTo-LogParserTimestamp.ps1 Next batch of input & output detail. Jul 30, 2017
ConvertTo-OrderedDictionary.ps1 Next batch of input & output detail. Jul 30, 2017
Copy-SchTasks.ps1 Create shortcuts, read ASP event; add defaults. Jun 6, 2018
Disable-NetStrongCrypto.ps1 Update/add security protocol control scripts Aug 16, 2018
Enable-NetStrongCrypto.ps1 Update/add security protocol control scripts Aug 16, 2018
ExampleEmailReport.fsx Add VSCode repo-level settings; correct raw string Nov 21, 2017
ExampleEmailReport.html Update README Nov 29, 2017
ExampleEmailReport.png Restore chart email image from old blog post Nov 21, 2017
Export-DatabaseObjectScript.ps1 Update SQL exports to support SQL version, pipeline Dec 11, 2017
Export-DatabaseScripts.ps1 Update SQL exports to support SQL version, pipeline Dec 11, 2017
Export-Readme.ps1 Add IIS cruft scripts; fix readme script Dec 13, 2017
Export-ScheduledJobs.ps1 Additional doc detail Oct 29, 2017
Export-ScheduledTasks.ps1 Remove verbose debugging output Nov 3, 2017
Export-Server.ps1 Legacy (PowerShell3) workarounds May 29, 2018
Export-SmbShares.ps1 Add bad share path error; don't clobber old todo May 24, 2018
Export-TableMerge.ps1 Add index searching by column; doc ref updates Feb 7, 2019
Export-WebConfiguration.ps1 Legacy (PowerShell3) workarounds May 29, 2018
Find-Certificate.ps1 Add Java rehoming; fix cert filtering Dec 14, 2018
Find-Indexes.ps1 Fix example Feb 15, 2019
Find-Lines.ps1 Add more binary file extensions. May 17, 2018
Find-NewestFile.ps1 Next batch of input & output detail. Jul 30, 2017
Find-ProjectPackages.ps1 Use PSCustomObject shortcut syntax Dec 4, 2017
Find-SqlDeprecatedLargeValueTypes.ps1 Add index searching by column; doc ref updates Feb 7, 2019
Format-ByteUnits.ps1 Next batch of input & output detail. Jul 30, 2017
Format-EscapedUrl.ps1 Add spaces to escaped chars Feb 8, 2019
Format-HtmlDataTable.ps1 Next batch of input & output detail. Jul 30, 2017
Format-PSLiterals.ps1 Convert PSObject.Properties to Get-Member Jun 29, 2018
Format-Xml.ps1 Next batch of input & output detail. Jul 30, 2017
Format-XmlElements.ps1 Convert PSObject.Properties to Get-Member Jun 29, 2018
Get-AspNetEvents.ps1 Create shortcuts, read ASP event; add defaults. Jun 6, 2018
Get-AssemblyFramework.ps1 Add assembly framework reflection script Aug 28, 2018
Get-CertificatePath.ps1 Add support for finding CNG private keys Jan 28, 2019
Get-CertificatePermissions.ps1 Update .NET versions May 14, 2018
Get-CharacterDetails.ps1 Fix filename chars; add docs Jun 1, 2018
Get-ClassicAspEvents.ps1 Create shortcuts, read ASP event; add defaults. Jun 6, 2018
Get-CommandPath.ps1 Next batch of input & output detail. Jul 30, 2017
Get-ConfigConnectionStringBuilders.ps1 Fix .gitattributes syntax; add param alias Feb 15, 2018
Get-ConsoleColors.ps1 Add PowerShell usage, fix parsing Jan 5, 2019
Get-ContentSecurityPolicy.ps1 Add CSP parser Mar 27, 2018
Get-Dns.ps1 Add DNS lookup Aug 15, 2018
Get-EnumValues.ps1 Support enum values with multiple names Feb 3, 2019
Get-IisLog.ps1 Add HTTP Method searching Jan 3, 2019
Get-LibraryVulnerabilityInfo.ps1 Next batch of input & output detail. Jul 30, 2017
Get-NetFrameworkVersions.ps1 Update .NET versions May 14, 2018
Get-SslDetails.ps1 Minor example fix Apr 23, 2018
Get-SystemDetails.ps1 Convert PSObject.Properties to Get-Member Jun 29, 2018
Get-TypeAccelerators.ps1 Add script to list type accelerators/aliases Oct 23, 2017
Grant-CertificateAccess.ps1 Only conditionally import WebAdministration module Jun 29, 2018
Import-Html.ps1 Add progress detail, completion Jan 22, 2019
Import-Variables.ps1 Final input & output detail added Aug 26, 2017
Import-VsCodeDatabaseConnections.ps1 Convert PSObject.Properties to Get-Member Jun 29, 2018
Install-ActiveDirectoryModule.ps1 Try much harder to install PS AD module Sep 13, 2018
Install-SqlServerModule.ps1 Correct download explanation link. Apr 26, 2017
Invoke-CommandWithParams.ps1 New scripts for hash selection & param passing Dec 2, 2017
Join-FileName.ps1 Final input & output detail added Aug 26, 2017
Measure-DbColumn.ps1 Improve character measures Jan 8, 2019
Measure-Indents.ps1 Use PSCustomObject shortcut syntax Dec 4, 2017
Measure-StandardDeviation.ps1 Scripts to add GitHub code owners, calculate stddev Dec 1, 2017
New-DbProviderObject.ps1 More input & output detail Aug 15, 2017
New-Shortcut.ps1 Fix new shortcut script Sep 26, 2018
Optimize-Path.ps1 Use PSCustomObject shortcut syntax Dec 4, 2017
OutlookExpireTag.vba Include .fsx and .vba scripts in readme builder Jan 5, 2017
OutlookPasteFormattedIndented.vba Add Word reference info Mar 14, 2015
OutlookPasteTsvTable.vba Add Word reference info Mar 14, 2015
README.md Add index searching by column; doc ref updates Feb 7, 2019
Read-Choice.ps1 Final input & output detail added Aug 26, 2017
Remove-LockyFile.ps1 Add delete at reboot support Oct 31, 2018
Remove-Utf8Signature.ps1 Break out UTF8 BOM/SIG scripts Mar 5, 2018
Remove-WebAppHostCruft.ps1 More IIS scripting Dec 15, 2017
Remove-Xml.ps1 Final input & output detail added Aug 26, 2017
Repair-DatabaseConstraintNames.ps1 Add index searching by column; doc ref updates Feb 7, 2019
Repair-DatabaseUntrustedConstraints.ps1 Add index searching by column; doc ref updates Feb 7, 2019
Repair-GeForceExperience.ps1 Add GeForce repair script Dec 7, 2018
Reset-ConsoleColors.ps1 Add console color control Jan 2, 2019
Restore-SchTasks.ps1 Override contemptable default for Out-File Oct 6, 2017
Save-WebRequest.ps1 Add web server export and URL downloader Feb 12, 2018
Select-DictionaryKeys.ps1 New scripts for hash selection & param passing Dec 2, 2017
Select-XmlNodeValue.ps1 Final input & output detail added Aug 26, 2017
Send-MailMessageFile.ps1 Final input & output detail added Aug 26, 2017
Send-SeqEvent.ps1 Fixes and corrections for Seq logging Oct 2, 2017
Send-SeqScriptEvent.ps1 Log computer name, clarify synopsis Oct 2, 2017
Send-SqlReport.ps1 Add index searching by column; doc ref updates Feb 7, 2019
Set-ConsoleColorTheme.ps1 Support process name for themes Jan 3, 2019
Set-ConsoleColors.ps1 Fix param loop Jan 3, 2019
Set-DefaultSecurityProtocols.ps1 Update/add security protocol control scripts Aug 16, 2018
Set-XmlAttribute.ps1 Final input & output detail added Aug 26, 2017
Set-XmlNodeValue.ps1 Final input & output detail added Aug 26, 2017
Show-CertificatePermissions.ps1 Final input & output detail added Aug 26, 2017
Show-DataRef.ps1 Final input & output detail added Aug 26, 2017
Split-FileName.ps1 Fix filename split Nov 29, 2017
Test-DateTime.ps1 Final input & output detail added Aug 26, 2017
Test-FileTypeMagicNumber.ps1 Add XML detection Nov 21, 2018
Test-HttpSecurity.ps1 Final input & output detail added Aug 26, 2017
Test-Interactive.ps1 Final input & output detail added Aug 26, 2017
Test-MagicNumber.ps1 Add file type tests by magic number Mar 4, 2018
Test-NewerFile.ps1 Final input & output detail added Aug 26, 2017
Test-USFederalHoliday.ps1 Test-* should return booleans; holiday doc enhancements Mar 22, 2018
Test-Xml.ps1 Final input & output detail added Aug 26, 2017
USFederalHolidays.fsx Add F# holiday example & logparser recipe Oct 28, 2017
USFederalHolidays.html Update README Nov 29, 2017
Update-Files.ps1 Final input & output detail added Aug 26, 2017
Use-Command.ps1 Fix PowerShell param Sep 27, 2018
Use-Java.ps1 Add Java rehoming; fix cert filtering Dec 14, 2018
Use-NetMailConfig.ps1 IIS log query script. Doc cleanup. Apr 17, 2017
Use-ReasonableDefaults.ps1 Recurse system/hidden folders by default Jan 2, 2019
Use-SeqServer.ps1 Use-NamedMatches is now Import-Variables, and works for hashes and ro… Aug 29, 2016
Use-SqlcmdParams.ps1 Add documentation detail and helpful error. Correct param format. Apr 6, 2017
Use-SystemCrypto.ps1 Script for .NET crypto to inherit OS settings May 30, 2018
dataref.css Add transforms for XSchema to XHTML, XHTML to XSL-FO. Mar 14, 2015
dataref.xslt Fix XSLT syntax. Jan 31, 2017
dependencies.png Add index searching by column; doc ref updates Feb 7, 2019
logparser.sql Add F# holiday example & logparser recipe Oct 28, 2017
paket.dependencies Generate README.md Jul 17, 2016
xhtml2fo.xsl Add transforms for XSchema to XHTML, XHTML to XSL-FO. Mar 14, 2015

README.md

Useful General-Purpose Scripts

This repo contains a collection of generally useful scripts (mostly Windows, mostly PowerShell).

PowerShell Scripts

script dependencies

F# Scripts

Office VBA Scripts

  • OutlookExpireTag.vba: Too many emails remain beyond their period of relevance: daily personnel schedule changes, found item notices, office food notices, server reboot notices, weather/traffic warnings, &c. This Outlook script will allow specifying an expiration date as a hashtag in the subject of outgoing emails, since Outlook does such a good job of hiding the UI for that field. -BL
  • OutlookPasteFormattedIndented.vba: Outlook will strip single-space indents when displaying emails. If you've got, for example, syntax highlighted source code that employs any indentation of only one space, you'll want to add two spaces to the each line (adding one will not appear for text that isn't indented). This Outlook script will paste formatted text, and indent it. Requires Tools -> References -> Microsoft Word 14.0 Object Library (later versions may also work)
  • OutlookPasteTsvTable.vba: This Outlook VBA Sub can be connected to a toolbar button for pasting TSV data as an attractive, formatted table. -BL Requires Tools -> References -> Microsoft Word 14.0 Object Library (later versions may also work)