SELECT  distinct SYS.resourceid,sys.Netbios_Name0,SYS.User_Domain0, SYS.User_Name0, IP.IP_Addresses0,ASSG.SMS_Installed_Sites0,OS.Caption0,OS.CSDVersion0, PR.Model0,pr.manufacturer0,bi.name0,bi.serialnumber0,me.totalphysicalmemory0,Ne.name0,na.dhcpServer0,disk.model0,disk.Interfacetype0,disk.size0,mo.monitortype0
FROM v_R_System  as SYS
JOIN v_RA_System_SMSInstalledSites as ASSG
on SYS.ResourceID=ASSG.ResourceID
JOIN v_RA_System_IPAddresses as IP
on SYS.ResourceID=IP.ResourceID
JOIN v_gs_operating_system as OS
on SYS.ResourceID=OS.ResourceID
JOIN v_GS_COMPUTER_SYSTEM as PR
on SYS.ResourceID=PR.ResourceID
JOIN v_GS_PC_Bios as BI
on SYS.ResourceID=bi.ResourceID 
JOIN v_gs_X86_pc_memory as Me
on SYS.ResourceID=Me.ResourceID
JOIN v_gs_network_adapter as Ne
on SYS.ResourceID=Ne.ResourceID  
JOIN v_gs_AMT_Agent as amt
on SYS.ResourceID=amt.ResourceID
JOIN v_gs_disk as disk
on SYS.ResourceID=disk.ResourceID
JOIN v_gs_network_adapter_configur as na
on SYS.ResourceID=na.ResourceID
JOIN v_gs_desktop_monitor as mo
on SYS.ResourceID=mo.ResourceID           

WHERE  ne.adaptertype0 like ‘Ethern%’
Order by SYS.resourceid

fuente Gaston Gardonio – http://blogs.technet.com/plataformas/archive/tags/System+Center/default.aspx