So I have gotten this far from information I have found but what I need to get is the names of the individuals that belong to this group and not the actual groupd name. Don't query active Directory much so don't really know what I am doing. How do i get the personnel whom belong to this group.
select cn, distinguishedName
from openquery(ADSI,'SELECT cn, distinguishedName
FROM "Sever Name"
WHERE objectCategory = ''group''
and CN = ''NGMN SEC J6 Voc''