SCCM report for Domain Controllers with RAM,Operating System,IP Address etc.
Full Details : http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/0dedf567-7bbd-4c36-bc7a-12c409a79618
SELECT
sys.Name0 AS 'System Name',
os.Caption0 AS 'Operating System',
os.CSDVersion0 AS 'Service Pack',
PM.TotalPhysicalMemory0 /1024 as 'RAM in MB',
OS.InstallDate0 AS 'Original OS Install Date',
os.LastBootUpTime0 AS 'Last Boot Time',
NAC.IPAddress0 AS 'IP Address',
NAC.IPSubnet0 AS 'Subnet Mask'
FROM
dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC
INNER JOIN dbo.v_GS_OPERATING_SYSTEM OS ON NAC.ResourceID = OS.ResourceID
INNER JOIN dbo.v_GS_PC_BIOS BIOS ON NAC.ResourceID = BIOS.ResourceID
INNER JOIN dbo.v_GS_SYSTEM sys ON NAC.ResourceID = sys.ResourceID
INNER JOIN dbo.v_GS_COMPUTER_SYSTEM CS on NAC.ResourceID = CS.ResourceID
INNER JOIN dbo.v_GS_X86_PC_MEMORY PM on NAC.ResourceID = PM.ResourceID
Where
NAC.IPaddress0 is Not Null
and CS.Roles0 like '%Domain_Controller%'
Note : Blog converts the quotes to fancy, Please replace them.