WMI Filter - Computer Host Name Begins With XXX

[FN-GM]

Hello,

 

I am wondering if anyone has a working WMI filter that queries what the computer hostname begins with please?

 

For example if the computer hostname is Room-PC01 I would like a filter that picks up Room-PC*

 

Many Thanks

[DJ-1701]

Namespace: root\CIMv2
Query: Select * FROM Win32_ComputerSystem WHERE Name LIKE "Room-PC%"

 

You can also do multiple name types like this...

 

Select * FROM Win32_ComputerSystem WHERE ((Name LIKE "Room-PC%") OR (Name LIKE "Room-Laptop%"))

[FN-GM]

Thanks. How would I adopt it so it only applies if it doesn't begin with that room number please? Is it the below please?

 

Select * FROM Win32_ComputerSystem WHERE Name NOT LIKE "Room-PC%"

[DJ-1701]

Thanks. How would I adopt it so it only applies if it doesn't begin with that room number please? Is it the below please?

 

Select * FROM Win32_ComputerSystem WHERE Name NOT LIKE "Room-PC%"

 

Close

 

Select * FROM Win32_ComputerSystem WHERE NOT Name LIKE "Room-PC%"

[Arthur]

Also, if you want the query to execute faster change the * to Name...

 

Select [color="#FF0000"]Name[/color] FROM Win32_ComputerSystem WHERE NOT Name LIKE "Room-PC%"

[FN-GM]

Am I being thick here - This WMI doesn't seem to work?

 

Any suggestions please?

 

Thanks

 

Select Name FROM Win32_ComputerSystem WHERE ((Name LIKE "WA-%") OR (Name LIKE "SA-%") OR (Name LIKE "KA-%"))

[Arthur]

Select Name FROM Win32_ComputerSystem WHERE ((Name LIKE "WA-%") OR (Name LIKE "SA-%") OR (Name LIKE "KA-%"))

Does the following query work for you?

 

Select Name FROM Win32_ComputerSystem WHERE Name LIKE "WA-%" OR Name LIKE "SA-%" OR Name LIKE "KA-%"

[FN-GM]

Is there a quick way to validate it without tampering with the group policy please?

[Arthur]

Is there a quick way to validate it without tampering with the group policy please?

Try this PowerShell...

 

Get-WmiObject -Query 'Select Name FROM Win32_ComputerSystem WHERE Name LIKE "WA-%" OR Name LIKE "SA-%" OR Name LIKE "KA-%"'