Custom Search

---

---

Guy recommends:
Free network monitor

Solarwinds' free monitor makes it easy to check the performance and health of a router or firewall.

Download your free Network Device Monitor

---

---

Guy's Review of
Computer Utilities

 1) FreePing
 2) Engineer's Toolset
 3) Xobni
 4) PuTTY
 5) WMI Monitor
 6) BgInfo
 7) Net-SNMP
 8) IP Address Tracker
 9) DNS Stuff
10) WinDiff Compare

---

PowerShell -Filter Parameter

PowerShell -Filter Parameter

PowerShell's -filter is an alternative solution for sieving data to the | where-Object {$_.clause}.  Using -filter instead of 'where-Object' is a classic case of when you find a good technique, look for an even better modus operandi.

Topics for PowerShell Filters

• PowerShell Filter Files
• PowerShell Get-WmiObject Filter
• Logical Disk Filter
• PowerShell Select * from

 ♣

Preparation with PowerShell's Get-Help

Before we use PowerShell's -filter parameter, I suggest that we investigate the cmdlet with Get-Help.  For example, Get-Help Get-WmiObject.  My point is that we need to check that any particular cmdlet supports the -filter parameter.

Note 1: If you prefer to see examples, this is why I append -full.

Note 2:  Try other cmdlets such as Get-ChildItem (contains -filter)  or format-Table (no -filter parameter).

Example 1: PowerShell Filter Files

Here is a simple example to reduce the number of files displayed only those which are dlls.

Example 2: PowerShell Get-WmiObject Filter

PowerShell's -Filter uses the syntax of the WMI Query Language (WQL), which is a subset of SQL.  One point to clarify is that WQL uses 'traditional' operators such as "=", whereas PowerShell uses "-eq".

a) Preliminary: No Filter

Note 1:  The problem could be too many items, or a mixed bag results.  Suppose that we wanted to perform an operation on only some of the returned items?  The answer is to employ PowerShell and filter the output.

b) Same Command, but Filtered for IpEnabled Adapters

Note 1:   Remember the "Double Quotes" around your -Filter parameter.

Note 2:  = 'True', or ='False' is correct.  WQL does not understand PowerShell's -eq or -ne.

Note 3: -Filter is technically superior to methods such as 'Where' or 'Include' because it sifts the objects as it retrieves them.

c)  PowerShell Where Filter for Comparison

Note 1:  Where-Object achieves exactly the same result, but it needs an extra pipe (|).  My problem is remembering the $_. syntax.  I often forget the _ as in: $.IpEnabled.  PowerShell -filter output is shorter than the where-Object clause.

Guy Recommends: WMI Monitor and It's Free!

Windows Management Instrumentation (WMI) is one of the hidden treasures of Microsoft operating systems.  Fortunately, Solarwinds have created a Free WMI Monitor so that you can discover these gems of performance information, and thus improve your PowerShell scripts.  Take the guess work out of which WMI counters to use when scripting the operating system, Active Directory or Exchange Server.

Download your free copy of WMI Monitor

Example 3: Logical Disk Filter

Note 1: MediaType 12 for LogicalDisk means 'Fixed hard disk media'  as opposed to floppy.

Example 4: WMI Filter GPO

WMI Filters allow you to select only computers that meet your chosen criteria.  Naturally, your Group Policy will only apply to the objects that match your filter.  Here is a WMI GPO filter for Windows 7

Note 1:  The Keyword is Win32_OperatingSystem.

Note 2:  6.0% would be Vista.

See more on WMI GPO Filtering.

Summary of PowerShell -Filter

When you need to sift data you have a choice between a where-Object clause and a -Filter parameter.  The -Filter solution is easier and probably quicker. PowerShell's -Filter parameter looks for a WMI Query Language (WQL) statement.

See More Microsoft PowerShell WMI Examples:

• Home   • PowerShell Get-WmiObject   • PowerShell -Query   • PowerShell Select

• Win32_pingstatus   • WMI Win32_NetworkAdapter   • Win32_NetworkAdapterConfig

• Disable NIC   • PowerShell -Filter   • Windows PowerShell   • PowerShell 3.0 Network

Please email me if you have any example scripts. Also please report any factual mistakes, grammatical errors or broken links, I will be happy to correct the fault.

 *

Custom Search

Guy Recommends: WMI Monitor and It's Free! Windows Management Instrumentation (WMI) is one of the hidden treasures of Microsoft operating systems. Fortunately, Solarwinds have created the Free WMI Monitor so that you can actually see and understand these gems of performance information.  Take the guess work out of which WMI counters to use for applications like Microsoft Active Directory, SQL or Exchange Server. Download your free copy of WMI Monitor

Home Copyright © 1999-2012 Computer Performance LTD All rights reserved Please report a broken link, or an error.