re: Use PowerShell to Find the Top Values Returned by WMI

Ed Wilson — Wed, 19 Oct 2011 11:20:14 GMT

@Klaus Schulte you are right, and this has been a common request to the WMI team for many years. As for joining different WMI classes, WMI already exposes the ability to perform associative Queries and it has a great deal associative WMI classes. I have a technique, using Windows PowerShell, that makes this highly complex process extremely easy. I will blog about it on Hey Scripting Guy! in the very near future.

re: Use PowerShell to Find the Top Values Returned by WMI

Klaus Schulte — Wed, 19 Oct 2011 09:28:42 GMT

Hi Ed,

WMI and Powershell are already a good team!

But I think, that the way WMI data are retrieved or updated could be further impoved!

WQL is a good way to retrieve information but I'd like to have more options with it ( more like SQL )

because of the way information has to be filtered and transmitted through the network where

"less is more"! Less Traffic between the data source and the consumer and more sophisticated filtering,

grouping and aggregating on the source site!

Another great deal would be the ability of joining WMI objects in queries that sample data from different

WMI classes, so that only one query has to be issued on a set of WMI classes instead of n queries targeting

n different WMI classes where we have to extract the desired properties from the union of n resultsets.

If we only could do the sort ( order by ), group ( by ) and first/last-n operations on the server = source site

the overall roundtrip time should significantly decrease.

I would even appreciate the advent of WLinq = Microsoft Linq for WMI

( as much as I would like to have PSLinq :-)

Klaus.