Close Menu
    Facebook X (Twitter) Instagram
    Sunday, May 18
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»SCCM report Domain Controllers with IP Address

    SCCM report Domain Controllers with IP Address

    Eswar KonetiBy Eswar KonetiDecember 05, 7:35 am1 Min Read SCCM 2007 2,975 Views
    Share
    Facebook Twitter LinkedIn Reddit

    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.

    CM07 DC Domain Controller report Domain_Controller Opeating system Report with RAM SCCM 2007 sccm report SCCM report for Domain controllers SCCM report IP Address Total Physical Memory
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Monitoring Endpoint Security Applications with SCCM ConfigMgr SQL

    October 11, 8:48 pm

    SCCM report list collections with no deployments

    December 05, 12:04 pm

    How to migrate standalone MBAM to SCCM for bitlocker

    November 10, 2:32 pm

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2024 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.