How to creat Memory Query

[billybarty]

I am needing to creat a query to see what the memory is on our systems. Can someone point me to any info on how to creat a query or see similar queries to view?

 

[billybarty]

Here is what I have tried and when I run the query nothing happens. Can someone tell me where I went wrong?
While in the SMS Console open up the query tree, right click on Queries, select New Query. Entered a name System Memory <128 in the text box. Select Edit Query Statement. On the General Tab select the star symbol, then hit the select button. Set the Attribute Class to Memory (memory details)and Attribute to Total Physical Memory. Select OK. On the general tab select ascending for the sort order then OK. From here select the Criteria Tab. Next select the star symbol to create a criteria. Hit the select button on the General tab, set the Attribute Class to Memory and the Attribute to Physical Memory, then hit OK. Set the Operator to &quot;is less than&quot; and the value to 128.

 

[mharcourt]

Change the 128 to 128000 assuming your looking for systems with less then 128 MB. Also, you may want to add the computer Name and other information to help identify the system.