myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


Why the history on X86_PC_Memory does not gather?

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Why the history on X86_PC_Memory does not gather? Page: [1]
Login
Message << Older Topic   Newer Topic >>
Why the history on X86_PC_Memory does not gather? - 7/31/2008 2:56:56 AM   
pazdak

 

Posts: 35
Score: 0
Joined: 6/20/2007
Status: offline 		I have SCCM 2007 RTM with SQL 2005 sp2

By some machines it was added RAM.
There was a necessity to give the report, where and as changed RAM on clients.
I found following scripts from smsug.ca
quote:

select
CS.Name0,
CS.UserName0,
RAM.TotalPhysicalMemory0,
RAM.TimeStamp,
HRAM.TotalPhysicalMemory0,
Max(HRAM.TimeStamp)
from
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_GS_X86_PC_MEMORY RAM,
dbo.v_HS_X86_PC_MEMORY HRAM
Where CS.ResourceID = RAM.ResourceID
and CS.ResourceID = HRAM.ResourceID
and RAM.TotalPhysicalMemory0 != HRAM.TotalPhysicalMemory0
Group by
CS.Name0,
CS.UserName0,
RAM.TotalPhysicalMemory0,
RAM.TimeStamp,
HRAM.TotalPhysicalMemory0

But as it has appeared histories on RAM is not present. Why?I check v_HS_X86_PC_MEMORY and PC_MEMORY_HIST - and they emptyData in v_GS_X86_PC_MEMORY and PC_MEMORY_DATA - actual 
Why the history does not save? 
Post #: 1
RE: Why the history on X86_PC_Memory does not gather? - 7/31/2008 8:57:37 AM   
gjones


Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline 		Does the existing data show the new RAM amount or the old amount? If it is the old amount force the hardware inventory agent to run, confirm that the inventory data is updated within the db, then try the query again.

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx


(in reply to pazdak)
Post #: 2
RE: Why the history on X86_PC_Memory does not gather? - 7/31/2008 10:44:50 AM   
jnelson993


Posts: 900
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		If I understand you correctly, you're saying that v_GS_X86_PC_MEMORY and PC_MEMORY_DATA are empty?

If this is true, then either inventory isn't working at all or someone has turned off the inventorying of those classes in the SMS_DEF.MOF.   Look at the mof in <smsfolder>\inboxes\clifiles.src\hinv and make sure you have CCM_LogicalMemoryConfiguration reporting set to TRUE.  Then perform a MOFCOMP on all the clients and it'll start showing up.

//==================================CCM_LogicalMemoryConfiguration

//  Add CCM_LogicalMemoryConfiguration since Win32_LogicalMemoryConfiguration has been deprecated

   [SMS_Report(TRUE),SMS_Group_Name("Memory"), SMS_Class_ID("MICROSOFT|X86_PC_MEMORY|1.0")]
   class CCM_LogicalMemoryConfiguration : SMS_Class_Template
   {
   [SMS_Report(TRUE)]    uint64   AvailableVirtualMemory;
   [SMS_Report(TRUE),key]    string   Name;
   [SMS_Report(TRUE)]    uint64   TotalPageFileSpace;
   [SMS_Report(TRUE)]    uint64   TotalPhysicalMemory;
   [SMS_Report(TRUE)]    uint64   TotalVirtualMemory;
   };


_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to pazdak)
Post #: 3
RE: Why the history on X86_PC_Memory does not gather? - 8/1/2008 8:53:22 AM   
pazdak

 

Posts: 35
Score: 0
Joined: 6/20/2007
Status: offline
quote:

ORIGINAL: jnelson993

If I understand you correctly, you're saying that v_GS_X86_PC_MEMORY and PC_MEMORY_DATA are empty?

No. I say that v_HS_X86_PC_MEMORY and PC_MEMORY_HIST are empty!
Existing data show new RAM amount (v_GS_X86_PC_MEMORY and PC_MEMORY_DATA)

The question sounded as:Why the history does not save in database? 

(in reply to jnelson993)
Post #: 4
RE: Why the history on X86_PC_Memory does not gather? - 8/4/2008 2:38:21 AM   
pazdak

 

Posts: 35
Score: 0
Joined: 6/20/2007
Status: offline 		In the table PC_MEMORY_DATA correct date in field TimeKey is specified,old result is not transferred to the table PC_MEMORY_HIST (Data are lost) Help me, please.

(in reply to pazdak)
Post #: 5
RE: Why the history on X86_PC_Memory does not gather? - 8/4/2008 10:10:43 AM   
jnelson993


Posts: 900
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		I'd contact MS.  Unless you have your maintenance tasks set to remove data after 1 day, there should be something there.

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to pazdak)
Post #: 6
RE: Why the history on X86_PC_Memory does not gather? - 8/5/2008 1:44:14 AM   
pazdak

 

Posts: 35
Score: 0
Joined: 6/20/2007
Status: offline 		jnelson993
I have task enable with "Delete data older then = 90 days"

The history on other data is present (e.g. for "Logical Disk")

(in reply to jnelson993)
Post #: 7
Page:   [1]
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Why the history on X86_PC_Memory does not gather? Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.281