Re: Queries and memory types.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hello David,

The Win32_PhysicalMemory class should be able to help you out here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/win32_physicalmemory.asp

Below is an example sms_def.mof edit that should get you the information you
need:

[SMS_Report (TRUE),SMS_Group_Name ("Physical Memory"),
SMS_Class_ID ("Microsoft|Physical_Memory|1.0") ]
class Win32_PhysicalMemory : SMS_Class_Template
{
[SMS_Report (TRUE)] string BankLabel;
[SMS_Report (TRUE), SMS_Units("Megabytes")] uint64 Capacity;
[SMS_Report (TRUE)] string Caption;
[SMS_Report (TRUE)] string DeviceLocator[];
[SMS_Report (TRUE)] uint16 FormFactor;
[SMS_Report (TRUE)] string Manufacturer;
[SMS_Report (TRUE)] uint16 MemoryType;
[SMS_Report (TRUE)] uint32 PositionInRow;
[SMS_Report (TRUE)] uint32 Speed;
[SMS_Report (TRUE),Key] string Tag;
[SMS_Report (TRUE),Key] string CreationClassName;
};

All of the available fields aren't listed here for reporting, you can add
whatever other fields you would like to from the link above which explains
them all. Just ensure that you leave the last two (Tag and
CreationClassName) and that you have them set as key fields for this class.
Because the physical memory data is stored in an array, without the key
fields you're going to have issues with your database tables!

Hope this helps,

Jeff Gilbert, MCSE
Technical Writer | Windows & Enterprise Management Division
Microsoft Corporation

This posting is provided "AS IS" with no warranties and confers no rights.

"David Buckley" <DavidBuckley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5183996F-F04B-4B28-9624-DE2A2932F7F0@xxxxxxxxxxxxxxxx
Management and their perogative to change their minds from one week to the
next now considerit a priority to know how much and what type of memory is
in
the machines on a cretain subnet.

Writing a query to return machine name, who logged on last, and how much
memory is in a machine is not a big drama and has already been done.

My question is this does anyone know if SMS collects information on the
type
of RAM installed in a machine. If it does not by default, then is it
possible
to extend SMS somehow to do so? Then of course if it is possible how do I
do
it?

In a previous lifetime in what seems to be another universe I vaguely
remeber modifying the SMS_DEF.MOF file to collect BIOS information, but
that
was under strict instructions from more experienced SMS gurus and was in
version 2.0. Is this the place I should be looking?

Thanks in advance for any help.

Kind regards,

David Buckley.
Infrastructure Team,
Information Systems Division,
XYZ Company. :)


.



Relevant Pages

  • Re: Queries and memory types.
    ... CreationClassName) and that you have them set as key fields for this class. ... Because the physical memory data is stored in an array, ... Technical Writer | Windows & Enterprise Management Division ... My question is this does anyone know if SMS collects information on the ...
    (microsoft.public.sms.admin)
  • Re: Setting SQL Server memory option for SMS 2003
    ... >What kind of environment is SMS 2003 and SQL installed ... >> recommends some memory tuning for SQL in your SMS 2003 ... The Memory tab on my SQL server has ...
    (microsoft.public.sms.setup)
  • RE: Memory Query
    ... Physical memory is not inventorized by sms by default. ... > area in the query builder to see if it's there but I don't recall ever seeing ...
    (microsoft.public.sms.inventory)
  • Re: Memory Query
    ... > Physical memory is not inventorized by sms by default. ... >> Hi Ali, ...
    (microsoft.public.sms.inventory)
  • Re: Not enough memory to complete operation
    ... above message it is NOT your Palm that is somehow running out of memory - ... my SMS application on the Palm Tx now gives the above error message when I ... I can still send SMS ...
    (comp.sys.palmtops)