database-tools

Finding Installed Updates (Part 1)

Get-Hotfix returns installed hotfixes but really only is a wrapper around the Win32_QuickFixEngineering WMI class. It is not returning all installed...

Finding Missing Updates

PowerShell can access the same logic that is used by the Windows Update Client, and query for missing updates: $UpdateSession = New-Object...

Who is Starting Hidden Programs?

Ever wondered why your CPU load is so high at times, or why black windows open up for a split second? Then check your event log for program...

Finding Logon Events

Provided you have Administrator privileges, here is a quick and easy way of dumping all login events. This way you can find out who logged in to a...

Resolving URLs

Often, URLs redirect to the final URL, so if you’d like to know where a given URL really points to, use a function like this: function...

Finding Size of Download

When you download files from the internet and use PowerShell, you may want to find out how long the download will take. While you can check the size...

Detecting Key Press

Sometimes it would be nice if a script was able to detect a key press without interfering with the script and its inputs. This way, you could add...

Using FileSystemWatcher Asynchronously

In the previous tip we looked at the FileSystemWatcher object and how it can monitor folders for changes. To not miss any changes, however, an...

Using FileSystemWatcher Synchronously

Here is a chunk of code illustrating how PowerShell can use the FileSystemWatcher to synchronously watch a folder including subfolders for file...

Using Default Credentials for Proxy

When your company uses an authenticated proxy, PowerShell may not always be able to contact the Internet. You may have to instruct the web proxy to...

PowerShell 7

Today we are not talking about code but about PowerShell in general. Microsoft has announced that the next release of PowerShell is called...

RSAT Tools Built-In

The Remote Server Administration Tools (RSAT) used to be an external download that added two important PowerShell modules: ActiveDirectory and...

Searching Files Using Index Search

Windows Indexing indexes most files in your user profile and drives the fast file search in File Explorer. PowerShell can access the same mechanism....

Turn on Streaming for Loops

PowerShell comes with a number of looping constructs. These looping constructs cannot stream, so you cannot pipe the results to other cmdlets and...

Specifying Bit Flags Smart

In the previous tip you have seen how you can enable all SSL security protocols in PowerShell to connect to web services and web sites:...

Using SSL/HTTPS from PowerShell

Depending on your PowerShell and .NET Framework version and update, the default security protocol for secure web connections may still be SSL3. You...

Splitting Texts by Fixed Width

Let’s assume you need to split a text using a fixed width. For example, if you needed the first 5 character of a text, plus the remainder, how...

Get Hashes from Texts

Before the advent of PowerShell 5 (and Get-FileHash), to calculate hashes for strings and files, you’d need to resort to pure .NET methods....

1 41 42 43 44 45 159