How to detect memory changes???

Thu, 02 Jul 2009 16:21:47 Z

Hi,

I know SCCM have one report name "Computer where physical memory has changes" , but it is not actually the report I like as i want to detect the changes on RAM; So can i know any query to detect the changes only apply for those changing RAM?

Regards,
Chungb

How to detect memory changes???

Thu, 02 Jul 2009 16:32:26 Z

Do you already have the custom mof edit for physical memory? http://myitforum.com/cs2/blogs/skissinger/archive/2008/09/01/physical-memory-and-memory-slots-hardware-inventory-extension.aspx

If so, it would be a similar report, comparing v_gs vs. the v_hs view.

Standardize. Simplify. Automate.

How to detect memory changes???

Fri, 03 Jul 2009 03:51:06 Z

Yes,

I have try to modify the sms-def.mof and see the result. But just want know after modify the mof file, do i need to do anything to make it gather the information from client computer and how long would it be?

Regards,
Chungb

How to detect memory changes???

Fri, 03 Jul 2009 08:36:37 Z

The client just has to download polices and perform a hardware inventory cycle after you modified the sms_def.mof on the siteserver.

How to detect memory changes???

Thu, 20 Aug 2009 09:56:03 Z

Hi,

I have change the mof file according to the link given by Sherry, it is working now. I have v_GS_Physical_Memory and v_HS_Physical_Memory table that capture the RAM information according to Slot, together with the query i get from internet as shown below

select distinct
v_R_System_Valid.ResourceID as [Resource ID],
v_R_System_Valid.Netbios_Name0 as [Computer Name],
v_GS_PHYSICAL_MEMORY.Capacity0 as [Current RAM(MB)],
v_GS_PHYSICAL_MEMORY.DeviceLocator0 as [Slot],
v_HS_PHYSICAL_MEMORY.Capacity0 as [Previous RAM(MB)],
v_HS_PHYSICAL_MEMORY.DeviceLocator0 as [Slot]
from
v_HS_PHYSICAL_MEMORY, v_GS_PHYSICAL_MEMORY, v_R_System_Valid
where
v_HS_Physical_Memory.ResourceID = v_R_System_Valid.ResourceID
and
v_GS_Physical_Memory.ResourceID = v_R_System_Valid.ResourceID
and
v_HS_Physical_Memory.ResourceID =v_GS_Physical_Memory.ResourceID
and
v_GS_PHYSICAL_MEMORY.DeviceLocator0 = v_HS_PHYSICAL_MEMORY.DeviceLocator0
and
v_GS_PHYSICAL_MEMORY.Capacity0 <> v_HS_PHYSICAL_MEMORY.Capacity0
and
v_HS_PHYSICAL_MEMORY.DeviceLocator0 != 'SYSTEM ROM'
and
v_GS_PHYSICAL_MEMORY.DeviceLocator0 != 'SYSTEM ROM'

This query is detect the changes based on slot (comparison between v_HS and v_GS), so far it still works. Question is when i take one RAM out from desktop, v_HS success capture the changes but my query can't display it out. Please advice, thanks in advanced. Thanks

Regards,
Chungb

How to detect memory changes???

Thu, 20 Aug 2009 20:51:40 Z

Completely a stab in the dark, but perhaps something along the lines of comparing Count of entries per computer in the v_gs vs. the v_hs views?

count(v_gs_physical_memory.Capacity0) <> count(v_hs_physical_memory.Capacity0) ?

Standardize. Simplify. Automate.

How to detect memory changes???

Thu, 03 Sep 2009 08:56:04 Z

Guys,

I got the solution on my issue (it is still under testing), i divide the task into 2 result, below is the query

select distinct m.ResourceID, p.Netbios_Name0, m.DeviceLocator0, m.Capacity0
from v_HS_Physical_Memory m, v_R_system_valid p , v_GS_Physical_Memory n
where not exists (select distinct d.ResourceID, d.DeviceLocator0, d.Capacity0 from
v_HS_Physical_Memory d, v_GS_Physical_Memory e where
d.ResourceID = e.ResourceID and
d.DeviceLocator0 = e.DeviceLocator0 and
d.Capacity0 != e.Capacity0 and
m.ResourceID = d.resourceID and
m.DeviceLocator0 = d.DeviceLocator0) and
not exists (select distinct k.ResourceID, k.DeviceLocator0, k.Capacity0 from
v_HS_Physical_Memory k, v_GS_Physical_Memory l where
k.ResourceID = l.ResourceID and
k.DeviceLocator0 = l.DeviceLocator0 and
k.Capacity0 = l.Capacity0 and
m.ResourceID = k.resourceID and
m.DeviceLocator0 = k.DeviceLocator0)and
m.ResourceID = p.ResourceID
and
m.DeviceLocator0 != 'SYSTEM ROM';

select distinct d.ResourceID as f1, d.DeviceLocator0 as f3, d.Capacity0 as f4, e.capacity0 as f5 from
v_HS_Physical_Memory d, v_GS_Physical_Memory e where
d.ResourceID = e.ResourceID and
d.DeviceLocator0 = e.DeviceLocator0 and
d.Capacity0 != e.Capacity0;

So the first query check on the missing RAM and the second query detect the changes on RAM

Regards,
Chungb