SCCM Reporting request

Hello All,
I need to query SCCM 2007 SQL Database and need to get a report extracted with following columns in it
 
Machine Name, Serial Number, Manufacturer,  Model, System Type, Number of logical processor, Speed,  No of cores, Memory, Bios Date, Last Hardware Scan, Last user Logged in

Thanks in Advance
 

Here's something that I had that might get you on the right track.  It may not have all the fields, but maybe you can find the others  Check out the resource explorer for the addtitional information you need.
 
SELECT DISTINCT
   SYS.Netbios_Name0,
   Client0, 
   ProcAddtl.NumberOfCores0 as [Number of Cores],
   TotalPhysicalMemory0,
   Model0,
   NumberOfProcessors0,
   SystemType0, 
   ProcAddtl.NumberOfLogicalProcessors0 as [Number of Logical Processors]
  FROM v_R_System SYS
   left JOIN v_GS_PROCESSOR Processor on SYS.ResourceID=Processor.ResourceID
   left join v_gs_Processor_Addtl0 as ProcAddtl on Processor.ResourceID = ProcAddtl.ResourceID
   left join v_GS_X86_PC_MEMORY on SYS.ResourceID=v_GS_X86_PC_MEMORY.ResourceID
   left join v_GS_COMPUTER_SYSTEM on v_GS_COMPUTER_SYSTEM.ResourceID = SYS.ResourceId 
   order by SYS.Netbios_Name0
 
Rick Hanson

I tried running the report in the SCCM Query analyser, but got the following error message
 
Invalid Object Name v_gs_Processor_Addtl0

It is a Custom MOF edit.. Which collection the number of logical CPUs.

www.Enhansoft.com

Blog:
http://smsug.ca/blogs/garth_jones/default.aspx

But in our case we are trying to get this extracted by querying the SQL DB

Well you are not going to get the logical number of CPUs without the mof edit. so...

www.Enhansoft.com

Blog:
http://smsug.ca/blogs/garth_jones/default.aspx