Wednesday, May 1, 2013

SCCM report for Domain controller



Recently I have queried for a SCCM report for Server Configuration for domain controller ,
User wants to find the all details in one report like, Server Name, Bios Name, Serial Number, Model, Manufacturer, Ram Size, and Drive later and How many drives server have,

here is SQL query to find out the complete report


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%'


No comments:

Post a Comment