database-tools

You should use this approach if you need to change the creation time of a folder or file after you have created it: Get-Childitem c:\testfolder |...

If you would like to make error messages more readable, you can change their background color from black to white:...

How do you exclude objects based on empty properties? For example, WMI returns all kinds of "network adapters:" Get-WMIObject...

You can also use this little helper function if you run scripts every day and want to make sure they don't do anything on weekends: function...

When you pipe the result of a command to Get-Member, it examines the returned objects and shows the properties and methods. Use this line if you...

Strings contain all the methods you may need to access its content or manipulate it otherwise. Here is how you can list those methods: "Hello" |...

While Stop-Process will stop a process immediately in PowerShell, it will also destroy all data that hasn't yet been saved. You can try a more...

ConvertTo-HTML is a great way of creating system reports because you can combine information gathered from different sources into one report. The...

ConvertTo-HTML will convert text information into simple HTML, which can then be saved to disk. These reports will work fine, even though they are...

You will discover that Out-Printer can print results to your default printer. You can also print to any other printer when you specify its name:...

When you output results to text files, you will find that the same width restrictions apply that are active when you output into the console. You...

If you need to see all properties a result object provides, you should probably add Select-Object * to it like this: Get-Process -Id $pid |...

If you need to display a lot of information in as little room as possible, you should use Format-List with -Column: Get-Service | Format-Wide...

Format-Table has a parameter called -GroupBy which creates groups based on the property you supply. For example, you can use this to examine aliases...

You should use WMI to list all IPv4 addresses assigned to a computer: Get-WMIObject win32_NetworkAdapterConfiguration | Where-Object { $_.IPEnabled...

You'll discover that some native commands require interactive keystrokes before they work. For example, to format a drive, for security reasons you...

Whenever Windows installs an update via Windows Update, it will log this in its windowsupdate.log file. PowerShell can then parse this file. You...

If you've ever wanted to know all IP addresses assigned to a machine, you should use WMI: Get-WMIObject win32_NetworkAdapterConfiguration |...

Select-Object will select the object properties that you want to see. So it removes all properties you did not specify, but it always returns an...

PowerShell can easily provide a range of numbers, but creating them is not that easy - unless you convert ascii codes into characters: 65..90 |...

When you query the values of a registry key, PowerShell will add a bunch of artifacts to the results. You'll get some new properties that all...

Have a look at this line – do you see what's wrong with it? Get-WMIObject Win32_UserAccount | Where-Object { $_.Name = 'Guest' } PowerShell will use...

You can use a keyword search with WMI to find a specific service. The next line will get you all services with the keyword "cert" in its...

If you'd like to speed up things, you should try to filter server side instead of client side whenever you query information. For example, this...