There was a report that I used to use in SMS2003 that I found here: http://www.myitforum.com/forums/m_129180/tm.htm
that used to allow me to pull the memory info for machines in my environment.
I'm at a new company now and we're testing SCCM2007. I tried creating the same report in SCCM, and it goes through fine, but when I run the report, I get the following error:
An error occurred when the report was run. The details are as follows:
Invalid object name 'v_GS__Physical_Memory0'.
Error Number: -2147217865
Source: Microsoft OLE DB Provider for SQL Server
Native Error: 208
Lo and behold, I look through the available views, and I don't see it in there. Is there a substitute that I can use for this view in SCCM?