Filter output (where-object) from variable

Question

I am running a test on servers with the following line:

Get-WmiObject Win32_Service -ComputerName "myserver" -Filter "State='Running'" |
where-object ??? }| Foreach-Object {
                New-Object -TypeName PSObject -Property @{
                    DisplayName=$_.DisplayName
                    State=$_.State
                } | Select-Object DisplayName,State
            # Export all info to CSV
            } | ft -AutoSize

I would like to create a variable like this:

$IgnoreServices = '"Wireless Configuration","Telephony","Secondary Logon"

and send this to Where-Object. Can I do this?

Sune:)

EDIT: After some R/T (research and trying:)) I found out that I can do this:

$IgnoreServices = {$_.DisplayName -ne "Wireless Configuration" 
-and $_.DisplayName -ne "Telephony" -and $_.DisplayName -ne "Secondary Logon" 
-and $_.DisplayName -ne "Windows Event Collector"}

Get-WmiObject Win32_Service -ComputerName "myserver" -Filter   "State='Running'"|        where-object $IgnoreServices | Foreach-Object {
                # Set new objects for info gathered with WMI
                New-Object -TypeName PSObject -Property @{
                    DisplayName=$_.DisplayName
                    State=$_.State
                } | Select-Object DisplayName,State
            # Export all info to CSV
            } | ft -AutoSize

But.. I would REALLY like if one could specify services to be excluded in the following manner: "service1","service2","service3"

As always, all help is greatly appreciated!!

Just a quick tip: you don't need the "select." The output of select-object is also a psobject and since you're selecting all of the source objects properties, it is a redundant operation. — x0n
– x0n, Commented Dec 31, 2011 at 17:53

manojlds · Accepted Answer · 2011-12-31 03:43:36Z

5

Yeah you can just do:

$IgnoreServices = "Wireless Configuration","Telephony","Secondary Logon"

like you wanted and do the following in the where-object:

where-object { $IgnoreServices -notcontains $_.DisplayName  }

answered Dec 31, 2011 at 3:43

manojlds

303k66 gold badges482 silver badges426 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sune Over a year ago

You ninja!! Works like a charm!! Thank you very much!!

Shay Levy · Accepted Answer · 2011-12-31 09:40:38Z

2

You can do that with a WMI filter (runs faster), and since you only select properties there's no need to create new objects, use the Select-Object cmdlet instaed:

$filter = "State='Running' AND Name <> 'Wireless Configuration' AND Name <> 'Telephony' AND Name <> 'Secondary Logon'"

Get-WmiObject Win32_Service -ComputerName myserver -Filter $filter | Select-Object DisplayName,State

answered Dec 31, 2011 at 9:40

Shay Levy

128k34 gold badges193 silver badges210 bronze badges

5 Comments

Sune Over a year ago

Thank you Shay and @manojlds ! I'll remove new object (I use that in another get-wmi and didn't know I didn't need it.) My list of "blacklisted" services turned out be quite extensive.. How would I go about reading the list from a textfile?

Shay Levy Over a year ago

This will build the filter dynamically assuming you have a text file with a service name on each line: $svc = Get-Content .\svc.txt | Foreach-Object { "AND Name <> '{0}'" -f $_}; $filter = "State='Running' " + ($svc -join ' ')

Sune Over a year ago

How would I use this in my get-wmi query? I've tried directly and by calling it with -filter $svc to no avail..

Sune Over a year ago

Nevermind, I just had a brainfart. Works excellent!! Thank you very much!

Andy Arismendi Over a year ago

This approach will perform better since the filter is being performed during the initial WMI query and Powershell doesn't have to compare the DisplayName of every object returned from the query against the list of ignored services. The performance improvement is negligible when querying just one computer but can be come noticeable when scaling up. Using measure-command in my test showed the WMI filter approach is 27% faster. The filtered WMI query took 255 milliseconds while the where-object method took 348.

Collectives™ on Stack Overflow

Filter output (where-object) from variable

2 Answers 2

1 Comment

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related