SCCM report Domain Controllers with IP Address

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.

Leave a Reply