Beginning with PowerShell 4.0, method names may come from variables. Here's a simple example: $method = 'ToUpper'...
Powershell
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Dynamic Parameters in PowerShell 4.0
In PowerShell, you can use variables in place of properties. This sample script defines the four property names that return profile paths, then...
Replacing Specific Characters in a Text
If you just need to replace characters anywhere in a text, you are easy off. This would capitalize every "l" in a text: "Hello...
Weird Text Formatting (and what to do about it)
Check out this code and try to find the problem: $desc = Get-Process -Id $pid | Select-Object -Property Description "PowerShell process...
Finding Services in PowerShell
Get-Service lists all services on a computer, but the information returned is very sparse. You cannot easily see what a service does, whether it is...
Getting More Than 1000 Active Directory Results
By default, Active Directory returns only the first 1000 search results when you use an ADSISearcher. This is a security mechanism designed to...
Hiding Parameters from IntelliSense
Beginning with PowerShell 4.0, a script author can decide to hide function parameters from IntelliSense. This way, less frequently used parameters...
Finding Active Directory User Accounts Fast
The more specific your LDAP query is the faster and less resource intense the query is, and the more precise are the results as well. For example,...
Finding Active Directory Accounts by SID
If you know the SID and would like to find the corresponding Active Directory account, then LDAP queries won't work well. For them to work, you...
Searching in Different Domains
When you use the ADSISearcher type accelerator to find Active Directory accounts, it defaults to the current domain you are logged on to. If you...
Getting Domain from DN
A "DN" (Distinguished Name) is the path to an Active Directory object and could look similar to this:...
Converting Binary SID to String SID
Active Directory accounts contain the SID in binary form. To convert the byte array into a string representation, use a .NET function like this: #...
Finding Current Script Folder
Beginning in PowerShell 3.0, there is a very easy way of determining the folder a script is located in: $PSScriptRoot. This variable always holds...
Getting Active Directory Account Information
In a previous script you have discovered how easy it is to find Active Directory accounts with just some simple PowerShell code. The result is a...
Finding AD User Accounts
There are modules and cmdlets to deal with Active Directory tasks, but sometimes it is easier and faster to simply use some .NET code instead. If...
Resetting PowerShell Host in ISE
Imagine you have worked long hours on a script in the ISE editor. While you worked on it, you probably have defined variables, created functions,...
Finding Cmdlets
Get-Command can be used to find cmdlets, but in PowerShell 3.0 it will often return many more cmdlets than expected. Due to module auto-loading,...
Pasting PowerShell Code from ISE Editor
The PowerShell ISE editor is great for copying and pasting code, for example to Microsoft Word and other text processors. Since ISE formats the...
Creating Calendars (and Lists of Dates)
Here's a code snippet that creates DateTime ranges. Just specify a year and a month, and the script produces a DateTime object for each day in...
What Is Going On Here?
Frequently, you will have PowerShell retrieve data, and then you pick parts of the information and use it in reports. Like here: $serial =...
Password Obfuscator Script
Ever had the need to store a password in a script? Ever needed to automate a credential dialog? First: storing passwords and other confidential...
Encoding a Love Letters (and Other Things) in Hex Strings
If your partner is as geeky as you, he or she may enjoy a private message in hex encoding. Everyone else may at least enjoy the technology used...
Checking Disk Partitions and Block Size
WMI is a treasure chest full of information. This line will read local partitions along with their block sizes: Get-WmiObject -Class...
Converting Excel CSV to UTF8
When you export Microsoft Excel spreadsheets to CSV files, Excel by default saves CSV files in ANSI encoding. That's bad because special...
Finding All PowerShell Profile Scripts
Sometimes it can get confusing which startup scripts run when PowerShell starts. There can be plenty, and they may be different, depending on...
Creating Objects with CSV
There are many ways to create custom objects. Here's a creative solution that can be useful in many scenarios: create a text-based...
Finding Scripts by Keyword
With an increasing number of PowerShell scripts on your hard drive, it can become hard to find the script you are looking for. Here's a helper...
Setting Monitor Brightness
If your display driver supports WMI, then you can change the display brightness using PowerShell - event on remote machines! Here's the...
Check Monitor Brightness
If you want to check your current display brightness (preferably on notebooks, of course), here's a quick function: function...
Creating Symbolic Links
Symbolic links work very similar to "regular" link files (*.lnk): they can point to virtually any file or folder and even UNC paths....