Re: Inventory Memory Specs
- From: "sherrylkissinger@xxxxxxxxx" <sherrylkissinger@xxxxxxxxx>
- Date: Wed, 22 Aug 2007 19:50:57 -0700
No problem... this would be the report itself:
SELECT
SYS.Netbios_Name0,
MEM.BankLabel0,
mem.Capacity0,
MEM.Caption0,
MEM.DeviceLocator0,
CASE MEM.FormFactor0
WHEN 0 THEN 'unknown'
WHEN 1 THEN 'Other'
WHEN 2 THEN 'SIP'
WHEN 3 THEN 'DIP'
WHEN 4 THEN 'ZIP'
WHEN 5 THEN 'SOJ'
WHEN 6 THEN 'Proprietary'
WHEN 7 THEN 'SIMM'
WHEN 8 THEN 'DIMM'
WHEN 9 THEN 'TSOP'
WHEN 10 THEN 'PGA'
WHEN 11 THEN 'RIMM'
WHEN 12 THEN 'SODIMM'
WHEN 13 THEN 'SRIMM'
WHEN 14 THEN 'SMD'
WHEN 15 THEN 'SSMP'
WHEN 16 THEN 'QFP'
WHEN 17 THEN 'TQFP'
WHEN 18 THEN 'SOIC'
WHEN 19 THEN 'LCC'
WHEN 20 THEN 'PLCC'
WHEN 21 THEN 'BGA'
WHEN 22 THEN 'FPBGA'
WHEN 23 THEN 'LGA'
ELSE 'not defined'
END AS FormFactor,
CASE MEM.MemoryType0
WHEN 0 THEN 'Unknown'
WHEN 1 THEN 'Other'
WHEN 2 THEN 'DRAM'
WHEN 3 THEN 'Synchronus DRAM'
WHEN 4 THEN 'Cache DRAM'
WHEN 5 THEN 'EDO'
WHEN 6 THEN 'EDRAM'
WHEN 7 THEN 'VRAM'
WHEN 8 THEN 'SRAM'
WHEN 9 THEN 'RAM'
WHEN 10 THEN 'ROM'
WHEN 11 THEN 'Flash'
WHEN 12 THEN 'EEPROM'
WHEN 13 THEN 'FEPROM'
WHEN 14 THEN 'EPROM'
WHEN 15 THEN 'CDRAM'
WHEN 16 THEN '3DRAM'
WHEN 17 THEN 'SDRAM'
WHEN 18 THEN 'SGRAM'
WHEN 19 THEN 'RDRAM'
WHEN 20 THEN 'DDR'
ELSE 'not defined'
END AS MemoryType,
MEM.PositionInRow0,
MEM.Speed0,
MEM.Tag0
FROM v_R_System SYS
JOIN v_GS_Physical_Memory MEM ON SYS.ResourceID = MEM.ResourceID
join v_FullCollectionMembership fcm on fcm.resourceid=sys.resourceid
WHERE fcm.CollectionID=@CollID
And you'll need to have a prompt for CollID with an SQL query of:
begin
if (@__filterwildcard = '')
select CollectionID, Name from v_Collection order by Name
else
select CollectionID, Name from v_Collection
WHERE CollectionID like @__filterwildcard
order by Name
end
PS: Don't forget about the 10000 row limit by default for SMS
reports. I don't know how many clients you have, but if you might
have 5,000 workstations; if each one has 2 or more physical memory
modules, you'd exceed the 10,000 row limit.
On Aug 22, 9:58 am, Dan <dmor...@xxxxxxxxxxxxxxxxx> wrote:
K great thanks. I checked resource explorer and it is showing there for the
clients.
How do I create a report for physical memory of a collection of PCs? :)
"sherrylkissin...@xxxxxxxxx" wrote:
To check if your clients are reporting, you can look at a few things.
On a client, c:\windows\system32\ccm\logs\inventoryagent.log, and
search for "win32_physicalmemory". If found, that means that your
client knows it should report on the new class. Check the next line;
in that log. Did it say something like..."Win32_PhysicalMemory does
not exist out"? If so, you may need to save that snippet above as ...
well, anything... like Mem.mof. and on your clients run something
like mofcomp mem.mof (this is to tell your clients about this new
reporting class; you've told the server by editing sms_def.mof, but
now you need to tell you clients).
If you don't have that error in inventoryagent.log, then in the sms
console, All Systems, find that client, right-click, Resource
Explorer; and look for physical memory on the left.
If you do see it, then yes; you can now create new reports for
displaying that information.
If your clients are not even trying to report on win32_physicalmemory,
you may need to add this:
#pragma namespace ("\\\\.\\root\\cimv2\\sms")
just above the entire snippet from Jeff Gilbert.
On Aug 21, 10:56 am, Dan <dmor...@xxxxxxxxxxxxxxxxx> wrote:
I have added
[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)] string Model;
[SMS_Report (TRUE)] string Name;
[SMS_Report (TRUE)] string OtherIdentifyingInfo;
[SMS_Report (TRUE)] string PartNumber;
[SMS_Report (TRUE),Key] string Tag;
[SMS_Report (TRUE),Key] string CreationClassName;};
to the end of the SMS_def.mof files in the SMS\inboxes\clifiles.src\hinv
and ran mofcomp to check it and everything came back ok. I did this
yesterday and all clients ran inventory last night but I can't seem to see
any of the new data that shoudl have been inventoried. Do I have to write a
SQL Statement and create a new report in order to be able to report on this
data or does it automatically add new data to the reporting pages? How can i
check on the client to make sure they received and used the new mof file?- Hide quoted text -
- Show quoted text -
.
- Follow-Ups:
- Re: Inventory Memory Specs
- From: Dan
- Re: Inventory Memory Specs
- References:
- Re: Inventory Memory Specs
- From: sherrylkissinger@xxxxxxxxx
- Re: Inventory Memory Specs
- From: Dan
- Re: Inventory Memory Specs
- Prev by Date: RE: ITMU--Blocking access to Windows Update web site
- Next by Date: Re: Inventory Memory Specs
- Previous by thread: Re: Inventory Memory Specs
- Next by thread: Re: Inventory Memory Specs
- Index(es):
Relevant Pages
|
Loading
