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

Full Details :

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

Leave a Reply

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