How to detect memory changes???

All Replies

• Thursday, July 02, 2009 4:32 PMSherry KissingerMVP

   
  

  1

  Sign In to Vote
  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.

  • Proposed As Answer byYvette OMeallyMSFT, OwnerMonday, July 06, 2009 9:00 PM
  • Marked As Answer byMatthew Hudson [MVP]MVP, ModeratorThursday, July 16, 2009 2:41 AM
  •  
  • Reply
  • Quote

   
• Friday, July 03, 2009 3:51 AMchungb

   
  

  0

  Sign In to Vote
  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
  • Reply
  • Quote

   
• Friday, July 03, 2009 8:36 AMTorsten [MVP]MVP

   
  

  0

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

  • Proposed As Answer byYvette OMeallyMSFT, OwnerMonday, July 06, 2009 9:00 PM
  • Marked As Answer byMatthew Hudson [MVP]MVP, ModeratorThursday, July 16, 2009 2:41 AM
  •  
  • Reply
  • Quote

   
• Thursday, August 20, 2009 9:56 AMchungb

   
  

  0

  Sign In to Vote
  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  
  
  
  • Reply
  • Quote

   
• Thursday, August 20, 2009 8:51 PMSherry KissingerMVP

   
  

  0

  Sign In to Vote
  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.
  • Reply
  • Quote

   
• Thursday, September 03, 2009 8:56 AMchungb

   
  

  0

  Sign In to Vote
  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
  
  • Reply
  • Quote