Starting with PowerShell 5, cmdlets like Extract-Archive can extract the content of ZIP files to disk. However, you can always extract only the...
ps1
Categories
- Free tools
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- 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
Running CMD commands in PowerShell
PowerShell by default does not support the native cmd.exe command such as „dir“. Instead, it uses historic aliases called “dir” to point you to the...
Progress Bar Timer
Use the PowerShell progress Bar Here is a simple example using the PowerShell progress bar. The code displays a progress bar counting down a break....
Understanding Script Block Logging (Part 1)
Beginning with PowerShell 5, the PowerShell engine starts to log executed commands and scripts. By default, only commands considered potentially...
Reading Event Logs Smart (Part 1)
When you query an event log with PowerShell, by default you get back a text message with the logged information. For example, if you’d like to know...
Turning Display Off Immediately
If you are about to launch a lengthy automation script, why not turn off the display right away instead of waiting for the screen saver timeout to...
Purging Kerberos Tickets for All Accounts
In the previous tip we covered klist.exe and how it can be used to purge all Kerberos tickets for the current user so that new permissions will take...
Purging Kerberos Tickets for the Current User
No need to reboot a system just to apply new permission settings. Instead, purge your Kerberos tickets so that you will get a new ticket based on...
Using Chocolatey with PowerShell
Chocolatey is a free package manager for Windows that can be used to download and install software. Installing Chocolatey via PowerShell Before you...
Positioning the PowerShell Console Cursor
Enabling VT Escape Sequences in PowerShell 5.1 Starting in PowerShell 5.1, the PowerShell console supports VT escape sequences that can be used to...
Sort IPv4 and IPv6 Addresses Correctly
When you try and sort IPv4 addresses via Sort-Object, this fails: PS> '10.1.2.3', '2.3.4.5', '1.2.3.4' | Sort-Object 1.2.3.4 10.1.2.3 2.3.4.5...
Sort IPv4 Addresses Correctly
Reviewing the Test-OnlineFast Function In the previous tip we published a super-fast function called Test-OnlineFast, and this function was able to...
Final Super-Fast Ping Command
Revisiting the Test-Online Fast Function In the previous tip series, we developed a new function called Test-OnlineFast that can ping multiple...
Finding Registered Event Log Source Names
Understanding Event Log Source Names When you write events to an event log using Write-EventLog, you must specify a valid source name. However,...
Select-Object and -ExcludeProperty
Here is a line of code that often puzzles PowerShell users: Get-Service | Select-Object -ExcludeProperty Name Understanding the -ExcludeProperty...
Converting PowerShell to Batch
Here is a fun PowerShell function called Convert-PowerShellToBatch. Provide it with the path to a PowerShell script, or pipe in the results from...
Converting User Name to SID
If you’d need to find out the SID for a user name, here is a useful chunk of code that does the job: $domain =…
Displaying Data in a Grid View Window Vertically
Out-GridView always produces a table with one object per line: Get-Process -Id $pid | Out-GridView Occasionally, it would be more helpful to display the object…
Finding All Domain Controllers (no module required)
Reviewing the ActiveDirectory Module Approach In the previous tip we explained how you can use the ActiveDirectory module and its cmdlets to find...
Getting Cached Credentials
Managing Cached Credentials with PSCredentialManager In the previous tip we talked about a public module called PSCredentialManager that helps you...
Installing Modules in PowerShell Core on Linux
Installing PowerShell Modules with Administrator Privileges When you’d like to install modules for all users from the PowerShellGet repository, you...
Parsing Distinguished Names
Using Split() for Parsing Distinguished Names Distinguished names are strings, and strings contain powerful ways of parsing data. The most powerful...
Registering Default PowerShell Repository
Using PowerShellGet to Install Scripts and Modules If you use the PowerShellGet module (which ships by default on Windows 10 and Server 2016), you...
Running PowerShell Script as a Scheduled Task
Scheduling PowerShell Scripts for Automatic Execution If you need to run a PowerShell script in regular intervals, why not run it as a scheduled...
Creating Random MAC Addresses
Randomly Generated MAC addresses If you just need a bunch of randomly generated MAC addresses, and you don’t care much about whether these addresses...
Converting Binary String to Integer
Convert a binary text string into integer Here is how you convert a binary text string into the corresponding integer value: $binary = "110110110"...
Turning AD User into a Hash Table
Sometimes it could be useful to load all attributes from a given AD user into a hash table. This way, you could edit them, and then use Set-ADUser...
Exporting ActiveDirectory Module
To manage users and computers in your Active Directory from PowerShell, you need the ActiveDirectory module which comes as part of the free RSAT...
Determine if Array Contains Value – Using Wildcards
Checking for an Element in an Array Using PowerShell If you’d like to know whether an array contains a given element, PowerShell provides the...
Working with LDAP and Dates
LDAP filters LDAP filters are a fast and powerful way of retrieving information from Active Directory. However, LDAP filters use a very low-level...