database-tools

WMI not only provides rich information, it also supplies methods that you can call to take action. In the next example, you can forcefully shut down...

WMI provides a wealth of information as long as you know the name of the WMI class that represents the entity you are seeking. Fortunately,...

WMI is a fantastic source of information! Best of all, it works locally as well as remotely. For example, the next line gives you details about your...

As you have discovered in a previous tip, reading Eventlog entries is fairly simple using WMI and Win32_NTLogEvent: Get-WmiObject Win32_NTLogEvent...

Event logs are a great source of information. The only problem is that they tend to be overwhelming. Try using WMI and the Win32_NTLogEvent class to...

Reading text files is easy using the Get-Content cmdlet: $text = Get-Content $env:windirwindowsupdate.log However, Get-Content reads the file line...

To convert the ASCII value to a character, use type casting like this: [char]65 To do the opposite and convert a character to its ascii value, use...

Get-Acl is a convenient Cmdlet to expose NTFS file and folder settings. For example, to get a list of ownerships for a folder content, do this: Dir...

You need to sort a text file, maybe a list of servers or names? Here is how: $file = $homeserverlist.txtGet-Content $file | Sort-Object |...

Windows Media Player can be accessed using COM, and WMP in turn gives you access to your entire media. Using GetByName(), you can directly access...

Windows Media Player (WMP) gives you access to all of your media stored on your computer. PowerShell can access this information through COM using...

Often, in your document folders a lot of files exist, and most of the time they are not really organized. With the help of a little PowerShell...

By using the -passThru parameter, you can tell Compare-Object to return the actual objects you compared. Let's say you are looking for new...

Whenever you'd like to compare long-time results or compare data on different machines, you want to use persisted result sets. Persisted result...

Compare-Object can help you monitor folder content and find changes. To monitor, first create an initial snapshot. At a later time, you can then...

PowerShell makes it easy to compare results and find only things that changed. For example, you may want to list only processes that started after a...

If you'd like to find Users in your Active Directory and bulk-change certain properties, you may not need 3rd party extensions. Here is an...

If you ever wanted to find out which folder in your profile consumes the most space (or want to check user profiles to make sure people do not...

Arrays are by default read/write so you cannot lock down arrays and make them read-only. To create a read-only array, you can "upgrade" it...

Simple arrays have no built-in mechanism to insert new elements or extract elements at given positions. For example, to extract the 5. element from...

There is a clever trick in PowerShell to create numeric ranges that you probably know: 1..10 But did you know you can use variables with this trick?...

Ever wanted to create an electronic dice (or needed random numbers for other purposes)? With PowerShell, simply instantiate a Random object and call...

The easiest way to create an array of letters is to convert an array of numbers into an array of characters like this: $letters = [char[]](97..122)

Let's assume you have an array of items which you would like to sort. Here is the PowerShell way: $array = 1,5,32,5,7$array | Sort-Object$array...

URLs contain a lot of information which can be automatically parsed by PowerShell. Simply convert a URL to the System.URI type. Once you did this,...

HTML on web pages uses tags and other special characters to define the page. To make sure text is not misinterpreted as HTML tags, you may want to...

To check whether a string contains a valid host name, you can use the CheckHostName() method provided by the System.URI type. It will return...

To make sure user input is a valid URL, you can use the System.URI type. Try to convert the raw string into this type. If it works, the string is a...

To reverse the order of elements in an array, the most efficient way is to use the [Array] type and its static method Reverse(): # Create an array...