Close Menu
    Facebook X (Twitter) Instagram
    Friday, May 16
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»SCCM report Computers not member of AD security Group with OS Details

    SCCM report Computers not member of AD security Group with OS Details

    Eswar KonetiBy Eswar KonetiSeptember 13, 11:05 am1 Min Read SCCM 2007 3,909 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Full Details : http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/83aaf1dc-eaa9-4612-8ee2-a80020d79d0b

    select sys.Name0,OS.Caption0 from v_R_system sys
    inner join v_GS_OPERATING_SYSTEM OS ON os.resourceID=sys.resourceID
    where sys.ResourceId not in (select ResourceId from   v_RA_System_SystemGroupName
    where System_Group_Name0 = 'TIGA\W2K3SecurityBaseline' or System_Group_Name0 = 'TIGA\W2K8SecurityBaseline')
    and OS.Caption0 like '%Server%'

    Computer not part of AD sec group OS Information sccm report SCCM Report Subselected Query
    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.